skysight-inc/HackerNews huggingface dataset:
In PostgreSQL tuning queries is generally quite easy once you have learned to read the EXPLAIN output. The EXPLAIN output makes it obvious most of the time why the planner chose the plan it did. This is also an area which has received improvements in every recent release. Both the explain output and the cost based planner.
James Holmes on 9gag
Do You Have This Wicked Urge To Go Shoot Many People? I Have Some Advice.
See:

http://news.ycombinator.com/item?id=3896492
FabulousFriday Infographics: A RoundUp for SEO
You take that couple of days work of motel rooms and buy a plane ticket back to Iowa and you go back and stop being foolish and have something worthwhile before you move to the Valley. The Valley doesn't make or break you, what you bring with does.
IOS 6 beta's are not capable of handling more than 500 Apps[Report]
Yeah, a lot of things have changed since 2006. It would however been interesting to see an updated post with current versions of both MySQL and PostgreSQL.
> (if you prefer you can swap out this cost and replace it with the cost of hiring somebody to do ops for you on an occasional, freelance basis to handle things going wrong, moving to new cloud providers etc. over a 25 year period...).

Plenty of countries have national/legal deposit libraries (my country has six of them) and the costs of running them are a rounding error in national terms. You can hardly claim an electronic national library would cost more to run than a physical library - much smaller volume of stuff to store, no staff to retrieve and shelve documents, no in person visitors.
Ridiculous linkbait headline. Why not just link to the op-ed in question?

http://online.wsj.com/article/SB1000087239639044433090457753...
Tim Pope's article on commit messages is the gold standard. http://tbaggery.com/2008/04/19/a-note-about-git-commit-messa...
Currently - a simple chrome extension that shows you the time and the weather.
2012 State of Clojure survey
Actually, there are some ideas about creating configurations in which the Casimir force is reversed (ie the two objects repel). There are people trying to use both configurations to improve the efficiency of micro-mechanical devices.
Are these the same folks who gave assault rifles to drug cartels?
I find it quite interesting how everytime we're talking about giving more power to the Government, they all seem to get along so well, and they're only arguing about how much power they should get - just more, or a lot more?
As I posted in the other thread. These companies (among others) use MySQL:

Facebook, Twitter, Yelp, LinkedIn, Flickr, Amazon, Craigslist, eBay, Etsy, Google, Groupon, Ticketmaster, Yahoo, 37Signals, DHL, Dropbox, Evernote, UPS, Kayak, LastMinute, Orbitz, Continental, Mint, Quora, Tumblr, Techcrunch, Slashdot, NYT, NBC, Reuters, Wotif, Zappos, Wikipedia, Youtube.

So that should calm any doubts about MySQL's ability to scale. Twitter and Facebook even have their own forks which are tailored to their individual use cases.
Though this is possibly offensive, and happens to concern women... it is not discriminatory and therefore is not "sexist".

Please, I know it may seem like a minor point but if we generalize the term 'sexist' too much away from its origins, we will have to invent another term to define discrimination against women because of their gender/sex.

There have been arguements in the past about improper language having a chilling effect on women in the feild, therefore being indirectly discriminatory, but I don't buy it.

If you're not applying gender stereotypes, expositing hatred, or engaging in discrimination then you may still be doing something offensive, but it isn't pertinently sexist.
This is crystal-clear to me. What's the problem?
No replies, just downvotes on an honest question. Can somebody please answer and enlighten me? Thanks.
That is true - if the server side is compromised, all bets are off. However, how this is different from, let's say, a compromised browser update?

