skysight-inc/HackerNews huggingface dataset:
I'd love if it just created a new table, moved the data over, and dropped the original table while maintaining the foreign key relationships. That would be perfect.

If you have foreign key relationships referencing the table, you can't drop the table. You can't remove the foreign key relationships without modifying the related table. But you can't modify that related table, you can only drop it. But you can't drop that table because of other foreign key relationships...
Here's how normal users will realize they aren't getting updates, because it happens to me often. Somehow they learn about some cool app they want and they go to the Play store to get it. But they can't find it. It doesn't show up on their search! It won't take long for them to figure out that they can't get it because it doesn't work for their old version of android.

Yes, but is there anything that enables them to make the cognitive leap from "my phone runs an old version of Android" to "my phone should have been updated to a new version of Android"?

What's to keep them from instead coming to the conclusion of "my phone is old, I should buy a new one"? You assume they understand what "Android" is, who creates Android, who creates their phone, and that the thing running on their phone that's called "Android" can be upgraded but the entity that created their phone prevents that from happening.

Many people are just buying a phone. Heck, many people are just getting a plan which happens to give them a free phone. They don't, and have no desire to, understand the nuances of the phone they just got. It makes calls, browses the internet, and may let them install these "app" things.

And what's to say some of the people who do understand some of these nuances don't erroneously blame Google and Android rather than their phone's manufacturer?

I really do bet most people out there just say "damn, my phone's old" and go try and buy a new phone as soon as they're able. Which is a win for companies like Motorola.
12px Verdana was the shit back in '05 when I was building sites then.. Now days I cringe.
Pretty much every day for the last two years. My Android phone is my satnav. It works. Faultlessly.
Nitpicks:

The iPad 1 will be (conservatively guessing) 2.5 years old when iOS 6 is actually released. The Nexus One was less than 2 years old when ICS was released.

iOS 6 does support the iPhone 3GS, which will be over 3 years old when iOS 6 is released.
Fantastic stuff and about time. It may cost more to make localy, but the knock on effect means its still overall cheaper as those you pay are people who would not be paid otherwise and they then buy things and pay tax's etc.

So when you start to look at the true cost or doing something localy as apposed to outsourceing you start to wonder why goverments don't promote it more and add a green TAX on imports to balance out all that extra shipping cost etc.
Similar to "entry-level data entry job that pays more than the management job above it"?
I actually appreciate the breaking up of monotony with italics/bold when done well. You didn't do it poorly, but it could probably be toned down a bit.
Facebook Abandoning HTML5 to Speed Up iOS App
Building a Better Knowledge Worker, While Improving Your Team's Productivity
Note that thinking in terms of MPG tends to obscure how much gas is necessary to go from point A to point B by making you think of how far you can get with a given amount of gas.

Going from 10 MPG to 20 MPH is the same leap as 20 MPG to 40 MPG -- you've just doubled mileage, and halved your fuel requirement.

There's some induced demand which will eat up the efficiency gains, though time and congestion costs tend to reduce this further.

Even if we doubled all our efficiency, the net effect would be the same as doubling our proven energy reserves. Which has ... a very negligible effect on Peak Oil. I can't dig up a reference right now, but recall a presentation or Youtube video in which the net effect of doubling US reserves would have been to move the Hubbert Peak Oil date forward by five or ten years, maximum.

I'm not saying "don't be efficient", I am saying "don't bank on that changing the game".

We're going to have to learn how to get by on vastly less energy than the typical first world resident has become accustomed to.
Wrong. It will play all of your music, and all of your friends' music, that's stored in Google Music, which is a free service for the first 20000 items.
Have you read any of the posts up to the point in the thread? They don't want to. They have no incentive to. The carriers regularly drag their feet on updates, even after the manufacturers released them. Apple had the great thought to tell Verizon to, kindly, shove off, and they handle them by themselves. They manage the hardware, and every layer of the OS. That's not true of any Android phone, and the current situation is a result of that reality.
THIS JUST IN: man spends 4 months confirming what everyone already knows
Do you have more details on how they did this/what happened?
The 'fucking' in the title is most of the reason I read and upvoted it.* It's a reality check, such things are never polite. And I got tired of seeing the "I'm CEO, Bitch." style posts just as much as you did.

