skysight-inc/HackerNews huggingface dataset:
The first stack exchange when I googled was pretty interesting. For completeness, if you use innodb as your engine

SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Seems to be the line you are asking for. There's the usual way to make it a system default in the config file. As for the difference between what you are asking to do, and what you should do, well... be careful. Especially if you're feeding the dirty read back into something that could lead to an update. That could be icky.

There's some way to do myisam stuff.

Generally I've found if you've got two things trying to lock one thing, overall processing goes a lot faster if one greedy dude grabs it for the whole thing. Cooperative multitasking doesn't work if it spends way more time lock switching than actually processing. Of course greedy processing is an excellent way to jam things up if you're not careful.

The funniest discovery I ever made about that related to importing zillions of rows with autocommit off it was dramatically faster rather than demanding an I/O store. This was the kind of data where if someone yanked the power cord it would be auto-re-imported without any loss; if your only copy of the data is in RAM and the INSERT you just ran, then autocommit off might be unwise.

Your IN (...) if ... is a select that might none the less be similar to my fun time a couple years back with dueling indexes. This is the origin of the whole never index more than you have to meme because it doesn't just waste storage and write time, an "innocent" looking pathological index intended to make some report run faster can kill read performance if its touches too many things other indexes touch while "separate" processing is happening. If you don't know A leads to B, B leads to C, C leads to D, then why does messing with A kill D performance when D should be totally separate, ah forgot about that peculiar linkage...

Note that none of this is a mysql problem. You can shoot yourself in the foot with a common 9mm or a weirdo caliber. More people get hurt by the 9mm not because it inherently magically hits feet more often but because theres just more people using it. I'm quite sure you can screw up Oracle or DB2 the same way if enough people try hard enough. I guarantee if you google you're going to find more "mysql did something weird" stories than any other DBMS simply because more people use mysql.
It's not really a password manager--there's no shared secrets. The site identifies you by a public key. For authentication, it gives you a nonce, and you sign it with the corresponding private key. All the secrets are kept on your device.

I've wondered about the "something I know" dimension as well. Perhaps a passphrase could be used (it already is used to secure the master key). It'd still be a major improvement, as only your local device would need it, and you wouldn't have to have a separate password for each site.
Can you embed private videos on youtube in a webpage?
I'm not talking about MTurk specifically, but about all below minimum wage jobs.

> but they're unable to realize that, so we should decide for them because we know best

They are we, we are they, we're one society and if we democratically set a wage floor, then yes, we know best. That's rather the point of democracy, to remove choice about some things from the individual and make them together because it's better for us all despite what any one individual might choose.

> Or is the safety net not available to them because MTurk exists? Because if it's the latter, I don't see why wouldn't you just make it available, MTurk or not.

You'd be presuming the rules behind social programs are logical, they are not, they are designed by committee and as such can be haphazard and often illogical. Making money can actually hurt you if you're on the safety net because there's a hole where you're job would disqualify you for benefits that could exceed what the job would pay. Of course that varies state by state so there's no single answer to the question.

So until the safety net is more logical and lets you work without putting you in a worse position, then it's rational to simply not allow jobs that don't pay a living wage. Many have proposed a basic income to avoid this problem.
I like the idea, but as quite a few people mentioned, the execution is really below par, esp the UI and not loading properly on chrome at all.
It helps to provide cover. He's just another 20-something in the bay area. One of the smarter moves he made, some of the others not so much.
http://attrition.org/errata/charlatan/steve_gibson/

> Steve Gibson is somewhat of a "fringe" charlatan. In some professional security circles, he is not considered a reputable security professional, rather more of a snake oil salesman peddling third-rate software with bold claims. While many of his claims are a bit outlandish or bold, few, if any, are demonstrably false. However, when asked to speak on security topics, Gibson is getting adept at putting his foot in his mouth. A single amusing quote may be laughable, but a series of them begin to paint a picture of someone who doesn't really understand security. Rather, he seems to know enough buzzwords and ideas to be dangerous to his clients.
Napster is down - this is the END of illegal file sharing (SilkRoad) r/Bitcoin
OAuth callback from GitHub fails :(
Online 'Lean Analytics' Workshop
Save that money and market for 'free'.

Embrace online communities that might like your app. Market to them.

Use Twitter to spread the word. Tumblr is also a great place to help something go viral.
Surprised Kitten Video [0:05]
Great line...

Napster is down - this is the END of illegal file sharing

Oh well, I guess we go back to renting video cassettes now.
(any similarity with SilkRoad is purely coincidental)
Power Laws: So What? Optimization, For One
Monsanto Buys Climate Corp for 930 Million
I'll admit, I started programming young, about 8 years old (probably not too atypical in this forum though). The other day I realized, the new hires here were born after I started programming. I now better understand how a couple friends in college, non-traditional students who came back after stints in the military and other career attempts, felt.
Top-left header logo is fuzzy because it is being stretched.
- Chrome, PC
So does the guy who answered this get a "Aiding Criminal Masterminds" badge?

In all seriousness, I know that this feeling is irrational, but I would feel pretty terrible if I helped someone on SO and then came to find out they were running a billion dollar criminal enterprise.
This. betweenness, centrality, distance, nodes and edges are all graph theory terms. I wrote that in Safari on an iPhone so it wasn't easy to proofread. A few typos and one repeated word in there.
The substantiation of the $0.25/hour claim is that they were able to find three people who were willing to work for that much on one task, once. I think this is extremely weak evidence to base a lot of outrage on or to make a claim of what the market hourly rate is on MT.
Now that's a nice analogy, I guess the market dynamic rules it all.
I don't think this is what did him in. Posting advertisements for silk road [1] and then posting his personal email address [2] from accounts with the same name seems the more likely cause.

1) http://www.shroomery.org/forums/showflat.php/Number/13860995

