skysight-inc/HackerNews huggingface dataset:
One of the things I prefer to do is to only write UPDATE statements that update a single row. For example instead of:

UPDATE line_items SET quantity = 1 WHERE quantity < 1;

I'd script the following updates:

UPDATE line_items SET quantity = 1 WHERE quantity < 1 AND id = 123;

For each of the individual rows that needed to be changed. Then I have a check that I'm really updating just the rows I expect, this is especially important to me where the UPDATE involves joins, as I find this is the trickiest to get right.
Actually it's 1-2g of protein per kg of weight, not lb. Unless you're on anabolic steroids or are on a protein sparing modified fast (PSMF) 1.5g of protein per lb isn't going to help you gain or retain more muscle.

Source: A week ago I read through all studies I could find on pubmed about optimal protein intake for muscle gain.
Poll: Have you run a marathon?
If you are a marathoner, what online resources/texts or training program have you used or you follow?

2012 NYC marathon would have been my first marathon but it got cancelled. I would be running 2013 NYC marathon and probably 2013 Chicago marathon.
Well, I was speaking more in terms of functionality, not materials. I didn't mean to imply that making a bolt action rifle was easy, but I find it hard to believe it is harder to make a bolt action rifle versus a semi-automatic AR-15. I'm not a gunsmith, so I could be wrong but the difference in complexity between the two seems to suggest this. I would have to assume that making a single action revolver would be easier than a semi-automatic handgun.

Discussions of quality of the resulting weapon is a different matter though.

If we had printers capable of making a functional gun, then the government can try to regulate individual parts all they wanted. It would make no difference. It's only a matter of time before there's a simple way of making a high quality rifled barrel of your choice of caliber. They would have to look into controlling the materials required; metals, gunpowder, and so on. Even then that's a losing endeavor, simply because how can you tell the intentions of the person buying the materials? You can't.

This goes beyond weapons, the ability to create nearly anything you want in your home with no one knowing opens up a huge can of worms that I feel that most people simply cannot comprehend.
W00t! Can't wait... my N7 has been collecting dust. Writing special-purpose scientific tools that work on the linux desktop and on N7 seems a much better answer than porting to Android.
People go completely irrational about avoiding writes to SSD's, I've seen researchers at an EE dept spending evenings tuning their Windows installations and going as far as stuffing frequently used stuff onto a RAM disk.

I guess the early off brand SSD's randomly eating your data didn't help the popular perception (even though that wasn't because of flash wear). But still...
A bit meta, it's almost 1am in here and I'm reading this. Such an irony.
It's bad if users are trained to only recognize _your_ phishing attempts :-)

I'm not sure I understand which users jacques_chester is talking about.
There are users that can recognize phishing, and they are entitled not to care about your teaching. And then there are those that can't recognize phishing - or perhaps don't even know about it - but I'm pretty sure any user would start caring when they find out someone else can gain access to their email/bank/facebook/whatever online service they use if they aren't careful.

To avoid training users into thinking it's another drill, perhaps it's a good idea to 'attack' them at random intervals, and wait a few months before repeating (thus giving you enough time to prepare the new attack; giving the users enough time to forget about the threat, and to account for new arrivals).

I'd rather be embarrassed by the local BOFH, rather than be a real victim
I was just going to say this was another glue gun. I remember in middle school using glue guns to make shapes and "art" in art class.
Fad: An intense and widely shared enthusiasm for something, esp. one that is short-lived; a craze.

Just because the idea came from the prehistoric doesn't mean it can't be a fad.
From his podcasts I hear that it is pure assembly. He's borderline machine, though.
Meanwhile... Touchscreens and centralized tabulators weren't nearly unreliable and insecure enough. The new thing is internet voting, meaning casting ballots via email. What could possibly go wrong?

The motivator is the election vendors are pushing for a per-registered-voter fee business model. Election integrity be damned.
Self.com has great data tables for many variations of foods.
RBC buys Ally Canada and kills it instantly
You don't need to use it. Variety is beautiful.
Ooops...nobody has read the article...:)
> You ingest caffeine only in the morning.