*(In this context of course. Swearing in the title isn't enough to get me to click; but that message sure as heck is.)
As far as I have heard, no.
That is easy to say, but often you don't know exactly the right person with the right skill set at the time you need them. If you only work with people you have known for several years you are going to have a slow time growing your company.
I've been wondering this as this is exactly what happened to me and I'm never sure how to introduce myself!
I work with a small pharmacy that only has 5-6 employees. Every time I go there to meet with the owner hes on his hands and knees vacuuming or cleaning something. The last time I saw him there he was calking a chair back together. His exact words were, "Back to basics."
I agree but it's only $300. As I said before, I think it should be $200

Unless you want the speakers and speaker cables they're selling with it, the speakers are $400 and the cables are $50 for two.
Why would you say?

"Most of the time they just wrote down what they wanted, or from their own ideas and opinions."

When your master's webpage at:

http://www.members.tripod.com/tathagata2000/questions_and_an...

Says:

"What is the proof about a Tathagata?
> The proof is in the Buddhist scripture."

Seems contradictory, no?
No, they really do mean that on the same hardware, solving the same problems, we have algorithms that will solve those problems 43,000 times faster compared to fifteen years ago...at least for the problems they looked at. And that progress is continuing.

The assumption here is that at any given time, you're reading the latest published papers and implementing the best known algorithms, in a field that uses complicated algorithms on big problems.

It's not just because of faster chips that Google has a self-driving car now.

(As for sorting, it's been proven that the best you can do is O(n log n), and John von Neumann achieved that with mergesort in 1945.)
I'm not that interested in live sharing personally, but I definitely think that there are several ways I would find it useful to be able to easily record what I see and hear unobtrusively (note I really don't mean secretly here).

The biggest thing I was hoping to see out of Google Glass though was the possibilities for augmented reality. Things like being able to easily ID a painting that you see or even better to be able to look at a game board and see a projection of the best next move.

I haven't seen any details on Google I/O other than the text of this article, so I'm wondering if any of that stuff was touched on.
Wouldn't worry about the F-bombs, but IMO italics, bold, and the like should be used quite sparingly, and typically only italics should be used for emphasis purposes (there's a reason the <em> tag typically renders as italics). I think typography should be visually monotonous so that it's not distracting.
Seth's Blog: This might work (my new book)
There's No Euro Debt Crisis. There's a Euro Crisis.
Garry Kasparov defeats Alan Turing in chess in 15 moves
Or, better yet, demand CC if it exists for submitted titles, because in the vast majority of cases it does.

If there's a licensing issue here, then people should be suing hollywood.
Will this let me do Windows Phone development on a Mac? I seem to remember reading about Trigger.io letting you do iPhone development on a PC.
There is no single ultimate solution for image optimisation. This looks like it'll work great for some images.
I get very upset when junior employees try to keep me from doing the 'dirty work' I'm preparing to do or already doing.

I'm not sure where this whole nonsense of "people who lead can't get dirty or do menial work" comes from. If I had something more important to do for sure I would have delegated, but seeing that I didn't, ask why is this particular thing important or, at most, offer help. Don't tell me I shouldn't be doing this!

Context: I lead a team of 4. And by 'dirty work' I mean plugging up servers, doing maintenance on them, physical networking stuff, cleaning up debris after an installation, etc.
The theory being that Intel bins for price control, and AMD bins for defects.
TL;DR All replacements for fopen() grow until they span multiple files.
As long as SQLite4 preserves the level of testing we've seen in SQLite3, I’ll be extremely happy: http://www.sqlite.org/testing.html
Yeah, I don't really care. It is Google branded, was developed primarily by Google, was marketed as "Google Android" and/or "Android by Google" at various times, has Google apps, has a store run by Google where I get more apps, and has Google's name associated with it in every news article I find about it online. It's a Google device to me, Joe Average Consumer. Your technicalities don't mean jack to me.

