skysight-inc/HackerNews huggingface dataset:
> Consider the hated multiple primary key situation where you've got a autoincrementing prikey and a "real" key where you make an unique index off "full name" or something. So which is the real conceptual primary key?

If the full name is a real conceptual primary key, you shouldn't have introduced an autoincrement key. If the uniqueness of the fullname is a business rule but not a real conceptual restriction (a distinction which can be hard to make, to be sure), then it makes sense to create the autoincrement key -- and it is the only real primary key. (That is, the autoincrement key represents the concept of identity which isn't present in any of the other data.)

> On the other hand lets say you implement just a prikey. Now you can have multiple rows with the same data, because you never set up a UNIQUE INDEX.

No, you can't, because the "prikey", as you call it, is data, and has meaning -- specifically, it represents identity -- so rows which differ in it do not have "the same data".
Very cool and simple. The notion of "time" may be a bit misleading but actually the client just requires to generate an unguessable rand, think at it like getting a string from /dev/urandom, so actually time is completely not part of the protocol which is great (also avoiding to deal with client IDs can be nice in practice).
No. Incompetence isn't potentially harmful, it is invariably harmful. It creates environments with a slavish adherence to protocol unsuitable for purpose. If you are sufficiently old you have seen workplaces like that and if you have any sense of purpose you got out of them as fast as you could.
> Is it perhaps the stigma that comes with using a product developed by Apple?

Probably some stigma but also corporate history of working only semi-successfully with opensource. launchd has some weird things (e.g. use of XML plists) which only make sense for Apple and it doesn't have every feature which a major Linux distribution would need – would you want to bank your user experience on being able to get those changes merged into a project which is controlled by a single company?
Some of the tools USV portfolio companies use for biz dev
Show HN: It's hard to make friends offline, so we built a solution
In SQL Server a HAVING without GROUP BY is a way to filter out duplicates.
One of the reasons the estimates for Peak Oil are off is because oil companies only project the amount of oil they can economically recover. However, because the price of oil continues to go up they start to consider more options economical, such as tar sands. If you read literature on how these companies determine the size of their reserves and how much oil is left that can be extracted economcally, the answer is pretty much consistent at 40 years, but this measure has never been an accurate account of the total amount of oil in the ground, its just a number that makes sense for their business.
this is a good question. my experience with the django ORM is that in general it resolves any call to an ORM method into SQL and nothing else, but it is not guaranteed to generate the most optimal SQL.

