skysight-inc/HackerNews huggingface dataset:
> LIMIT OFFSET queries are always going to be hard because you have to generate lots of rows only to throw them away

In fairness, that often depends upon the intelligence of the planner. A lot of sort-limit-offset queries can be reasonably easy and not generate too many rows if the planner works correctly and you have the right indexes.

edit: Assuming you're mostly picking up early pages as opposed to getting late ones, anyway - which is usually the case for, say, a comment system.
That's roc's point: Coulton's rights depend on what kind of license he paid for.
or Intel (whose modern power saving CPU's are probably inside almost everyone laptops?

or Toyota for making practical hybrid cars

PS: Although I enjoy Google products, they haven't 'invented' a single one. Search engines? Email? not exactly a Google innovation.
I put a similar setup together through http://buildyourcnc.com/PickandPlaceMachineTheredFrog.aspx
honestly, i really don't know. But i've noticed from comments on different sites that some commenters:

1. Know those who are biased towards an idea

2. Know those who frequently invent stories.

Maybe the solution requires AI that's not possible at the moment.

If something can just tell me 'hey if you want an accurate view of topic X stay clear of Mr Y' or 'Site X has a story fabrication rating or XX' it would be very useful.
Nancy and jtable
But if the government can confiscate the server they also can make it deliver modified JS. If you can't trust the server you also can't trust the JS it gives you.
Brain Hacking for Dummies
Maybe overblown, but it echoes complaints I've heard from other bioinformatics people.

Surely this means there's a goldmine waiting there for someone to produce a non-broken toolchain for bioinformatics?

Or is it even possible to produce standard tools? Maybe all the labs are too bespoke?
The Raspberry Pi has ethernet on board.

http://www.raspberrypi.org/wp-content/uploads/2011/07/751305...
Except the silly 'False = True' at the end. How's that useful?
mail at arsalanbashir dot com :)
Pretty much my reaction. Who the fuck uses pickle to maintain state!?

Answer: Apparently everybody.
First, not all suffering makes lives more meaningful. It's the process of suffering through something and prevailing or even being overwhelmed and yet later finding a way to get back up that gives us meaning.

Second, we do not have the right to make others' lives more meaningful if they do not want them to be. The state's core role is to protect our rights. Libertarians and conservatives define rights negatively, while liberals also speak of positive liberties in addition to negative one, but this is the core premise of liberal democracy. What we do with these rights and liberties is up to us.

Of course there are exceptions: this is a big argument for having national service or conscription even in countries that can afford professional militaries and don't have hostile neighbors. I happen to disagree strongly with the idea of any kind of national service or conscription, but I don't find it something that should be dismissed outright and without debate.

More to the point, we do voluntarily inflict suffering on ourselves all the time: most obvious being physical exercise, pain of childbirth, but less obviously difficult academic programs (e.g., EECS at UC Berkeley or CMU). Indeed, we pay a great deal of money to have others inflict suffering on us as long as we're able to extract meaning from it.
or Microsoft for the XBox 'Kinetic' system.
Humans are not evolving (in the Darwinian sense). The closest thing is selection based on which parts of the population have the most children.

We are devolving in many ways: diseases that kill us or make us infertile are being treated so as to not kill us and make us infertile. With time, we might devolve to the point where we completely depend on modern medicine to survive and reproduce.
Probably better done with a defaultdict:

from collections import defaultdict
logins = defaultdict(list)
for user, date in getLogins():
logins[user].append(date)
I imagine you could pass a function

function(arg, i){ return i%2 }

as the `slice` parameter, but that's going into crazy territory.
"Thank god there is another sane person like me." Check your ego, please.

"I cant see any useful purpose for 6 second clips in a social wide audience context."

"I can't see any useful purpose for 140 character blurbs in a social wide audience context."
HBO 11th and SpaceX not even on the list...
Or NASA for, well, especially 'Curiosity'
> should we set out to inflict suffering on others for their own good?