Also, everything you said in this comment applies likewise when I get a laptop with Windows installed by an OEM. Are you prepared to argue that a Windows computer is in no part a Microsoft product and that Microsoft would not be responsible if the OS failed to update on my laptop?
It's an extra £10 shipping. VAT is already included in the price.

(Although £10 for shipping is a bit steep tbh.)
USTR Needs To Reread Both The Constitution & The Definition Of Transparency
I searched the threads and couldn't find anyone asking this question, but this is a red flag to me:

> they have a 90% accuracy rating and 60-100 transactions
> a day completed. I have 99,6% accuracy

If there's no automated system to do this, who or what is calculating the accuracy down to a fraction of a percentage?
Google announced their solution to this problem at the last Google I/O: the Android Update Alliance. It was basically a commitment by manufacturers to update phones for 18 months following their release.

This is how it has panned out so far: http://www.pcmag.com/article2/0,2817,2397729,00.asp

tl;dr: As of December 2011, only Sony had lived up to its pledge. HTC came close.
I think that this is one of those instances where the needs of the company were prioritized over the needs of the user. Not to say this isn't uncommon in any industry, however, in prioritizing maintenance cost minimization they made the user experience markedly worse for the end user.
Because I like to be able to swap my batteries without paying 200 bucks and having my electronic device away (Send to apple to replace).

Also, I'm don't like Apple as a company and am not a brandphile. Having a smart phone or tablet is enough for me, I don't need to flash around a brand name to feel important.
Reasons universities should consider startup incubators
You have absolutely no business relationship with Google with regards to your device and yet you think it's their problem? Branding tells you what software it's running -- that's all -- it doesn't imply anything more.
The comparison will be subjective. One will retain full detail (24-bit color) and the other will not. The "better" will be subjective, as I said.

I wish Photoshop gave the option to save an 8-bit PNG with a FULL alpha channel—that's what this seems to do.
For Twins, Nature (Finally) Trumps Nurture
"As a developer the comments are talking to me"

-- As a developer the code is talking to me.

It's a trivial question, comments are a chore that developers do because they provide someone who is later looking at and/or modifying their code with the knowledge about how it works in a way that isn't obvious from the code itself. Comments have morphed into more structured form with annotations that the IDE can make use of in some languages, but asking about comments in an interview is asking to get spoon fed what you want to hear.
Not if you prefer Firefox on the desktop
But on the other hand, the fact that this seemed almost entirely unscripted (the presentation) and that Sergey felt strongly enough to go public with Glass as rough as it currently is, spoke more to me about the excitement and innovation going on at Google than anything else (seriously, Nexus Q?!?). As other posters have said, augmented reality like this is the future.
I heard an anecdote a while back. One day, the employees of a small company arrive at work to discover that someone has taken a shit on the floor. Who's going to clean it? The owner of course. He didn't hire anyone whose job is to clean shit up, he can't reasonably expect any of them to do it, so he has to do it.
Seriously? £40 for an extra 8Gb of flash with no SD card slot? That's reaching iPad levels of customer value extraction.

Otherwise, looks like a nice piece of hardware: Tempted to grab one.
You should certainly increase font size though, that might make the italic/bold thing less necessary
Those sound like nothing but excuses for being a terrible web developer.

"First is cost. Even if it only takes 10 grand to make a site "functional" in x browser, rebuilding an application to fully work with ie7 does not. If it takes 15-20% (or greater) more development time to add in support for IE7, but IE7 does not provide 15-20% increased revenues (it won't, unless you're making business software specifically for tech-agnostic corporations). You might say oh, it doesn't take 15-20% more time... just use jQuery and magic will happen. No man. It takes much more time."

Oh man, there is so much that is wrong with this comment.

First of all, users are more willing to buy from a service that works compared to one that, well, doesn't. That's just common sense. Secondly, if you really think that sprinkling some jQuery over a site will just make it work then I really hope that you aren't a web developer, because that mentality is exactly what is wrong with many websites out there today.