It is however, a somewhat common practice of django devs to to do some post-processing on a queryset in Python. totally acceptable for small querysets with complicated logic, but, yeah, obviously unacceptable for large performance critical queries.
The best thing you can do is to start making mistakes
Still no option to make me a sandwich :(
5th amendment jurisprudence requires the threat of criminal proceedings to be real, not baseless speculation ("The likelihood that a survey in which an American public school student admitted drug use would not find its way into the grubby clutches of law enforcement is approximately nil.")
> ps Does anyone remember the series of images comparing Orson Wells with someone else regarding the overload of bad/junk information?

You're referring to Stuart McMillen's comic-style adaptation of a part of Neil Postman's book, "Amusing Ourselves to Death". Though McMillen has removed his poster at the request of Postman's estate [1], you can still find the comic on the internet [2].

1 = http://www.stuartmcmillen.com/blog/cartoon-blog/amusing-ours...

2 = http://www.juxtapoz.com/current/huxley-vs-orwell-in-graphic-...
You're mixing two definitions of inflation. Bitcoin undergoes monetary inflation as the supply increases until the late 21st century. Since the supply increases more slowly than the demand for the currency increases, the bitcoin economy sees price deflation. This isn't a particularly interesting phenomenon because it's common for the value of a currency to increase (price deflation) even as the supply of the currency increases (monetary inflation). This is what happens with gold when it is used as a currency, for instance.

When the terms "inflation" and "deflation" are used without qualifiers, they usually refer to prices, not money supply.
Non-flat easily takes the cake in this comparison. The shadow on the flat design is not even remotely accurate for a shadow, it makes me feel like my world is spinning. The buttons, besides actually looking clickable, make me want to click them. As far as design in general goes, it also looks like someone made the buttons worse on purpose for the non-flat version, which is why you probably like the flat version better. Why is there a black stroke? Why is the black text not the same dark blue that the rest of the layout uses? On both designs, why is the checkout button not lined up with the gray edge or the item text?
If you are new to Spring, then you should start with the current edition of "Spring in Action". It's a good read.
I agree they are a flawed currency, I don't agree on your solution.

Not only is 10 an arbitrary number, but it sounds like a lot less than some people would like to give, and a lot more than most people will give any way.

Why not have the best of both worlds by using a PageRank-alike system to determine the weight of any given like.

That way, if someone is spamming likes they won't affect any one item very much compared to someone who likes only sparingly. You can go the whole hog and have the system where heavily liked users are more powerful than non-heavily liked users also.
I'm wrapping up the degree in a few days, so that's one less item on my plate. Funny one of the things you suggested I can get rid of, is my child, surely you're joking Mr. krickman!
> Honestly, with the hate-mongering, the amount of rumours dressed like news on these high-traffic websites flooded with so called keyboard-warriors, I actually welcome something to counter it... however...

I am absolutely certain Orson Welles would not be seen dead in your company (unfortunately, he's not around to complain).

Attitudes like yours have been exploited to justify every limitation on the freedom of speech in the history of limitations on freedom of speech - and it's very long. You're what a certain imposer of these limitations referred to a useful idiot.
To some extent that's true, but the crowdsourced data probably exaggerates it (I suspect American leisure travellers are more likely to submit their flight details to an open source flight tracking project than Angolan businessmen). London to South African routes operated by multiple carriers are conspicuously missing.
"Because you can only click ‘Recommend’ 10 times in a day, you can’t go gallavanting about throwing them hither and thither; they are to be reserved for the photos which you think other users should see."

This just puts the problem somewhere else.

Now, the new problem is a follower becoming "a flawed" currency. People who try to bot likes will now bot followers to get more likes.
But adoption doesn't affect this, in fact it was more strongly negatively affected in 2010 when adoption was overall lower.
I disagree. Considering the way likes work on platforms like Facebook, by Liking something you are advertising your interest in it. Viewers of your profile can see (and judge) the things that you have liked and also you create a story visibls to you friends in the ticker when you Like something. I know some of this is inherent to Facebook, but similar features likely exist on other platforms as well.

Capping it artificially stifles users who may actually enjoy photography more than others. A critic would presumable like photos far more often than a casual user.
I don't think this is practical - even if the Malaysians allowed it, Johor Bahru is north of Singapore and the main population centre and business district of the island is along the south coast.

Signals at such high frequencies simply wouldn't penetrate the extremely dense urban landscape of Singapore other than along a narrow northern coastal strip.
Pretty much, yeah. This is really just a generalization of the principle we see in the length of a binary password. The complexity is s^l, where s is the number of symbols you can possibly draw from, and l is the number of symbols in the password.

Consider a binary string. There are two symbols in binary (1 and 0) and the number of symbols you use is the number of bits in the string. This gives us the familiar password length calculation: the complexity is 2^l.

When you start using words as the basic unit, you gain many more symbols: if you use the full Oxford English Dictionary, you have about 600,000 of them. But when you do this, your symbol is no longer a single byte: it's a word. That word can be represented as a string of bytes, yes, but it's guaranteed that this string will be one of the 600,000 byte strings that represent English words, and you can eliminate all of the others. So you can't measure your password in bytes anymore; you have to measure it in words instead. A one-word password is, therefore, of complexity (600,000^1).

Six hundred thousand possibilities sounds like a lot, but computers can crack that in seconds. Even if you restrict yourself to just printable ASCII, you can do better than that in only three characters. I don't recommend actually doing a three-character printable-ASCII password, because you'd have just under 900,000 possible passwords: still well within crackable range.

But because the complexity increases so fast as you increase the length of the password, that's how you can gain complexity back. If you use four words instead of one, you have (600,000^4) possibilities: some 130 sextillion. You'd need 70 random bits, or 11 printable ASCII characters, to do better.

And that, my friends, is why "k[0" is a better password than "antidisestablishmentarianism". But it's also why "correct horse battery staple" is better than either one (or would be, if xkcd hadn't made it so famous).
In your example, for each row of the result set

* "em.departmentId" will contain one of the distinct values from the "departmentId" column

* "salary" will contain the maximum value of the "salary" column of the table rows whose "departmentId" equals "em.departmentId" of the given result set row.

* "em.EmployeeID" will contain the value of the "EmployeeID" column of one the table rows, whose "departmentID" equals "em.departmentId" of the given result set row, but it is UNDEFINED which one. It IS NOT quaranteed to be the one whose "salary" column equals "MAX(salary)".

See here for examples of how to achieve what is actually needed:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-colum...

As I said, tricky, and, judging from the difficulty level of the other questions, I suspect that the authors of the article have fallen for it themselves.
The service seems very useful, and executed well. The name sucks. I don't know how to pronounce it.
I can't speak highly enough of IDoneThis - we've been using it for months at Buffer and it's absolutely changed the way we work. The reasons IDoneThis is invaluable to us, is that it allows us to track back performance (which easily gets lost in a chat room or an in-person standup). On top of this, if new people come on board, they can look through the previous IDoneThis notes and see what has been worked on. Oh and of course, not to mention that it's amazing to keep in sync with everyone if you are working as a remote team like we do. IDoneThis has changed our productivity for the better.
3 of the Best SaaS Customer Referral Program Examples
10 people you should know that are redesigning how the Internet works
There is the page visibility API:

http://www.w3.org/TR/2011/WD-page-visibility-20110602/

Supported in Chrome, Firefox and IE10.

MDN has some information on how to use it:

https://developer.mozilla.org/en-US/docs/Web/Guide/User_expe...

I don't think there is a way server side to detect if the request is for a pre-render or not since I don't think it sends any special headers or anything like that.
There's an interesting idea here, but it takes some teasing out.

For one thing we need to pin down the word "like", which means something specific on Facebook and often something different in other places unless those places are playing the Facebook like game.

My gut feeling about social is that it a game of statistical sampling so it never hurts to get more data, you can always decide to throw some of it out later. So getting as many interactions as possible makes sense.
"One of your questions is wrong" is an excellent filter. People should be thrilled to get that information.

I corrected two questions on a multiple-choice test that a finance firm gave me. They flushed me out after I handed in my personality test, so maybe it was for the best.
You're right and we're working on making all that more descriptive.
Yes. I just tested it by searching for [haskell dbus] and clicking a result link to my site. Here's the referer in my nginx log:

2620:0:1000:3509:ed78:b06d:4942:90e1 - - [28/May/2013:17:35:00 +0000] "GET /software/haskell-dbus/ HTTP/1.1" 200 5819 "https://www.google.com/search?client=ubuntu&channel=fs&q=haskell+dbus&ie=utf-8&oe=utf-8" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:21.0) Gecko/20100101 Firefox/21.0"
Its nerd central. Which means that you will come into contact with a lot of people who are like you. It makes the place unique, because there is simply no other place in the world where that happens. Well, maybe in akihabara or the chinese hardware market, but no other place.
What about other tools like: Open Source PaaSs, Open Virtual Machine Formats, OpenShift, OpenStack, Cloudify, CloudFoundry, Hyper V, KVM, Xen (XCP), Virtual Box, AMI, LXC, OpenVZ, GlusterFS, Ceph, OpenStack Object Storage (SWIFT), Sheepdog, OpenFiler, Provisioning and Monitoring tools, like you said Orchestration/Automation & Configuration Management tools, Cobbler, Spacewalk, Kickstart, others like Cfengine, Cacti/RRDTool, Nagios, Zabbix, Zenoss, Capistrano, RunDeck, Func, MCollective, and others. Then probably choices between choosing the OS: Debian, Fedora, maybe Arch Linux for those that like that.