But that makes no sense. Caffeine binds to adenosine receptors, which have to do with how sleepy you are. But they aren't doing anything in the morning as you've just woken up (think of them as a counter of how long you've been awake).

Any coffee before lunch is just a placebo really.

From wikipedia: http://en.wikipedia.org/wiki/Adenosine
> Caffeine's principal mode of action is as an antagonist of adenosine receptors in the brain.

I mean, if you're only going to drink caffeine in the morning you might as well go without. No need for the sweats, frequent visits to the loo and dehydration if you're not even going to use its upsides.
I love their solution to run apps side by side, by using the phone version for the smaller app. Android is the only other platform that could really do it, with both widescreen tablets and apps where the same binary can run on phones and tablets.
For x86 I'd say study but I don't think there's any fun to be had there. Something like MIPS32 would be pretty fun because that instruction set actually makes sense to a human.
Right, but your article is talking about outlook.com.

Office 365 and stand alone (ie: private) exchange installs certainly support it.

Comparing outlook.com to 'Microsoft Exchange' (whether you're talking about Office 365 which is MS's 'cloud' solution, or private Exchange servers) is not exactly fair. One is designed as a free email hosting solution for personal use (essentially replacing Hotmail), the other is designed for business/organizational use and costs money.
How to Stop Blogger Redirection from .Com to Other Local Domains.
The Health Benefits That Cut Your Pay
This is great, I hope it will have the same success that Ubuntu for Mobile Devices gathered, oh wait, it didn't succeed after all..
The folks at ZeroVM have a list of motivations[1] for this type of execution and hosting model. The only problem is that it's hard to tell how active the project is from their main page alone.

EDIT: Their github commit is fairly active for a solo developer[2].

[1] http://zerovm.org/motivation/

[2] https://github.com/zerovm/zerovm/commits/master
Without the full shot of the plate or another object as a frame of reference, it's hard to tell how much volume each portion of food represents.

The imgur gallery makes it easier to gauge the portion size in my opinion.

http://imgur.com/gallery/w9nHF
You know, I'm thinking about this

You cannot motivate people with fear, at least not with fear alone

So, I'm thinking a military action is riskier to NK than it is to SK

SK will suffer causalities, sure, but I don't trust that a country, even militarized in abundance, without any meaningful social/economical structure can produce anything more than a fireworks show (even with decades old military technology from other countries).

And of course being obliterated in sequence.
You can use your skills to go online and build alliances with builders. Using your existing contacts, you can start a drop shipment kind of process for your online business.

Good Luck!
Damn, I'd really love to be able to try this out on my Galaxy Tab. I wonder if we'll see a build for those anytime soon.
For example, by making it difficult to tell what part of the website is an ad.
I wasn't meaning to suggest it was (or should be) considered dangerous: just that supporting two concurrency models it that same time is a complication many would prefer not to bother with unless their application really needs the efficiency boost threading may offer within a single process on a single node. Unless you can justify working with both due to some measurable and significant efficiency gain or don't need multi-host scaling you go with the option you have to have (multiple processes).

Supporting both (multiple processes for multi-host scalability, threads for speeding up CPU intensive operations and such) might not be much more hassle, but it is at least some more hassle.
Whole wheat and seeds are good ingredients too.
The concept of regardless is lost in a meritocracy given the terms of measurement are defined by the the dominant group, which may or may not reflect the required knowledge for the betterment of the system.

For example, if you have a computer science scientist judging the validity of a physics experiment, you are not doing the physicist and physics justice, are you? If your meritocracy supports computer scientists, what chance does the physicist have?
Has the Digital Divide Withered Away?
As a customer of Ally I find this interesting because Ally was the only bank in Canada to offer standard rates of 1.8% (for a standard savings account). Since the acquisition they've dropped to 1.2% (RBC's normal rates). Does RBC simply not like competition?
I've read your slides.

I think your Farmer's Market summary is outdated: it used Tor hidden service, for a short period only and after the investigation started (reading the indictment), and it's pretty clear now that Hushmail rolled over and then the garnered information was used to extract the Paypal & Western Union financial transactions. See my discussion of Farmer's Market in OP.

