skysight-inc/HackerNews huggingface dataset:
Ditto.

I started out writing joins in the where clause; i'm not sure why, probably because that's how it was done in the first book i read. I then worked with some old Oracle hands who also did it that way, probably because of tradition. A year or two ago, i rediscovered the explicit join notation, and switched over to it completely in a matter of days.

As you say, explicit joins are right because they separate which tables/which relationships and which rows. Those are not particularly distinct things in the pure relational algebra model, but they are fully distinct in practical use.
Date and Darwen's rants were exactly what I had in mind when I posted that. Although I didn't know an actual implementation of D existed in the form of D4, which is interesting.
> It may be better for commercial users, because they don't have to give back their improvements, but it's worse for the project itself for the same reason.

OTOH, another perspective is that the GPL is worse for the projects because the restrictions it imposes may make people less likely to touch it at all, and those who don't touch it aren't going to give anything back whether they have to or not, and commercial users demonstrably do give back to projects that are under licenses that don't require them to do so -- and even pay people to work directly on the projects.
Intellectual property is permission to prevent other people from doing something.

In the case of trademarks, you are allowed to prevent people from using a particular name (in order to keep that name unique and meaningful).

In the case of patents, you are allowed to prevent people from "using your idea" (even if it's also their idea). Supposedly this encourages people to develop ideas to the point where they're actually useful (and patentable), but looking at history they don't actually help.

In the case of copyright, you are allowed to prevent people from duplicating or building on your ideas (but in theory not from doing the same thing independently). Similar to patents, this doesn't appear to provide the benefits it's meant to (but it isn't quite as clear).

In no case is an idea a piece of intellectual property. Instead, the property is the right to prevent certain actions. The two cases of (attempted) intellectual property theft that I've heard of are the lawsuits by SCO around the Unix copyrights, and some guy in Florida (I think) who sued the author of some open-source Java model railroad software (I think this had to do with patents rather than copyright).
I don't agree. There's many a programmer I know that can troubleshoot a tube radio, then go write some Lisp. Most are old school folks that grew up in the 8 bit days of solder and wirewrap.
France's Data Protection agency issues their maximum monetary penalty to Google
I'm a physical scientist, work in biology and computer science, but cannot understand this paper for the life of me. Can somebody sum it up? It seems to start from a premise that makes no sense ("computronium" as a form of physical matter distinct from other forms of matter) which strongly contradicts the current mainstream understanding of vitalism and dualism.
Mobile Metrics Daily Active Users Don't Matter
Future development will all be open-source.
Of course, why would they?

The interesting thing is the motivation. BMW want to make a better car, to sell more cars. Google want self-driving to free up driver's time to consume media, which will be covered in advertising - exactly the same as releasing Android to drive mobile Internet usage. But just as Google acquired Motorola, which automaker is in their sights? GM?
Yahoo malware enslaves PCs to Bitcoin mining
Right now the python plugin works by running a little tcp client and connecting to LT's main tcp server. You'd just need to flip those. The Clojure nREPL stuff does this, though it might be a hair bit more complicated than what you'll need for the python one: https://github.com/LightTable/Clojure/blob/master/src/lt/plu...

Past that, you'd just need to add something to the python plugin that runs a tcp server in your process and then hooks into the python running code that's already there. https://github.com/LightTable/Python/blob/master/py-src/ltma...
It was in spam. Replied!
This sounds like fun. Perhaps Gen. Alexander could be invited to MC the event.
"I would like" was me asking politely.

My arguments are mostly about the difference between "QT can be done in the lab" versus "QT can be done outside of the lab with commercially available equipment", and also "can QT transmit information faster than c?". The answer to the latter appears to be no: http://physics.stackexchange.com/questions/34653/is-it-possi...

http://www.nature.com/news/data-teleportation-the-quantum-sp... asserts that entanglement survives transmission over long distances, not that this can be used to transmit information any faster than the photons travel.

Also, starting this conversation with "hahahaha :D" was .. unhelpful, along with claiming things that contradict the experience of experienced people.
Kickstarter's staff is full of self-embracing hipster narcissists. They don't deserve the success they've had with old school video games. I personally know some of the people involved in these million-dollar campaigns, and Kickstarter has treated them with indifference at best. Real world Karma doesn't come from clicking a DOM element, but real world Karma will be visiting Kickstarter soon. It's already showing in the rise of competitors that would not have stood a chance if a this self-satisfied narcissistic bunch was not in charge of Kickstarter. The trouble with competitors is they don't understand the internal, gamified elements of the backer-base.
Onetoday by Google
You only need a jvm to use the clojure(script) language mode. You can use python/js/html/css modes without a jvm.
USD to Bitcoin in 30 seconds via Lamassu ATM at Silicon Valley Bitcoin Meetup
Show HN: Gitator - Find awesome repos on basis of your GitHub profile.
This looks awesome! I made a similar thing for bitcoin at a hackathon not too long ago (https://github.com/zachlatta/bitroad). I'm really looking forward to seeing where you guys take this!
Lol. Hell yeah !!
I have worked in both, and I really like open office layouts more. It works well for me and the open spacious environment really helps my mood especially in the winter. I'm pretty good a tuning out surroundings though, so I understand that can be frustrating for some when trying to concentrate.
Cheap crappy beer and junk food are popular too.
> For example: It is an easily observable phenomenon (e.g. by anyone who meditates) that you can be conscious without remembering anything. In other words, consciousness is independent of something like memory.

If you're meditating, how do you know that you're meditating without having, at minimum, a working short-term memory? If meditating actually disabled your memory, wouldn't you immediately forget that you were meditating and stop?
A single unconnected atom would be a gas, right?
One of the best books I've seen takes this approach:

http://www.amazon.com/Code-Language-Computer-Hardware-Softwa...

~

Starting from either extreme (pure maths or pure electrical engineering) is quite healthy--starting in the middle, though, does a disservice.
The Technology Behind the NYTimes.com Redesign
I am also in my late 20s and have worked in situations in which I've had my own office and situations in which I had to share my office with one other person. I much prefer having my own office. I dislike the feeling of always being watched in an "open office" environment. If you can take out your headphones, why can't you call a colleague or go into her office?

I'm also not sure there's a generational difference in how "differently [people] approach and accomplish tasks."
So we've seen a lot of "open offices are bad" articles but they rarely are accompanied by any solutions.

Anyone have any better ideas?
There is no "mind emerging from matter" in the same way a hand does not "emerge" from fingers and a palm. This is because the label we apply is only in our heads. Reality is perfectly ok just being a bunch of quantum interactions; it is humans who have to label things "chair" "hand" "conciousness". Reality is reductionistic.
Recursive CTEs are super amazing. One of the great underused features of SQL. Give me tall PostgreSQL and a WITH RECURSIVE to steer by, and i will happily take on any graph database.

Not promising i'll win, mind.
To stop procrastinating, open HN, see article about procrastination, pause, close window and go back to work.
Stop Writing JavaScript Compilers, Make Macros Instead
Be The 1,000,000th Droplet In The DigitalOcean To Win $10K
I had a private office with a door before I ever worked in an open office layout. I currently do not want to go back to having an office at all, but there's an enormous caveat there: I don't want to go back as long as the team is good. I've seen other teams where it quickly turned into a really bad situation, and can see how easily it could be a nightmare compared to a private office situation.

More important than the office layout is having a good IM setup that everyone uses, IMO. Even when you have your own office there are people who'll knock on your door which is more of a pain to deal with then just wave them away with a "not right now," IMO, if you don't have some other way of communication for trivial questions or indicating status.

The other thing an open plan has to have is lots of small conference rooms you can jump into at any time either for a discussion with other people or just to take advantage of silence for a while.
Introducing Lumo Lift
The linux kernel is much smaller than the entire codebase of Facebook.
> If I have my headphones in, I'm busy. If I don't, I can answer questions or talk to my colleagues about something.

This comes up every time people discuss open floor plans. Inevitably someone says that the solution is headphones. Except that a lot of people don't want to wear headphones all the time. I find it uncomfortable, and I also find that music significantly reduces my productivity (unless I'm doing something that doesn't require any meaningful amount of thought). A number of studies have shown the same thing. Listening to music while working decreases mental power.

The article also covered this:

But the most problematic aspect of the open office may be physical rather
than psychological: simple noise. In laboratory settings, noise has been
repeatedly tied to reduced cognitive performance. The psychologist Nick
Perham, who studies the effect of sound on how we think, has found that
office commotion impairs workers’ ability to recall information, and even
to do basic arithmetic. Listening to music to block out the office
intrusion doesn’t help: even that, Perham found, impairs our mental acuity.

> I can't help feeling that younger people such as myself

I don't think you're as much different as you imagine. Young people don't work in drastically different ways than older people.
Yes, it's quite apparent in practice that WHERE constraints are not being propagated back into CTEs in cases where they clearly could be, so that's something to look out for.
...then come back to HN to post pithy comment, then go back to work.
This isn't really new, we known about issues regarding open office plan since the 1980s. I think it's mentioned in Peopleware at least.

So why is it that companies keep building open office spaces? Are people really so focused on short term savings that they do not care that it will cost more in the long run?
So what. What does that have to do with anything? We're not talking about imperative models vs functional ones. And even if we did, imperative programming has nothing to with what you're suggesting. For example, it is always preferable to explore and study algorithms and data structures in higher-order languages so that you don't get bogged down in irrelevant details.

CS departments are going to structure their programs in multitudes of ways. My point is, there's nothing wrong with not being concerned about teaching first-year undergrads microprocessor architecture and the nitty-gritty of memory management and OS design, but instead starting at another end of the Computer Science spectrum. Being exposed to lambda calculus and functional programming early and even viewing the Haskell run-time as some 'God-given black box' is not a bad idea.
Somewhere around 90% of U.S. Jobs were automated out of existence in the late 1800s/early 1900s. Is this time different?
Ask HN: If you're a dev and not on Github, how am I supposed to find you?
Like, are there good reasons to not build up your Github profile?
Surely you won't get onto an Economics degree course if you haven't already studied economics in high school? I'm from the UK and there you can study Economics from 15.

Also, surely the interview will ask you about your background knowledge of economics, and if you didn't know who Keynes was you're unlikely to get an offer.
For effective career advancement - best practices for interview and search.
Status difference can take many forms other than management hierarchy. Indeed, one big problem with management hierarchy is that it messes with the "native" status system of the creative disciplines, which is based on technical merit and peer respect. That contradiction is well known to most of us who have spent time on a software team at a non-software BigCo.

So the point is not to get rid of status difference (which would mean replacing human nature and thus be foolish) but to find organizational forms that are better aligned with how creative work gets done.
In theory, there's no difference between theory and practice--in practice, there is.

All abstractions in computers and software engineering are leaky, and you either learn enough to overcome the limitations of real machines or you learn to regret your ignorance.
Would be great, until you had more than one in a room - what a mess that would be.
I think that's more valid to parenting than to teaching. For me to call one a teacher, one has to have:

(1) Something to teach me.

(2) Willingness to teach me.

(3) A serious attitude towards teaching once he decides on that.
> Intellectual property is permission to prevent other people from doing something.

Property -- not just intellectual property -- is the legal power to exclude others from some set of actions.
I don't want to force anyone to take part in a particular debate if they feel they have nothing to add. But not taking part in a debate and denigrating those who do want to debate an issue are two very different things. It's the latter that irks me.
How cool is that :)
I must say we've built something quite similar. Would love to have feedback on the product :)
sigh no way to get an ARM build going, though, nor more pointers for doing so with node-webkit. See https://github.com/LightTable/LightTable/issues/703 for more info.

(Build instructions currently consist of dumping part of the current binaries and rebuilding the CLJS bits, which is straightforward but doesn't help much with porting to other archs)
Anyone with ideas on how can I start my "perceptronium mining" business?
Private offices surrounding a shared area. It's not really that hard, just more expensive to build.

Take a look at how FogCreek designed their office.
The kernel is measured in hundreds of megabytes. There are companies with codebases measured in terabytes.
Not all code developed professionally is open source.
We specifically tried using CloudFront, solely for it's ability to serve as the target in an ALIAS record. However, CloudFront is useless for dynamic sites because it does not support passing the original Host header back to the origin. Any site that serves localized content (including localized redirects) is doomed by this inadequacy.
Student designs £85 machine gun that fires 14 RUBBER BANDS a second
You began this discussion by saying that a Supreme Court decision can be unconstitutional -- practically a contradiction in terms, and also legal statement. Now you're trying to switch subjects and say you were talking about morality the whole time? Morality is utterly irrelevant and subjective. I don't care about what you think is moral, that's why we have a Constitution in the first place: so we don't have to pick which moral code to observe!
Reminds me of Canyonero [0]

[0] http://simpsons.wikia.com/wiki/Canyonero
Yes, as far as the standard is concerned you are wrong. See http://dba.stackexchange.com/questions/27425/is-the-optimisa.... But it is a very common misconception you can hardly be faulted for because it is the way postgres does it and many people claims it is due to the sql standard.

Of the only annoying features in postgres, imho. You have a large query and you try to break it up into smaller self-contained cte parts and voila, performance goes crap.
I'm sure a lot of people here have a lot of ideas. But there is a big difference between "an idea" and "a good idea".

I have a lot of ideas too, but I often find a rather critical flaw somewhere sooner or later, or I fall out of love with the idea because in the end... it wasn't that good.

Finding a truly good idea, one that still stands after weeks of simmering, that looks good under all angles (product is actually buildable, the customers are there and reachable and willing to pay, you're not likely to have to compete with the Googles of the world, etc..) doesn't happen all the time. Discovering a hole in a market, and realizing a lot of people are walking right past a gold mine that you believe is there is something you may want to keep close to your chest. Especially when you're talking to other entrepreneurs.
That real great man. (Y) why dont you talk to Nikunj, i guess he is the one who have created it, nikunj@mywindow.me you might collaborate in some way
Separate offices for at most 3 or 4 people who need to cooperate closely, with doors that close. Using glass walls you can get the same spacious feeling as an open office without the noise.
It's worse than just a tiny picture: my ZR30w cannot display any source formats not 2560x1600. So I cannot connect it to any game consoles, a Roku box, etc. Only a PC video card.

But it does result in an astonishingly low latency, at least.
Bah. The bottom of the stack is quantum mechanics and solid state physics. From there, you learn how individual transistors work. From that, you build up to logic gates.

I actually know something about those levels. But in 25 years as a professional programmer, the lowest level I've ever actually needed to use was at the gate level (PAL equations to generate chip selects by decoding addresses - if it wasn't in a PAL, it would be just equations).
Top Christie Staff Sought Lane Closings as Revenge
We've opened up a little lately, and some of our DDOS mitigation details are now available in my colleague Nate's talk from Re:Invent: www.youtube.com/watch?v=V7vTPlV8P3U .

What I can repeat from that talk is that we've handled DDOS attacks in the same orders of magnitude that are as large as anything else we've ever heard, that we use them ourselves for our own services.

We'd certainly be interested in a conversation about your needs, attacks you've experienced, and how we can meet them. (e-mail: colmmacc@amazon.com).

ELB is a multi-IP service and can dynamically scale from 1 to ~100 IPs. In general, when scaling down, IPs are retired from DNS but aren't removed from an ELB until we've seen traffic drain (which would explain the hour, but it's variable). If you want to know all of the IPs for an ELB, you can query;

all.[elb-name].[region].elb.amazonaws.com
all.ipv6.[elb-name].[region].elb.amazonaws.com

and you'll get them all. Though we strongly recommend against CNAMEing to those names directly, it can useful if you need the scrape the IPs systematically for some reason (and it sounds like this might be such a case). I'm not sure what other workarounds may be available via CloudFlare.
Same thing happens with design patterns. It probably happens with all sorts of non-obvious but powerful ideas. Hmm. Any sufficiently advanced learning is indistinguishable from madness?
For certain types of projects (like hardware projects), some of the mid-tier rewards are essentially pre-sales. For example, with Pebble, the most popular tier was the $115 watch. People interested in the product, I suspect, are more likely to contribute to the lowest-price deliverable tier rather than the lowest-tier.

Of course, for other projects, there are some high-tier rewards that garner significant interest and skew the average. For example, the Veronica Mars kickstarter had a speaking role as the highest-tier reward.

The median contribution, from what I've seen, sits somewhere in the 50-250 range
everyone of us want Firefox OS (to) win

We do?

I'm not sure that I care one way or another. Does the device work as expected? Does it do useful things? Does it do the fun things that I actually want it to do?

Then I don't care much one way or another.

On a related but possibly tangential digression, I'm showing my age, yes, but I want my TV to be a TV - a device for showing for moving pictures provided via a suitably optimized device of another ilk (I'm quite happy to accept the second function of OTA tuning, just 'coz it's pretty much always there and saves me buying another device - what with having cancelled cable about 18 months ago).

So I neither want nor need it to have an OS.

There's an AppleTV sitting below my TV. It has an OS. I don't give a damn - it works pretty darned well, thanks.

I don't know what's inside my receiver to give it Internet capabilities, and don't care - I use them very little, when my 20 year old receiver died, I bought the best value receiver that had the features I wanted: 7.1, AM, FM, CD in, Aux in.... Yeah, that was about it. AirPlay is nice, glad to have it, use it occasionally, didn't want or need it, but its presence was no deal breaker. Internet radio? Don't use it at all. DLNA? Didn't even know what it was when I bought the thing. Don't use it at all right now (don't have a media server, why would I want one? I have Netflix and AppleTV and all of our Airs can stream to AppleTV directly).

I never want to buy or receive media again, they take up space, gather dust. I'll read books when they are given to me, or when they are the best form for the content, e.g., books that are image-heavy, but otherwise Google Play Books serves me quite well, thank you.

Did I mention OS in any of that? Hmm, nope.

Don't know. Don't care.

And the OS won't prevent any of the ills that come with any of the above, e.g., DRM-enabled-yank-back, unless you the user are going to pirate to get around the DRM.

Technology cannot solve that problem, only the law and the market can, and they need us - all of us - to realize that technology is not the solution and to get out there in front of the issue and agitate for changes in the law and market.

Why sure I care which OS wins? I'm pretty sure I don't. But I am willing to entertain serious answers to a serious question. Fire away.
Stanford have done some interesting work on this: http://www.youtube.com/watch?v=gzI54rm9m1Q

IIRC Stanford's motion planning relies on blending from a plan based on a physics model to a choice of learned operations programmed into the car by a stunt driver. Makes sense for demos, but I don't know how well it would work if surfaces or driving conditions were different from when the operation was taught.
There's a line somewhere, just not sure where it is...
The Most Interesting Survey in the World: the General Social Survey (1972–2012)
Also, don't forget, you can pull down the entire Stackexchange database contents, for free.
Thanks,my website got down because of this huge traffic.
That's what I've been wondering. I know VW, Daimler AG, Toyota, Volvo, BMW, and others have making pretty good strides in self driving tech, but it seems most American car companies are pretty far behind already. I wonder if Google intends to license the tech out to the companies who can't or won't do it themselves, or if they decide to pull a Motorola and enter the manufacturing market at some point in the future.