These, and probably others that I don't know, are the choices that someone, who believes in not pursuing in anything proprietary, that also wants to learn to build an OpenSource IaaS, or PaaS stack for their product- are researching into but cannot find a straightforward guide. Advocating working with OSS, and teaching people how to use OSS tools will lead to more jobs, so keep at it. I subscribed to your email list...
Proving Performance: Hadoop On vSphere – A Bare Metal Comparison
If there's an outrush of processing power, adjustment in the easing direction won't be as fast. (At least one smaller, post-Bitcoin cryptocurrency has faced a crisis when a large amount of hashpower withdrew... because the remaining hashing would take 'forever' to even advance to the next 'adjustment point'.)

So this question is a bit early to call.
Where are you getting $5000 and 20% from? It would take a skilled designer no more than an hour or two to polish that up. I mean, you switch from all-caps title text to regular case - why? YOU could polish that up and make it look immensely better with maybe 15 minutes more work and thought.

I already don't like to-do apps, but I wouldn't even download one that didn't look fun, interesting, new and beautiful. Simple as that.
>>There are plenty of data scientists working on OS hacks, compilers, and other "hard engineering" topics.

Can you give some examples on this? Seems very interesting.
Looks pretty interesting.

If you are using adsense on your website, be careful: http://www.seroundtable.com/chrome-prefetch-bug-relnext-1643...
That makes two of us, so I rooted out an official source:

https://wiki.mozilla.org/index.php?title=QA/H264-AAC-MP3_sup...

Looks like the blog is incorrect.

I'm curious if part of the H264 move has anything to do with FireFox OS and the plethora of mobile chipsets with hardware acceleration.
It's "lose weight", not "loose weight". Sorry to nitpick.
A central banker could easily achieve a perfectly accurate prediction of the amount of currency available, which is the type of prediction we're talking about. They print the money, so they can just print according to their predictions.