"Second is more philosophical. Assuming you are a consumer focused company like AirBnB, you customers are fully capable of upgrading to a new browser. There are no IT limitations on a personal computer. It takes all of 5 minutes and is completely painless. Stop coddling IE7 users; it is obsolete."

Again, if you are incapable of supporting older browsers it's probably because you're a terrible developer. Regardless, there is no philosophical debate here. Users can use whatever the hell they want and it is not your business to tell that what to use. It's entirely up to the client, and if there are users that are using IE6-7 it's probably because they are on old hardware or a machine that isn't theirs (i.e. a work or library machine). The limitation on a personal computer is just that. If your site takes ages to load are you going to suggest to the user to get a better internet connection or to buy a new computer?

"As far as pages working without JS: this is 2012, not 2002. If you still treat today like you treated 10 years ago, you really have no business complaining about anything on the internet. The internet is not for you, and neither is a site like AirBnB. If you think I'm being overly harsh, see my last paragraph. Installing FF, Chrome, or IE8/9 takes all of 4 clicks."

So, where do users limited to screen readers fall into your "the Internet is not for you" speech?

The reason many of us develop solutions that work across legacy browsers and screen readers is because we have the experience to be conscious of those who CAN'T view the web as you'd like to.

Again, it is not your place to dictate what users should be using. Regardless of their lack of browser support it is a wasteful site that is entirely dependent on JS and as such it is completely inaccessible.

It's comments like yours that give me "the fear" when talking about web development.
You're right, it's listed on pngquant's site too as one of the GUI's.
That's just insane, and I can't think that's a typical usage scenario. Going through three batteries a day (assuming he charges it while he sleeps) means he's getting less than six hours per battery.

And I don't understand the loyalty to a carrier that sells phones with such poor performance. Where does his loyalty come from, a crush on the cute girl in the T-Mobile ads?
Episode 0.8.2 - Ruby Motion, MacRuby and more with Laurent Sansonetti
What about?

"No one has attained Enlightenment through Zen nor meditation in human history."

And:

"Buddha himself never claimed he was enlightened through meditation."

Look at:

http://news.ycombinator.com/item?id=4165192
Actually, Steve Jobs' most famous janitor analogy takes it in completely the opposite direction - CEOs aren't like janitors, he says, because janitors are allowed to have excuses when things fail, and CEOs aren't.

http://articles.businessinsider.com/2011-05-07/tech/30043798...
I can't really speculate on whether the story is true or not. At least some parts of his story are similar to my own, which I posted on the original Reddit thread: http://www.reddit.com/r/AskReddit/comments/tenoq/reddit_my_f...
Eclipse 'Juno' Release Train Biggest to Date
"only looks like it will continue"

This is probably true, but hopefully battery technology gets better and electronics require less and less power.

Charging every day is a hassle. Especially since you supposedly shouldn't charge until it's entirely drained.
Sure. Care to specify the "high-end" tablet you're buying for $200? I'm a bit skeptical. If you're claiming the Nexus 7, that's not in the class of the iPad nor the proposed Surface.
2 years from the point that the phone model was last sold would be reasonable.

Or to put it another way you should expect to receive software updates for the phone for the duration that you are still under contract.
So you ignored my point about Windows OEM. Would you like to address that or are you going to concede it?
This article reminds me a bit of 'the parable of the silver bowls:' http://www.youtube.com/watch?v=VjzqO6UOPFQ -- regardless of the size of the organization, its leaders are the ones who must deal with the stuff no one else can or wants to tackle.
I don't see why everyone is interested in blood sugar aide devices. I don't really give a crap about how much insulin my body produces, nor some BS about insulin resistance.
Nitpicking. The loss of punch with the more accurate title would not be worth the hat-tip to pedantry.
Starting off with a strawman is a good way to write a bad blog post.
Two twenties, because after a few months, I have two 15s and you have a twenty. Batteries never seem to fully charge like the used to.