2) https://bitcointalk.org/index.php?topic=47811.msg568744#msg5....
It sort of is. If I say George Bush is stupid, and you reply that I'm stupid, you haven't really refuted my point. Though maybe if I say George Bush should recycle, and you reply that I don't recycle, you've indirectly challenged my point by bringing attention to my contradictory hypocrisy. Hmm.
http://en.wikipedia.org/wiki/Red_and_White

Along with five other countries.
No, from the available information (including the indictment) it did not appear that Megaupload complied with DMCA laws. Specifically:

(1) They sought to rate-limit DMCA takedown requests

(2) They operated the service with red-flag knowledge of copyrighted content, such as when a user complained that the video quality of the Showtime show "Dexter" was poor, and Kim Schmitz mailed his team to work on improving the quality of that content.

(3) They themselves used the service to exchange copyright-encumbered material, such as the movie "Taken".

(4) They operated a paid incentive program to get users to upload copyrighted content, and in their itemized performance reports for the program acknowledged repeatedly that the content they were paying for was copyrighted.
Have you compared the test scores of poor white children with the test scores of upper middle class black children? The results are, uh, interesting.
Apple could easily remedy this by denying approval to media apps for websites that offer degraded experiences for iOS users. Problem solved.
Reference for "poor children watch more television": http://thegrio.com/2012/10/01/study-children-from-african-am...
As a Vim newb (well, ok I can use it, but I'm not well-versed in its more arcane elements), how do you select lines? C-<space> in emacs starts region selection, but I've never tried to select anything in Vim.
Event to start a health startup with an enterprise client baked-in
It's up to web designers/developers to take the shitty ideas of their bosses and turn them into something that is at least usable, and hopefully doesn't do evil shit.

The problem is, most developers/designers get saddled with tasks like this, and they think, "I fucking hate that I even have to do this in the first place -- why would I spend another goddamn second on it?" And they leave it the shitty experience that they know their superiors will sign off on.

Like any other job your results are only as good as the pride you put into it.
I like YouTube's page loading bar though.
Silk Road: Theory and Practice
Yes, for a (full, four freedoms) source license. I'm equating being able to compile source code into binaries with owning the means of production, where "owning" means "controlling" (which is what it usually means anyway).
> Obviously a manufacturer is not directly at fault when someone misuses their product, and they also are only selling what the consumer wants, but what level of responsibility do manufacturers have to help the consumer make good choices?

As much as I agree with the sentiment of responsible companies (with my upvote), IMHO the reality is that consumers are the ones calling the shots.

Demand is like a vacuum suction. When there is a demand there will be supply, even if some don't choose to provide on moral grounds, others will fill in. No demand, no supply.

The only responsibility that companies have is to make money, and that is done via making products consumers want. If consumers want to buy only from the responsible companies, all viable companies will be responsible.

They aren't all responsible because we don't all vote with our wallets that way.

Look at the demand for health food these days even causes McDonald's to offer salads. Change demand, and you change supply.

> We have an obesity epidemic. More people in this country are overweight than not overweight. It's becoming a national health crisis, and costing us a lot of money.

Each individual is responsible for his/her own health. We can't legislate unhealthy lifestyles away. We can only educate and motivate people to learn more and take control of their own health, starting from not visiting the highly popular junk food isles.
Not to use a debate cliché, but isn't this a ridiculously shameless ad hominem? He's published the protocol and disavowed any intellectual property claim to it. Let's focus on critiquing the protocol.
Workaround, why not making the tunnel yourself?

ssh -L5555:127.0.0.1:5432 host

Then you have it on your local 5555.
drivebyacct2 - your account has been dead for about 100 days and 200 posts, basically no one can seen your messages unless they have showdead on. Here's the "offending" post that you were banned for https://news.ycombinator.com/item?id=5982741 (hint - the ban is completely unjustified)
Weak reference implies a safe error result if you access a weak reference after a "strong" reference has been released, not undefined behavior. Not just a pointer.

For refcounting and real-time, just let me leak the cycles. The non-realtime part of reference counting is the cycle detection, let me control the cycle sweeps and everybody's happy.
Question for HN people: Do you associate the word hacking with computer security? I know I do, and it took me a long time to find that the website was talking about hackathons and not computer security.

Sidenote: rewarding students for travelling seems to bias the scoring in favor of densely populated places like the NE.
Absolutely - why o why do you have random purple icons taking up half the screen, pushing your content below the fold? Ditch em!

edit: Having browsed the rest of the thread I see this may be a bug. If it helps, I am using: Version 28.0.1500.71 Ubuntu 12.04 (28.0.1500.71-0ubuntu1.12.04.1)
So, why does that pop-up still come up inside the app: https://news.ycombinator.com/item?id=6484924 ?
I like the idea kinda of wish it was more tongue in cheek.

"Copypasta, the Old Spaghetti Factory of code"

On a slightly more serious note, if they are the youtube of code, how are they going to remove the xenophobia from the comments?
Chrome Version 29.0.1547.76

Here is an album with some of the things I saw very quickly:
http://imgur.com/a/54HrY

There are a lot strange alignment issues all over the place, so maybe pay some attention to that.

Again, don't get disheartened, the idea speaks way louder than the design.
If someone here were to market this product, do you have any suggestions as to how they could reach other customers as well, enough to make it a sustainable business?
You seem to be under the impression that there is but a sole optimal IQ. This seems unlikely, when one thinks about the radically varying conditions lived by humans at, say, the Arctic Circle and the Equator, particularly before the rise of globalism.
Founder of Runnable here. We've got some reports that the site isn't loading properly in some browsers. We're working to fix this now, and ask you to retry in an hour :)
- Yash
You might be right. From the article:

> Based on forensic analysis of the Silk Road Web Server, I know that the computer code ... includes a customized PHP strip based on 'curl' that is functionally very similar to the computer code described in Ulbricht's posting on Stack Overflow, and includes several lines of code that are identical to lines of code quoted in the posting.

> Oh, and the encryption key on the Silk Road server ended with the substring "frosty@frosty." Whoops.

I don't know if that encryption key was a public key, or if they found it after gaining access to the server. But if it was public, then a search for the username 'frosty' would have turned up the SO profile.

You also can't do 'forensic analysis' on HTML to figure out the PHP code, so they must have used an exploit. Or like you say, it was retrospective, after taking control of the server.
I am trying my hand at a few things... will keep this in mind
Doing programming
This looks pretty well-designed! Although I will add that you can achieve similar functionality if you code a Raplet[1] for Rapportive. (and it's free)

[1] http://code.rapportive.com/raplet-docs/
Google Cloud Developer Challenge
Flexible Hours (Inside Github)
This happens notoriously on a Facebook I own. Always popping shit up about promoting posts and running campaigns.
The license give users the right to copy, and to do modification to GPL software. It also says that users should be allowed to install said modified software on devices which the users has full ownership over.

Apple has the opinion that they should still retain control after a device in sold, giving them practical ownership after sale. This method of corrupting property laws for leverage over other peoples property goes directly against what the author of a GPL software wants, and is such written into license.

Apple with their appstore has thus a fundamental disagreement with the wishes of the author to GPLv3 licensed software. The author can give apple permission on this issue, allowing distribution on the appstore (if Apple accepted it), but that's a copyright concept. Authors can always give permission to someone else about their copyrighted work, but so long the author believes in property laws and peoples right to be in control of their bought devices, its unlikely they will give Apple that extra permission.
Can someone explain to me why it says New York when he was caught in San Francisco? Does the FBI not need to file a complaint in the state where he was arrested?
Same issues here in Firefox 27.0a1 (2013-10-01) on Windows 8
I'm not sure about the downvotes either, maybe HN dislikes things like "/facepalm" (I don't care, btw). However I share your disbelief. The guy was running a fairly advanced, high profile, illegal market online and a key piece of evidence linking him to this crime was down him messing up something really pretty simple in a PHP script and asking on a programming Q&A site - that's pretty astonishing.
Z Proxy - Leveraging S3 for high availability
You're changing the rules halfway through the contest?
Are you also disappointed that there aren't any transgendered experts listed?

Diversity is great, yes, but can we please stop suggesting that there is sexism happening here?
The font is obviously "American Typewriter".
> Why on earth would asserting that I would behave ethically

Let me construct a parallel scenario that might make it obvious to you. Let's suppose you're hiring a nanny to care for your children while you are away at work (not that you or I could necessarily afford such a thing). You tell the candidates your requirements for how the children should be treated while you are away, including what food they may eat, what shows they may watch, the ways, if any, they might be disciplined etc.

One of the candidates, upon hearing these requirements, declares that he will follow them up to the point he feels they violate his ethics or morals.

Do you hire this candidate? If no, why not?
Government employee here. Many of us aren't working on the promise of payment - we've already been paid. My salary was already "paid" two years ago. Congress passed a bill, the president signed it, and the DOE gave us the money. Now, if the government shutdown lasts until May, we'll probably be out of that money then I'd stop receiving paychecks. Of course, I hope to have a new job by that point, anyway.
Some have made the objection that phone benchmarks should test the CPU and removing the underclocking is entirely appropriate.

Isn't this somewhat intellectually dishonest though? A phone is a system, and how fast the CPU can run given the constraints of the system is a testament to the manufacturer's hardware and software engineering abilities: the software's power management, the hardware and ID's thermals. OEMs shouldn't give themselves a free pass on this. We know how fast a snapdragon can go. Now let's see how fast you can make it go in your handset.
Out of Sight, Out of Mind – Visualizing Drone Strikes
There seems to be a pattern in society over the last century, towards social liberalism/acceptance among people (sex, drugs, race etc). This of course happens very slowly and takes decades.

The big question is how this will affect the intelligence community long-term, who are becoming simultaneously more important, and simultaneously more threatened by technology and the openness of the internet.

Will they be forced to become more transparent or succeed in their fight to keep growing in power/secrecy?

Having an extremely large and powerful government, now even more obsessed with aggressive enforcement of law, is almost always going to be continually at odds with the peoples trends towards social liberalism.

The internet seems to have accelerated liberalization and terrorism seems to have accelerated state totalitarianism. So it seem's we're witnessing an acceleration in the battle between the two (especially if you live in the HN bubble).

The counter argument of course could be, and often is, dismissed by those who see the state as a representation of the people and total secrecy in the intelligence community as necessary for a healthy country/national security.
Java value-types (+ arrays) are in the works. The JVM already does what is known as "scalar replacement" (http://www.stefankrause.net/wp/?p=64) automatically allocating some non-escaping objects on the stack.
I don't know if the Google/Viacom litigation says anything about Google's lobbying prowess. Google is just trying to take advantage of the DMCA safe harbor, which is as old as Google itself and quite a bit older than Youtube.
If the NSA sniffed his bits, you must acquit.
This is actually extremely interesting, and a potential use for BTC that hadn't occurred to me yet -- as a flexible retainer for legal representation. You can notionally store the information necessary to access a wallet in your head, and provide it to a cooperative attorney without the need to possess anything that can be physically taken from you.
Fixing your boss' shitty idea is an optional, difficult and mostly thankless job. Getting a boss/client that has at least minimal respect for quality design and engineering is much better for mental health.
The lesson is that your ability to remain anonymous drops in almost direct proportion to the quantity of content you make available.

A careful user might have a more-shallow slope; they might be able to post more photos, if they're carefully scrubbing EXIF and being mindful of spillage (unintentional details in the frame). But every single posted photo is still inexorably eating away at their potential to remain anonymous.
Hey Guys, we just dumped our CDN cache. Is the issue resolved?
It was in another country, and the image was provided by the other country. Not sure about the law/case-law around how that works with respect to chain-of-evidence.
Care to elaborate how you think a constructor validates it?
"MySQL database which is quite troublesome because foreign-keys are not enforced"

Not sure what this means. Innodb will enforce them and has been the default for "awhile" although if you don't configure FKs it won't automagically do it for you (superficially, a DBMS that assumed any column named user_id is a FK for table user column id, although I bet that would create some amazing bugs occasionally) If you use myisam you can hack in FKs using triggers, which is icky/foul but you only have to do it once in the design phase. Or just don't use myisam unless you need its sometimes somewhat higher speed.

Something I say a lot is its a philosophical outlook difference. Outta the box, MySQL is a cub scout who always does his best, which may or may not have anything to do with what you think is a reasonable goal. On the other hand outta the box some DB like Postgres have no sense of humor and will go on strike / curl up and die if you ask it do something somewhat imperfectly or without the proper precise etiquette. Its somewhat easy to spend some time configuring either toward your project's philosophy or your personal philosophy.

This philosophy thing is why your comparisons were insensitive... the default outta the box collation was (is?) something weird like latin1_swedish_ci and if you merely change it to latin1_general_cs or whatever it "just works" and becomes case sensitive. Well what does the helpful cub scout mysql do, it makes sure you get all the results you could possibly want, in addition to some you probably don't.

I have run into slow schema mod problem before. Solution, don't change your schema.
"because the private key required to create the signature never leaves your smartphone."

Sure. People never get their phones stolen, never buy new phones, people never irreplaceably destroy their phones dropping them in a toilet.