And good luck with you app - client-side JS crypto needs more dev attention. :)
slightly offtopic: The user id - coconuts2314 - looks like a bot. Look at all the submissions and only one lame comment. Shouldn't the HN spam algorithms detect this?
Are the US and the UK the only countries that have people who can express themselves well in their native language?
There are a bunch of these. I don't think 'pg cares.
I like how he ended a sentence with "with", and made that "with" a link to a note debunking the popular but silly belief that you should not end a sentence with a preposition. That was both clever and shows that he knows what he's talking about.
Enforcing Murphy's Law: Advance Identification of Runtime Failures
The full paper: http://research.cs.wisc.edu/murphy/atc-2012.pdf
Reading this article was like reading one of those About.com pop-psych articles like "12 Easy Steps to Beating Clinical Depression"
Did you actually read the SJCL page before you wrote this comment? Because it rebuts you.
JOB TITLE:- ETL Tester 
JOB TITLE:- ETL Tester	LOCATION:-Washington, DC
The other reasons they do that is because it gets people who are on the fence to take action. Along the same lines they also do "if you order now we will give you two" and other things added in addition to whatever the original offer is.
WITH RECURSIVE is the SQL standard version of what CONNECT BY provides with oracle. Postgresql and SQL Server both have it.
Show HN: Rebuild the Google Plus iPad App timeline purely with CSS3
I would want a external link in the gmail app, to open in a tab in the gmail app.

The internet is everywhere.. I dont want those 50 tabs in one big browser window, nor do i want them in separate windows.

I want them organised based on context. Most of those tabs belong to the initiating application. From a hackers news app, with the chosen articles, to a google docs app, with open documents.

As long as i can pick up a tab, and add it to some other window, that would make the most sense to me.
TV One Streaming
Worth repeating: Until it is proven that the coder who put that in was, in fact, a male it is highly sexist to just assume that it was a man and that ladies are not capable of being childish or being into big boobs as well. ;)
Huh? I never said you had to communicate well in English. Even in your quoted text you can see that I said "in their native language."

And clever use of "its" there :-)
By Contemporary Standard American English standards comma placements are strewn throughout the sentence with very little regard for clarity (removing a few would make it clearer), and the logical relation between clauses leaves something to be desired.
"The fact that multiple transactions can see different states of the data means that there can be no straightforward way for "COUNT(*)" to summarize data across the whole table; PostgreSQL must walk through all rows, in some sense."

When operating on a table, my understanding is that pg will select a version and operate on that version. If other versions are being worked on in transactions - that's a different story. Why can't metadata about the number of rows be assigned with the table version data, so after every operation, you'd know what the number of rows was at at that moment in time?
- functional index

- index partitioning

some great features of postgres, which were not mentioned so far
OK, I stand corrected. I suppose there are some edge cases where this wouldn't hold (limited availability, implications of packaging size etc.), but you're right. If there's no other difference between the two, the discount is always better.
Taking the Cyberattack Threat Seriously
Sure, but the HTTP cache is managed by the browser. Unless you are pulling down mammoth amounts of data, cache management is unlikely to be a concern for you.
The brainwashing part is particularly true, but it's also really subtle, due to the time scale and slow progress. They say "you are what you eat", but the same is true for what you put into your mind.
Nice. Why does it need so many permissions?

My physical location, I understand -- but "access to my data on google.com" and all my "tabs and browsing activity"? No way.
If you're not american, this can also come in handy when you want to register a new App Store account and are tired of having to trick the UI every time because of stupid country limitations.
That's the University of Oxford, but the term "Oxford comma" is a reference to the Oxford University Press. As you can see at http://www.oup.co.uk/academic/authors/AuthorGuidelinesMain/H... the OUP does require the use of the Oxford comma.
2 of my favorite questions are locked:

http://stackoverflow.com/questions/194812/list-of-freely-ava...

http://serverfault.com/questions/68883/linux-command-line-be...

Recently I've stumbled on question which I would be thrilled to continue the discussion on them had they not being set to "Locked". So yes, I really think SO is killing a healthy discussion from that perspective.

off-topic: In Hebrew there is a children song which in loose translation means: "It's not so pleasant to see a closed kindergarten"[1]. I guess this feeling applies to stack overflow discussions as well. It's not that fun to find an interesting question being locked.