Slide 14 should mention the SQL injection attack on SR back in November or December 2012; I also disagree that DDoSes would be ineffective.

Slide 23: IIRC, someone has a verifiable anonymous mixer. I forget its name because it charges more than others.

Slide 27: Mtgox has been hacked and lost bitcoins, but haven't they always made up their users' losses? That's pretty important.
Ask HN: how much of your old code do you keep?
I have archives of a few hundred projects, in various states of completion, from over the years. There are plenty more that I never saved, too. I'm curious how many of you do this as well, and if you have any fond memories that you would like to share.

It is interesting sometimes to go back through and see how poorly our even occasionally how well I did things. I know I've kept them this long because I always felt like I was going to finish them. I'm actually working through some of the more complete ones. One of the projects I've been iterating and using as an ORM system for every for-pay project I've worked on on the last 6 or 7 years. The nice thing about reinventing a wheel is that you know everything about that wheel. It has gotten powerful enough that it is a real time saver far beyond what I could have imagined when I first started it.

I wish I had saved this joke code translator from college. It would define a mapping between basically gibberish and C expressions. I used it to make programs that looked like they had been written by monotonic cartoon characters: South Park's Timmy and Pokemon's Pikachu. I don't even know why I did the Pikachu one, because I never had an interest in Pokemon. It would be a good laugh to have it around still, but I think it would lose something to rewrite it today.

I have a text mode simulation of fish in a tank that I occasionally tinker with. Actually, it has a GUI and ASCII-art mode as well. But I like the text adventure style mode the best, just for the shear absurdity of typing "clean fish poo".

Anyway, not going to drone on about all of them. Please, share your own stories.
Look at it like this. They may have cool new features not seen on existing tablets. Your favourite company might then incorporate and, hopefully, improve upon the feature and you now have a new feature on your platform that may not have been planned before.

No one is forcing you to use it but it still has potential to positively affect your tablet experience, even if it's indirectly.
In relation to a custard filled donut, they probably are pretty healthy.

They definitely fall on the 'health food' end of the breakfast breads/pastries/etc.
Fascinating. At the end there's a link to an earlier Fiat I did not know had existed: http://en.wikipedia.org/wiki/Fiat_Turbina (the photo reminded me of something familiar, took me a bit to figure out it was a guppy fish ;-)
Thermodynamic laws aren't very useful when talking about weight loss and metabolism. Firstly, the human body is not an isolated system (2nd law).

Also a calorie is not a calorie. One small example, different calories have different thermic effects. I've read estimations that from protein you lose 30% of the calories from the thermic effect, and with carbs you'll lose 15%. Therefore reducing carbs and upping protein will assist with weight loss further. Calories in and out will probably have you losing weight, but it's an over-simplistic view.
Can you dual boot it to an Ipad?
Yet another announcement by Canonical that isn't backed by a "Buy" button. I understand that it's not exactly easy for them, but it's becoming a bit boring how they keep announcing new "products" with no way of actually purchasing them. Couldn't they have waited for a year or so for this to be ready to ship and then launch it? At the very least it'd be good to have "Available to buy in July, 2013" or whatever.
Would love to hack my original iPad to install this.
Hi danso! Thanks for your feedback! I've applied a quick fix. I'm very bad at design so please don't expect much.
tl;dr

I'm guilty of the SSD fear. My first Intel (320) drive was meticulously maintained in fear of shortened life span and performance losses. I went so far as to question every file copied to the drive vs. mounting an external HDD. The thing bricked itself due to a firmware bug in less than 12 months.

Using a Samsung drive now. I don't think about read/writes anymore. I just use the darn thing.
Hah, I looked up the Florida equivalent of this unclaimed property lookup/site, and it's humorously located at https://www.fltreasurehunt.org

Looks like I had some unclaimed cash in lieu of shares from a previous employer. Claimed!
Youtube promo: http://www.youtube.com/watch?v=h384z7Ph0gU
It's the same for salt. Neither one has to use ZeroMQ, neither one has to use a daemon.
"But they aren't doing anything in the morning as you've just woken up (think of them as a counter of how long you've been awake"