The types of central banking predictions that are usually criticized are predictions of prices in the economy. Bitcoin fares no better there.
http://www.bitcoinx.com/charts/
I think tranisitioning to natural gas is silly. Its at best a bridge technology before an eventual tranisition to solar. Given the opportunity to leapfrog a generation of technology and infrastructure while doing less damage to the environment is a now brainer. Plus, investing in solar gives the US the opportunity to liquiefy the natural gas and export it, helping the trade imbalance and displacing the new coal fired plants being built abroad.

When building a power plant the expected return is usually about 40 years. We shouldn't be asking ourselves what infrastructure we want in 5-10 years, but how we want our energy infrastructure to look in 30-50 years. In 30 years I'm pretty confident solar will be cheaper than natural gas, so why build out all this infrastructure to switch to natural gas cars etc?

At best natural gas is a good resource for handling the intermittency problem with solar. Gas power plants fire up and shut down very quick and efficiently comared to other types of power. Thus they're a great compliment to a power source that currently cannot be stored for night time use.
How to Get People to Read Your Startup's Emails
Integer programming for the win! I freaking love Solver (well, OpenSolver.org I love...regular Solver I like with some distain mixed in)
I always use table aliases as a matter of habit:

* I always specify columns as table.column, not just column as it makes things explicit where the could be ambiguity if a less experienced coder is looking (I know that column reference in a correlated sub-query refers to the most local instance of that table, but having the table name there explicitly states that referring to that was my intention and not an accident). Having short aliases saves typing in this instance (though not too short/arbitrary - the object names should still be meaningful in the context of the query: a, b, c, d, ... would generally be bad aliases)

* If the query gets more complex and needs to join objects in that have columns of the same names as those in existing objects (especially if you add another reference to an object already in use in this query), you've already got the aliases there for the first instance reducing the chance you'll get one wrong when adding them in for both instances of the same name.
PayPal denies to pay Bug Bounty reward to teenager - The Hacker News
Singapore has an interesting government in that it's a single party, rigged system (by US standards) where the leadership is generally very popular. A true "benevolent dictatorship" if you will.

On the other hand, I would not want to be anywhere near the place if the ruling party actually loses an election, as freedom is not high on their agenda.
I use to use full table names if only to avoid inconsistency with aliases in other code. Now I use aliases and ignore inconsistencies. Being a purist wasn't worth it.
Wow I did not know that Excel ships with a constraint solver and has since 1991 - http://www.utexas.edu/courses/lasdon/design3.htm
How do we know that was the cause of his adsense ban?

If you read Google's own page on prerendering:

https://developers.google.com/chrome/whitepapers/prerender

"If your site includes a third-party script for analytics or advertising, in many cases you shouldn't have to make any modifications to your site—the third party will simply modify the script they provide slightly to make use of the Page Visibility API. You should contact the third party directly to see if their scripts are prerender-aware."

I'd assume Adsense would of implemented this and would be prerender-aware.
Yes, I would, I have, and will do it again. Being a felon is not a standard definition. People can go to jail for very different things. Of course, I won't work with anyone who committed a violent crime, but I will consider people who have committed small stuff. You can't measure everyone with the same ruler.
Again, I think you are mistaken. Drugs and alcohol are common problems among teens, and school officials and counselors often try to help students with those problems.
Harvard Dean Who Handled E-Mail Searches to Step Down
Topcoat – CSS for clean and fast web apps
I'm sorry you don't like our name! We've kept it because most of our customers and members get a kick out of it.

As a counterpoint, editor of the Oxford American dictionary and founder of Wordnik Erin McKean is a fan of our name because it's memorable, lighthearted and fun. http://blog.idonethis.com/post/16062508107/lexicographer-ext...
The third format is OGG as Linux does not support H.264 nor VP8 out of the box.

That's a wrong claim. VP8 support on Linux is commonplace. As well as H.264 support (if we are talking about system frameworks like gstreamer and etc.).

Browsers is another matter, and they ship with their own decoders. Mozilla provides an option to use gstreamer for Firefox, but it's not built by default. Mozilla can't use built in H.264 decoders simply because it will require licensing and will make it non redistributable.

Also, OGG is not a codec, it's a container. The author probably meant Theora.
It really fascinates me that no one, not even in the comments on the Opera blog, seems to have noticed that you cannot add a new search engine. I guess people are happy as long as Google is available.

Opera Next aren't going to be released next week, so they can still migrate a lot of features, but I do agree with those who are concerned that they won't manage to move "enough" features to keep all their old users. I also wonder how fare they are will to diverge from Chromium, the further away they go, the harder it might be to keep in sync.

One have to wonder: "How important is the desktop browser to Opera business?" Do they make enough money on the desktop version to make it worth porting every single feature in order to keep all their current users?