[1] http://www.youtube.com/watch?v=DnRCI8aLt_Q
Developers: Stop Doing Your QA’s Job
I wouldn't hire the contractor to work as an editor. But I would read the estimate to see whether it makes sense--has he identified all the true problems? Is he proposing to fix things that aren't broken? Is he proposing to use materials and fixtures of good quality? If I were satisfied with the answers to these questions, I would not worry about the writing.
Could you illuminate 'but only about at the 0.5 level' this a bit?
I agree that the negative thoughts may hold you back -- and this is an important self-awareness step -- but the affirmations don't do any good for you, either. You are wasting time that could be better spent doing something that may give you a better chance to become successful, like starting a company or learning to sell effectively.
The other twist to this of course is when people are spending other people's money or when they are being treated. Each situation is different. An offer to take 10% a check if it is on an expense account is not the same as giving something to someone that is a bonus to them personally. I guess the best way to illustrate this would be with a hotel. Upgrading someone to a better room (at the same price) benefits them personally. Discounting the bill in that case generally would not be the same benefit or cause the same happiness to them.
I'll tell you how it's different: because you, the server operator, can at any time compromise the user. But you could not have compromised the integrity of their browser.

Since the whole point of clientside encryption is to prevent the server from compromising data, the fact that the server retains the ability to do this almost defeats the purpose of encrypting.
Ah! The Irony.

These days programmers don't want to be bothered about the language syntax they use and heavily depend of autocomplete and intellisense to do even simple tasks. While its this grammar that they should be actually learning and mastering. Yet this isn't even the criteria for hiring programmers these days.

And by the way where does this stop. I can argue physical fitness is important for programmer so can I ask you to sprint a 1000m track as a part of my interview process?
Is there room for decentralization of utilities to address these issues? Solar for electricity, ambient moisture condensation for water, etc? Is the future of utilities centralized or decentralized?
In case anyone's curious I came across this post about using Backbone for rich command line app:

http://tobyho.com/2012/07/19/backbone-charm-text-based-ui

Pretty neat, I would never have thought of using it outside the browser.
"Be afraid! (You are so much easier to control that way.)"

I'm not a conspiracy theorist, but the continual push to always have something to be deathly afraid of that the government will protect you from is straining my credulity. An organized conspiracy (ala the "New World Order")? Unlikely. Enough politicians making enough power grabs to simulate that? Apparently.
Unmissing Persons: A Detective Story
I wouldn't argue that protecting our infrastructure from attack is not needed. I would say however that the constant over-reaching by the government in the name of national security is seen here to have a cost. In a scenario where security is really needed, no one trusts the government.
Viacom and DirecTV finally reach new agreement as cable stations return
Exactly. Facebook is determined not to become MySpace by heading off competition before it becomes too late. One of the most effective ways to head off that competition is to purchase it.
The article is essentially telling you to choose one of these pre-written notions of how a programs data flow operates.

If you go ahead and create your own dataflow notion, you'll have to adjust your ORM to fit, so its better to pick one and go with it.
> using data stores better suited for particular sub-problems

Sometimes, rather than swapping out the entire data store to get access to a feature, if you cut the rope that is tying your hands behind your back you may find that your existing data store can already handle your particular sub-problem quite well, and in fact may do so better than the fancy new one that was tailored specifically for that purpose.

This happens particularly often with PostgreSQL. If you haven't used its GiST or GIN index types, you really should play around with them, and you should keep them in the same arsenal and pull them out for the same reasons you might decide to just switch everything out to Solr. A lot of the reasons people might want to use Redis are handled quite well by PostgreSQL's type extensibility.