How so? If you wake up sleepy and groggy and all that, then what neuroreceptors are we talking about?
I'm in a class using MIPS, and I don't find it fun.
They're releasing images for this and the phone in a week.
I'm betting you meant "that's nice, but did you have to break the Ubuntu desktop experience to build a tablet interface?"
Lessons Learned from a Successful Hacker News Launch
I greatly appreciate Australia and NZ's police agencies being public and specific about interception & arrest rates; I wish America could be as informative - as things stand, I have no references on either.
How a “revenge porn” site got built: Fake identities to trade photos
this is where i got my data - http://examine.com/faq/how-much-protein-do-i-need-every-day.... - and you're right. I aim for 200g/day which for me is 2g/kg and probably a bit more than i need. I've noticed if i work out and eat much less than that i don't recover as well.
The seamless phone => tablet => desktop transition make the Ubuntu family a winner. Now to see if it picks up any enterprise traction...
...and hacker news.
I didn't even use Android on my desktop, what's the motivation to use it on a phone or tablet?
I think the big question is what will China do if North Korea is attacked. Sure they have been against DPRK's actions lately.. but at crunch time what happens?
Can't they lob a nuclear weapon and destroy Seoul(not to mention artillery aimed squarely at Seoul)? That would be pretty devastating to South Korea.
Oh, come on, the ModR/M byte, opcode extensions, variable length instructions, opcode prefixes, what's not to love </sarcasm>
W. Feller's volume II proves the renewal theorem from which we can conclude that the stochastic point process of arrivals of asteroids of some size and larger is a Poisson process, e.g., as in Cinlar's book. Then empirical historical data provides a good estimator of the arrival rate parameter of the Poisson process.

Net, we can know the arrival rate of dangerous asteroids, and, ballpark, it's one each some millions of years. So, we get to f'get about the problem.
"Sugar/carbs are not something readily available in human history..." This doesn't matter at all.

"...in the vast quantities we eat them today." THIS is what matters.

Net calories are king, regardless of diet macro composition.
The last thing NK wants to do is a military action, why do you think they do all these tests and smoke and mirrors? They are provocative but can be talked down to what they want. They are all means to an end. If they had any kind of military action the full force of the UN would come down on them, that is the last thing they want.

Oh and yes you can motivate people with fear alone. History is riddled with instances of this.
"discussion credit"

Discussion credit was the bane of online classes, in that most classes of this type were "regurgitate the text back to me" so there is an inherent hierarchy of "correct" answers ranging from best to worst, so the first poster gets the best comment and so on down until the folks later in the day have a terrible struggle trying to find something to repeat back to the instructor. So rather than having to be in a lecture hall at precisely 2pm or 6pm on Wednesdays, you had to be online at precisely 9am on Monday so as to be in on the discussion credit feeding frenzy at the instant the unit opened, and I hated that component of online classes. This completely eliminates the 24x7 advantage of at least some online classes. Discuss one of the three defining characteristics of object oriented programming as per the text... well the fourth guy who waited to post at 9:01 am is pretty much outta luck until next week... if he's lucky.

One interesting observation of the article is it equates all online courses as being the same. The state-U MBA program, the regional hybrid private-U CS degree, the 250K person MOOC classes, all the same. If they tried that with brick and mortar they'd be laughed at.

Also I feel based on experience the sympathy card was harder to garner because, after all, its theoretically a 24x7 online class. You'd think superficially that not having to be at a lecture hall at 2pm would eliminate "flat tire" as an excuse, however, fundamentally, a flat tire eliminates a couple hours outta your life, the specific time doesn't actually matter. If I was going to do my classwork online at 3pm and instead spent my time at the tire repair shop, it has to be realized that missing time at home is just as damaging to productivity as missing time in class, if you're doing classwork in both locations.
That article also links to the OP wisegeek article, and mentions protein calorie overcounting and cooked-food calorie undercounting, which other commenters here have mentioned. And it was published yesterday!