Why is that your job?

Even if it's good for them, you don't have to be the one to do it.

And the same applies to everyone else, plus governments.
I can understand MySQL not being 100% compliant with the SQL standard. What I have trouble understanding is why it can't be bothered to throw an error. Imagine if your programming language silently ignored some constructs? But it seems to correlate with MySQL's philosophy of being good at silently ignoring problems :(
What is really interesting to me is how are they doing persistence.

Node and SQLServer? Sounds very harsh.
MongoDB? does that run on Azure?

My bet - their Node servers proxy to the old servers via dedicated API for data. Node should be fine at doing these requests due to its async nature.

Even when you run with Express, to build such a feat requires a TON of infrastructure (did you notice the X-Tracking, X-Response, etc headers?).

Much of the open source/public infrastructure in the Node ecosystem feels raw (example: loggers. did you see how many loggers there are? do you think they're production worthy?).

Though I would accept this and fix whatever I can (took me a while to find a proper hierarchical logger that is also async, for example), I find it hard to grasp how Microsoft would.
This makes me assume they built everything from scratch.
I don't see any difference between a single : and double :: in this case.

The second : might be included to make the slicing more visible.
You also have to ensure that "window.crypto.getRandomValues = function(y) {};" wasn't executed earlier.
Bill Gates eradicating disease is pretty awesome. His weird school ranking system in the US is pretty bizarre and utilitarian.

"Students would be better served by measures of which colleges were best preparing their graduates for the job market." is total corporatist bullshit. How about more free courses online like what MIT and Stanford are doing.
Previous discussion (517 days ago): (http://news.ycombinator.com/item?id=2935220)
Facebook 2nd? Seriously? I can't think of anything innovative Facebook has done in years. The last one I could think of is the "Like" button, and probably even that is pushing it.
Out of curiosity, what other computationally difficult problems are there?

I'm very interested in bioinformatics, but sadly don't know as much about the field as I'd like.
and Sony - because they just ARE an innovative company (the walkman/discman, betamax, minidisc, S/PDIF, bluray, professional broadcast and audio products.

Philips I've already mentioned, but companies like Toshiba give us lots of innovation with things like disc drives (I cant remember Starbucks ever developing a new type of fast, energy efficient storage media, although that did give us the 'mocha-choca-frappa-latte')
I am pretty sure this is the standard approach for doing almost anything int the business world.
Would love to see some analysis done on other StackExchange sites. This potentially a really good market research tool as well.
Yes. The purpose of using crypto is so that there is no less expensive and time consuming way to get the data then going after the server itself.
Ermh sorry to nag but after the google (et al) rogue certificates I think one would better say SSL is considered harmful as well....

Security is a set of layers and trade-offs.

Harmful for what? That is the question.

Your computer is considered harmful. Did you check the hashes of all the software you downloaded? Oh wait there are no checks to be done for the little app you got a couple of months ago...

So: take an enemy and look if what you do is reasonable enough.

Flying is considered harmful, hence the TSA.

Remember the github fiasco? But you still trust them do you? I might (I do not) consider github harmful as well.
(although I am glad NOT to see Dyson on the list for producing excessively expensive vacuum cleaners with little or no perceivable benefit
Along with other commenters, I think our society redefined happiness to mean something it doesn't. I normally dislike self-help books ("The only way to get rich from a self-help book is to write one."), but on someone else's recommend I picked up: "A Guide to the Good Life: The Ancient Art of Stoic Joy" by William Irvine ( http://www.amazon.com/Guide-Good-Life-Ancient-Stoic/dp/01953... )

It is written by a philosopher and its aim is to rehabilitate the Stoics and explain how their philosophy could be useful in modern society. I'd highly suggest reading it (along with the works of actual Stoics as well as pre-Socratic philosophers), particularly to those who like the core message of Zen Buddhism but find it less suited to their way of thinking and difficult to practice.
Oh look another article that's been flagged into oblivion by zealots.

{currently at the bottom of page 4 when by pts it should still be in the top 10)
Yes. You can. Google successfully defended it in the past : http://en.wikipedia.org/wiki/Field_v._Google
I like the format.
I didn't know about some of these. Nice!
England too: "Newcastle upon Tyne", "Stoke on Trent".

I believe you're arguing with a particularly useless troll anyway.
A second : may be used to define a step value. In this case it's not used, so it's superfluous.
It's relevant because, quite frankly, there aren't that many brilliant students at low-tier schools compared to the top ones. The only evidence you've given for your argument is that there are lots of top tier people in Silicon Valley, but this is a flawed application of conditional probability.

What the study I linked suggests is that if the brilliant student was capable of getting into MIT, regardless of whether or not they did get accepted, they are likely to have a similar outcome to the ones who ended up going to MIT.
Stop trolling, bro.
This list is a joke, with way too much choices going for web companies. As if web companies were the core of innovation... Most of these companies have done NOTHING new for several years.
Hubble - a terminal dashboard
A little off-topic, but was this written by patio11? The writing style feels very similar.
or ARM for making the best processors to go into mobile devices with low energy consumption?
Reading your comment I have just mapped

"space" to ":"

":" to ","

That makes sense. Now ; and shift-: works in pair how n and shift-N works in pair.
What's the backstory on the author's tangent about the human genome? It sounded like the human genome project didn't actually do what the name implies.
I understand. I think you are right that it wouldn't make things more hard, I misunderstood that as implying that people wouldn't make memory mistakes under those conditions. So I was writing that one would require a GC to eliminate those kinds of mistakes.

I agree with you, reference counting is not something that would confuse an experienced programmer, but you do have to be aware of what's happening with your objects.
That was slightly loose wording in the article: yes, the single data center is currently a single point of failure (though we can spin up a replacement stack elsewhere very quickly). Andrew was referring to the way we had rearranged our software stack to reduce the SPOFs (our previous architecture had a single load balancer for example).
Say for the purposes of argument that this thesis were true. What is there (if anything) to be done about it? I ask as a naive interested party with a CS background.
Hmmm, interesting. I think you can check if a function is native or not by casting the function to a string, and I don't think there are any native functions the attacker would stand to gain anything by swapping.
I don't know where the "twice as slow" number for postgresql comes from. My the experience is different. Wildly different. For simple "keystore" loads, both are at the same performance class. For anything more complicated, typical relational database scenarios, mysql folds and is one or two orders of magnitude slower.

The query planner's inability to push restrictions down the tree into subqueries alone prevents many typical real world queries.

The way I see it, mysql is trapped between NoSQL and proper relational databases
This national UK newspaper has some javascript cryptography challenge response type stuff on their member login page:

(http://users.guardian.co.uk/signin/0,12930,-1,00.html)

This website claims it's their script: (http://pajhome.org.uk/crypt/md5/)
If 30k is the inaccurate number, what's the accurate one? I'm curious as to what the realistic requirements are from your experience with the field.
Social oldies mean Facebook loses its cool
Research is highly competitive business mixed with industry involvement (or government involvement). You have to publish and fast. You have to develop your discoveries into something that can be monetized. You have to collaborate with industry to get funded. You have to cut costs to keep doing what you want to do. And so on. The idea of freedom in (fundamental) research seems long dead. How I long for the freedom in the research labs in the first half of the 20th century. To really explore an idea without regard for cost, returns, (publishable) results. A researcher can dream :-(
Ask HN:Whats the problem with SVG?
I've been playing around with Inkscape for a while now to create vector image as its one of the easiest solution for Retina-esque site. However I'm having a hard time finding image hosting that support SVG.

My question is, why is it so hard for image hosting service to support native SVG, instead of converting an image to other format. Would like to hear the limitations and challenges that comes with it.

http://imgur.userecho.com/topic/23630-svg-support/
I think everyone is hurting a bit inside, some more than others. The problem is that we're shown these masks that make us believe everyone else have it better than we do.

In my case, this is what drove me from acceptance of my quirks and issues. So my first rule is to turn that damn TV off, ignore media and advertising as much as humanly possible while still living in this world and meeting real people.

It's a monkey see, monkey do type of world. Everyone thinks they know how they're supposed to behave based on what they see around them, and that becomes a circle of masked behavior in society. So the few of us who can't wear those masks feel even more outcast for being ourselves.
I know WordPress quite well. Most of these queries can be very easily executed from indexes, pulling from the tables only the data that will be output. It's just that mysql chooses to do it the dumb way.
Guys, you sure is not fraud? There is nothing about this mobile app on the official blog () http://blog.coinbase.com/ + my credential didn't worked. I just changed my password just in case
I trust Coinbase with a small amount of coins. Similar to how no one walks around with all of their USD as cash in their wallet, it makes sense to only fund an mobile app/third-party wallet with enough bitcoins for convenient spending. Long-term savings should be stored encrypted and offline.
And how are you going to be sure that 'window.crypto.getRandomValues' points to the function you expect? Currently you can't be.
I think tptacek.
This has been one of the biggest changes I've noticed since our team switched from MySQL to PostgreSQL: our database design is now much, much better and we make changes to it much more often.

I has grown used to compromising on database quality to avoid having to make frequent changes to large tables: implementing a new feature as a join table for example rather than adding the columns it needs to a core, multi million row table.

Being able to add a billable column to a large existing table without worrying about downtime frees you up to be much smarter about how you design your application, and much more agile about changes you make to exuding functionality. This is a far bigger benefit than I was expecting from the change.
Is that inevitably true?

I'm imagining a system (kind of like tar snap) that backs up my files all pgp encrypted ith my public key, and which allows me do download those encrypted files (which I can then decrypt locally).

If the pgp encryption is done client side (by a native app, not in-browser), and the "backup service" oly ever sees pgp encrypted files - is there some other hole I've not seen there?

(I guess theres metadata leakage with that scheme, the number and sizes of backed up files could be determined, even if the contents are secure)
"For example, maybe I want to upload a file to a server, and I trust them not to try to steal my data, but I don't trust my government not to confiscate their servers. In that case, SSL + browser cryptography is adequate to give me the assurances I need that the government won't be able to get access to my data, even if the service's engineers could."

If the government might have the ability to confiscate their servers they also have the ability to compromise their service during use. So, if you don't trust your government you can't trust their servers either, regardless of whether you trust the service's engineers or not.
I'm afraid this falls in the "Check back in 10 years when the majority of people aren't running browsers from 2008." category ...
In the "government took control of the server some time ago without announcing it" case, once you've logged in and "given up your key", you're hosed.
nothing on twitter either... https://twitter.com/coinbase
A gathering to remember Aaron Swartz on the evening of Thursday, January 24th.
Deliwraps, a varied range of food wrapping...
"Frankl concluded that the difference between those who had lived and those who had died came down to one thing: Meaning, an insight he came to early in life."

So the thousands who died on the camps were some kind of nihilists, eh?

Why people always want life to be meaningful. Life may very well be absurd.

Is the pursuit of meaning a requirement for living a good life? I don't think so.
Sadly true.

Give me Shakespeare for tragedy, Shaw for wit and Wodehouse for light-hearted comedy with some bacardi and coke, and maybe an island in tbe caribbean any day. ( I prefer a warm bed for my nights though ;)
One that comes immediately to mind is genome assembly, which is a hugely complex problem, and essential to a variety of fields that rely on re-piecing together the genome without a reference (or with a reference that is highly divergent from the sequence data).
> I think you can check if a function is native or not by casting the function to a string

you can swap the toString method too.
This may have been true ten years ago. Not anymore. Mysql query planner is dumb as a rock. Easy example: instead of referring to a table in FROM, try using a sub query with SELECT * from the same table. It's an easy reproduction of the planner failing to process the query tree. It should result in the same execution tree. It results in a temporary table being created, as an identical copy of the original table.

Before you attack the query itself, and note that it is an example.
It's not hard. However, I'd note that IE didn't have built in support until 2011, and the first browser with native svg support was Konqueror in 2004, whereas gif and jpeg have been around for a lot longer.

Isn't SVG just XML? I'd assume you could host it that way.
This is amazing, nice job.
ITU approves the H.265 video format
The point to consider is whether your IT staff can beat their uptime with your own servers.
Yeah, this is my favorite refer.ly thing yet. It's pretty niche, though.
I'm just starting a PhD at Melbourne Uni in bioinformatics after working in the field for several years. Don't pay any attention to this is my advice. Bioinformatics is a field currently pulling itself up by its own bootstraps out of the realm of research into the clinic. That's a painful process to be sure, but IMHO it's the most profoundly exciting time to be part of any discipline. You are literally being a part of and watching history in the making. It's going to be messy, but there are chances to contribute here like no other field going around.
That's already true today. Chrome + FF have > 50% of the browser share by most measurements. Both auto-update. So does IE10. Which means the number of people with browsers running from 2008 is already below 50% and falling fast.
well, you know, i could say yes you're right.
(personally i don't think bill gates is a bad guy).

but you kinda described the problem in your very post. that's quite a common problem(in the states arguable more than elsewhere) in attitude. throwing unlimited amounts of money at things, and hoping they will magically resolve themselves is not really very smart imho.

but then again, i would argue he's old, and he's tired, and his own company has turned in this mixture of xerox parc on the one hand, and a massive goliath that moves so slow you barely even notice it on the other, that he feels with some luck the money might just end up in the right guys hands. in a way that's very close to vc thinking
Thanks, we've switched gears to work on design and focus less on products (still the business model, but not every item needs to be a product link) and more on articles various audiences want to read. Great to hear you like the format, anything in particular about it that works well for you?
"While I'd love a patent- and royalty-free video format to offer the highest quality compression you can find, I wouldn't hold my breath for one."

I wonder why couldn't they allow software usage ( Encoder and Decoder ) to be free. And only collect royalty on Hardware, and Industry Production use.
I don't think they actually expect (or fully want, for that matter) their demands to be met before they release the decryption keys. They want to be seen as confident enough to present a deal, but their ultimate power trip fantasy is to see powerful people forced to resign from office, and then for the reforms to happen after the destruction has happened.

Also, would it have killed them to provide sha-3, or at least sha-1 or md5 sums? People are speculating here (and presumably elsewhere) that some of the uploads were corrupted.
It's XML based, really only uses a different schema.
Early comments:

"Can't actually send money from this app"

"I can't add funds or send anything."

https://itunes.apple.com/us/app/id588530550?mt=8
Silicon Valley Billionaires & the Achievements That Earned Them Their Wealth
> building your own data center?

Or data centers, plural.

Now, seriously, if you can beat their reliability, you are in the wrong business. I'll pay you to host my services.
What does this have to do with what he said? He addressed one problem and then you bash him over the head with a completely different one.
There is plenty of ways to say No. If my company is distributing someone else program which is under GPL and then get sued for patent infringement, we would not be willing to pay money per unit so we can continue distribute that software. We would either rewrite the parts covered under the patent or use a different software. But paying for the privilege to distribute someone else project?

If your in a situation where you want to use someones else project, and would be willing to pay per unit to distribute it to your users, what would you pick. A patent deal to get the privilege to distribute a GPLv2 program, or a supported and legal protected proprietary program? I would pick option 3, ie, write my own program or fight the patent depending on which ever is affordable. In this regard, what license the original program was in matter very little if at all.
I think this is a good related article: "Moral Character" from the Stanford encyclopedia of philosophy.

http://plato.stanford.edu/entries/moral-character/