In essence, if you are willing to throw everything out and switch to a different tool, it seems entirely inane to ignore that the tool you already have might actually already cover the features you need, especially so if the reason you are refusing to use that functionality is to make it easier for you to eventually jump ship to a tool where you no longer have your self-imposed handicap and are now willing to use the features offered.
As someone that works on projected cap screens, I can say that you're pretty much on the mark. You normally take a "baseline" or background read of the sensor's capacitance and then use the signal level above that baseline to determine the presence of a finger.

Now if you don't keep dynamically adjusting that baseline to the environment, and there are many different approaches on how to do this, you could start seeing false touches or no touch at all.

That being said, every modern manufacturer has algorithms like this in place. So another place to look is construction. When you see problems on the edge, is the flexing of the screen causing your glass to delaminate from the sensor line? Perhaps power cycling fixes it (for now, because of dynamic baseline recalibration), but eventually the circuit could completely fail from a mechanical point of view. I'm curious to see if the problem grows and if it eventually results in failed units that software can't recover.

{edit} Looking at the teardown, Nexus7 is using an Elan controller. Out of all the teardowns I've seen this is the first I've seen from them in a major product as opposed to TI, Broadcom, Atmel, or Cypress. This might get interesting.
That page feels extremely sluggish when scrolling... I don't think I'm ever going to use this. And yes I'm using a browser with hardware acceleration intentionally disabled to simulate slower computers.
That's not the point.

More to the point, those companies use lots of other software products, memcache among them, to improve the scalability of MySQL. It could be possible, if the numbers in the article are an indicator, that these companies are spending a lot more money on hardware than they would if they were using a more scalable database like PostgreSQL. They also may spend less money on engineering time if they didn't have to configure and manage all the software needed to get MySQL to scale.
I'm glad you posted this. You're right, this looks much better. I'll probably use this over the OP's plugin.
Considering the low number of tenants in your application, I believe automation was not an important requirement for you (if at all), but how would you go about creating virtualenvs on-the-fly?
The issue with TC is the fact that it doesn't resync the volume while it's mounted.
It wouldn't be so bad if the orbiter didn't have such big wings (due to a military requirement for a large cross-range flight ability that was never actually used). Big wings means a more difficult reentry scenario, which means exotic, and brittle, thermal protection systems on the wing leading edges, which means a much larger area of highly vulnerable thermal protection materials on the orbiter. And it wouldn't be so bad if the vehicle didn't use liquid Hydrogen, which is super-cryogenic, requires excessive thermal insulation, and is extremely prone to formation of ice. A lot of people think that we were unlucky with the loss of Challenger and especially with the loss of Columbia, but in truth it was the opposite, we had gotten extraordinarily lucky prior to that. In reality the chances were very high that we would have lost a vehicle to either of those failure modes very much sooner.

But yes, it's a very troublesome design for a lot of reasons.
Web Security Examples Free Guide By hackspc.com
This free guide will teach you about:

Cross site scripting attack
SQL Injecton
CSRF
How to use Prorat software
Phishing
Have you used Tegra-specific software?

I grabbed SHADOWGUN THD (a Tegra-optimized game) this morning and experienced exactly what the submitter experience: The game is very quickly completely unplayable because you have to control movement on both sides of the screen, which you quickly discover isn't possible.

I am a huge Android booster, but I have to confess to being quite disappointed at this point. The screen has the left side defect where it raises from the frame. There are bizarre lag glitches and pauses (start a Netflix movie and for the first minute or so of play there are multi-second long video pauses).

I have a feeling this is going to turn into a giant PR disaster for Google/Asus.
Nice! Looks great...
I'm redesigning the site as we speak. Thanks for the feedback. I appreciate it a lot.
It's very useful for top-level navigation when using the "infinite scrolling" that seems to be so popular these days. It makes it so you don't have to scroll all the way back up when you're 10 pages deep.
To the folks putting down ORMs: what is your alternative to solve the same problems? (A positive note would be nice.) For my work, using something with a Data Mapper strategy has been useful.
In addition to removing the unneeded permissions, another change should be keeping the seconds from jumping around every time they increment, it detracts from the clean feeling it should be evoking.
Mining the Moon
Indeed. I'd point out that LaTeX does kerning independent of number of spaces after a period. I usually put two spaces when I type because I do a lot with monochrome fonts including all my LaTeX sources, but really, it is no substitute for proper kerning.
Ah yes, once you're a parent, everyone will tell you how to raise your kid, and they will all be very sure of themselves. They will all disagree with each other. You have to get used to it.