Strange loop, or filter bubble?
It's not an idea, it actually happened. People actually ate paleo style for millions of years from necessity.
Maybe the PHP docs are better, but for me the Python docs are good enough, and I will take Python the language any day.
For more info on this, check out "Why we get fat" by Gary Taubes.

http://www.amazon.ca/Why-We-Get-Fat-About/dp/0307272702
Sorry another contender is providing you with a choice. Good thing you know how to exercise it.
Hacking against the US is traced to front door of Chinese army unit
Most commonly consumed foods don't have fiber, so this isn't a huge issue.
How to spot a phishing form:

1) Did you click a link from an email?
2) Does the page it redirect you to ask for your login info?

You may have received a phishing email. Are either true?

1) You expected this email because you were notified about it from another source e.g. website, support staff.
2) If you login to the website not via the suspicious link, the linked web page does not ask for your login.

If you answered yes, you probably don't have a phishing email.
As much as it pains me to admit it, I'm now using Cinnamon as a desktop environment. I really, really wanted Unity to work, but I've had continued performance problems which make it ultimately unusable for me. I understand Ubuntu's need to turn a profit, but I really wish they'd focus on making Unity stable and performant before chasing down these other opportunities...

Disclaimer: I run three monitors, so I'm probably different from the average Unity user.
Now a days, compiler writers sees zero reason to write inline assembly.

First of all, it throws a wrench in high level optimizer's analysis. Plus, compilers and processors are getting smarter day by day while inline assembly in shipping code becomes more and more untouchable everyday.
How business data has evolved - FT
High quality global journalism requires investment. Please share this article with others using the link below, do not cut & paste the article. See our Ts&Cs and Copyright Policy for more detail. Email ftsales.support@ft.com to buy additional rights. http://www.ft.com/cms/s/0/5f130ed6-777a-11e2-9ebc-00144feabdc0.html#ixzz2LMb6FcsZ

Business data has come of age. Once the preserve of computer scientists in IT departments, information analytics is now part of mainstream business, and regarded by many as the new gold in terms of its value.
I hope it runs on Asus Transformer and is usable both in tablet mode as laptop mode.
Then why not wait a week and announce it then?
This is a really great step. I previously though Ubuntu was going to ruin itself by getting into the mobile game so late but it seems like their solution might be unified enough (as a result of the time they spent watching others) to actually gain some foothold. I have a Nexus 7 and if they can allow me to dual boot somehow I will be all over this. I'd love to have a little touchscreen Ubuntu PC in my backpack. I'm still not convinced I want it on my phone but they have my attention on the other three screens.
You must be joking. It may convert like hell, I don't know, but - oh my, is this page... ugly. All the mixed fonts and barely readable colors. They aren't even consistent in using underlines and colors for links. Total mess if you ask me. Wouldn't even consider becoming a customer looking at this LP only.
Thanks! BTW, I'm not sure limited applies. There are several setups with thousands of nodes and users doing some pretty complex multi-tier orchestration magic (N-tier, load balancers, monitoring outage windows, Jenkins, all integrated, etc). And you've got ansible-pull for mega-large scale if you want.
This is pretty cool, they hacked the hacker http://www.youtube.com/watch?v=6p7FqSav6Ho

That the Chinese are doing this, we knew from many corp and military espionage stories.

I wonder about Mandiant. The Chinese will probably target target them with all their might, but then they will get a lot of work in USA. Going public must've been a tough decision.
From 1980-1982 he worked as a mechanic. Its in his resume.
How would you sum 4 numbers with 2 adds + 2 shuffles

(sorry, I'm rusty in SIMD)

But remember, similar (old, but simpler) tricks were adopted by compilers, like xor to load 0, lea to do math (not sure about this one), shifts instead of multiply/divide etc
I still don't get it. This emphasises on "productivity". Tablets, lacking any efficient ways of input are not productivity devices. They are great at consuming content, of course. There is a reason the iPad and the Kindle Fire rules the field.
The Importance of Random Sampling