My wife has a iPhone (the 4s or something) and still has to charge hers more than I do (Samsung Galaxy II). Not a whole lot different, but instead of her being tied to the outlet, I can pull my battery out, put in the new one and keep going.

That kind of convenience is worth everything to me. Also 200 dollars to replace a battery that lasts a year is still a lot less than I spend. I spend 20 bucks for two spare batteries on Amazon. I don't go through 20 batteries a year, that's for sure.
Apple used to charge for iOS updates, for somewhat spurious 'accounting' reasons. iPod users had to pay $5 or something (iPhone users still got it for free). They don't any more.
I agree with you here, but there are environmental concerns related to the extraction process - namely contaminated water supplies and greenhouse gas emissions.
I wasn't sure why the 'F' was capitalized, that choice made both occurrences very odd with or without the bold/italic artistic license. I would assume someone with the title of 'Fucking Janitor' would be in a very different line of work than what tends to be talked about on HN.
Hmm, 100 bucks though, still kinda high priced. I can get two batteries with a wall charger for 20 bucks on amazon:

http://www.amazon.com/1900mAh-Batteries-GT-I9100-Anker-Multi...

A weekend charge and I'm often good for the whole workweek.
I've seen the future: Hands-on with Google Glass
My reaction to your use of "fucking" wasn't that it appalled me in some moralistic or linguistic sense. Rather, I felt like it (partially) undermined the point of your post.

The post is about how being CEO isn't all glamor, and includes doing dirty work as well. And you make clear that you feel the janitor, unlike a figurehead who merely signs documents, contributes something useful and necessary to the enterprise.

Unfortunately, denigrating the janitor by tagging the role as "fucking" just buys into the CEO-as-glamorous-leader mindset that the post argues against. It transforms the title from a correction ("You think you are the CEO, but in reality you are in charge of the dirty work") into a put-down ("You think you are the CEO, but in reality you are the lowest of the low.")

Yes, it sounds stronger-- but, in my mind, it shades your meaning in ways you probably don't intend.
Great book about technical blogging
Don't you mean: Steve Jobs IS still cofounder of Apple when he was kicked out of it. ;)
Sending a child through the post
Local commits and huge speed increases are some of the immediately available, tangible benefits of git over SVN.

Plus, you don't have to migrate your codebase to another SCM tool if the project unexpectedly grows into a larger one.
I disagree. Non replaceable batteries are a step back. Guess it depends on your outlook. I like to work with things. Some electronics, some carpentry, some mechanic work on my cars. Anything that restricts that freedom is a step backwards. Anytime you are at the whim of a tyrannical company, you are limiting yourself.

All IMO, I get that, but this is why I disagree.
Why multiple files?

The (default) on-disk database image is a single disk file with a well-documented and stable file format, making the SQLite4 library suitable for use as an application file format.
I'm very sorry, Diego. You have got to be in shock right now. I wish you well getting through it.

My father left last year (though not so unexpectedly). It changes one.
Post the URL.
Quite so. Think of CH4 as sort of half way between burning coal and burning Hydrogen. Methane and ethane generate about 14 to 15 kg of Carbon emissions per gigajoule of energy released in combustion, compared to 18 for gas/kerosene and 37 for coal. So switching from coal to natural gas has a giant impact on carbon emissions (cutting them by more than half for the same energy use) while switching from gasoline to natural gas still reduces emissions by more than 20% (and that doesn't factor in the emissions due to refining, which are significant).
That Kudos shit even fires if you come close to it, not only if you actually move over the kudos shit circle.

Sorry, but I find this highly annoying and indecent.
Yes, sorry to be unclear. When Emacs 23 was released I took a good look at my config and noticed that a lot of things I had added over the years weren't needed anymore.

Looking at the new features in Emacs 24 I expect my config to shrink even more. I am still on Emacs 23 but will switch when it both shows up on Debian Testing and when my workstation needs a reboot.
Master PHP with Codeigniter (Free give a way)
The real strategy behind tiered data plans
People are still buying lots of mini suvs with $3-$4 gas, so I'm not sure the blame lies solely at the feet of the auto companies.