In particular it sounds like you're an adherent of Dr. Sears. There may be benefits to his techniques. But the whole goal is to have the woman paying constant attention to the baby - which means that the woman never can pay undivided attention to anything else. This does not seem to me to be compatible with running a company, even in the best of times. (Which Yahoo is not in.)

(A random snide remark about Dr Sears. A man with 8 children advocates a child rearing technique where all of the work is done by the mom. Coincidence?)
You could be right. I have been reading a lot about startups as well as listening to podcasts and whatnot. It seems to me that a lot of them only exist only to get acquired. Perhaps that was Instagram's reason for starting in the first place.

The reasoning is probably that its really hard to get acquired by a company. But, its extremely hard to build a lasting company. So, pick your poison. I'm not sure how I would react if I had to sell a company that I painstakingly created. Would I want the "quick" cash or just say "No, I'm not done yet"? I cannot say. I guess it depends on where you're when/if a suitor does come along to purchase your company.
Well the first paragraph of the op-ed is:

"Last month I convened an emergency meeting of my cabinet and top homeland security, intelligence and defense officials. Across the country trains had derailed, including one carrying industrial chemicals that exploded into a toxic cloud. Water treatment plants in several states had shut down, contaminating drinking water and causing Americans to fall ill."

It's a sensationalist piece all around.
You're right about not having to need them.

But as far as the translation goes, you can get forms for the country you're going to. That's how it was for Turkey, anyway. I don't know about France.

The form is multi-lingual (English/French/Turkish, in my case). The doctor fills in the forms and as long as he pays attention to the proper medical Latin words (and stamps it!) it should be fine. At least for border officials.

Still, from the lack of details in the blog post--he only refers to it as "a letter from my doctor"--whereas he painstakingly mentions every irrelevant detail in the story, I'm guessing that letter wasn't very complete, official, or even partially translated.

And while you are right that he shouldn't have needed it, trying to calm down an angry and aggressive French person by showing them a letter written in English is not very likely to improve the situation, and is indeed likely to get torn up in the process.

Which may not be right, but it's also not very smart.
I'm not sure I buy the heat hypothesis either. I encountered this issue very quickly when running a Tegra game: Tegra games aren't particularly demanding, but rather they exploit additional shader features. Other games and activities that heated up the unit substantially, however, did not cause these touchscreen issues.
This is where we should wheel out Francisco's money speech in Atlas Shrugged: http://capitalismmagazine.com/2002/08/franciscos-money-speec...

(I'm not an Ayn Rand fan and found lots of her ideas in Atlas Shrugged ridiculous, but thought that speech was rather good).
While I could exhaustively ask about every aspect of every language you might have to work in, it's far simpler to use a proxy. The proxy in this case is your native language and seems to work rather well. And since your job certainly isn't going to be writing code for 8 hours straight, the ability to communicate well is a good skill to have.

For what it's worth, I use other aspects to proxy fit and ability as well. If you can't bother to clean up before an interview, I have a pretty reasonable idea of how you conduct yourself.

Re: the non-native speaker part. I've had to help a lot of people out over the years on various support channels because someone wrote "then" instead of "than" or "loose" instead of "lose." Since many people seem to be able to read & write in foreign languages but not necessarily speak them, homophones are easily confused. Personally I know enough French & German to follow along with most technical materials, but easily get derailed by misspellings. Is it an idiom I'm unaware of? Is it a word I don't know? Is it some sort of slang?