skysight-inc/HackerNews huggingface dataset:
MVCC in InnoDB and PostgreSQL are totally different. It is PostgreSQL and Oracle MVCC who have very similar, although not identical isolation behaviour (albeit very different implementation), but InnoDB MVCC stands apart from them.

At the beginning, I should point that the default isolation level in PostgreSQL and Oracle is READ COMMITTED, whereas MySQL uses REPEATABLE READ isolation level as a default. This means that in MySQL by default all normal (not FOR UPDATE) SELECT queries see database snapshot at the time when transaction started. In PostgreSQL and Oracle all SELECT queries by default see database snapshot at the time when the query (and not the transaction) started.

However, SELECT FOR UPDATE in MySQL sees database at the moment the query started, even with REPEATABLE READ isolation level. That is, it is possible that during the same transaction on default isolation level in MySQL SELECT and SELECT FOR UPDATE see totally different rows. In Oracle and PostgreSQL, SELECT and SELECT FOR UPDATE always see the same rows (at the moment of query start in READ COMMITTED mode, or at the moment of transaction start when in SERIALIZABLE mode). In other words, in Oracle and PostgreSQL SELECTs and UPDATEs see database at the same time in past, whereas in MySQL SELECTs see consistent snapshot at past, whereas SELECT FOR UPDATE and UPDATE see current data.

Also, as MySQL uses locks more aggressively, some "write skew" problems which are possible in PostgreSQL and Oracle, are not possible in MySQL.

I don't know what kind of MVCC is "better", but IMHO Oracle and PostgreSQL MVCC is much easier to understand than MySQL one. The difference between Oracle and PostgreSQL MVCC is the following: in READ COMMITTED mode, when long UPDATE query encounter some rows updated by concurrent transaction, it is blocked until concurrent transaction COMMIT or ROLLBACK. After ROLLBACK of concurrent transaction the query will continues execution, and this behavior is the same in Oracle and PostgreSQL. If concurrent transaction is committed, then PostgreSQL re-evaluates previously blocked row to determine whether it still matches the UPDATE criteria. But PostgreSQL does not re-check previously read rows which did not satisfy UPDATE criteria, whereas is is possible that these rows were also modified by concurrent transaction and now satisfy UPDATE criteria and should be updated. Oracle behaves in a different way: If long UPDATE query encounters some rows updated by concurrent transaction, and these rows no longer satisfy the UPDATE criteria, the query restarts and sees new database snapshot at the current time (remainder - I'm speaking about the default READ COMMITTED mode). This way Oracle doesn't miss rows which can be missed by PostgreSQL, but long UPDATE can potentially be restarted many times (that is, the query starvation is possible, although not likely).
http://asktom.oracle.com/pls/asktom/f?p=100:11%3a%3a%3a%3a%3...
I'm not really sure, I agree with you though.

For whatever it is worth, it seems they still provide some speed trap related services: http://www.theaa.com/apps/safety-cam-iphone-app.html
One of the reasons I like Django so much is because of the community. This might seem rather meta but the comments in this thread are generally positive. Most Django users I know are well aware of its limitations and don't try to sugarcoat it if Django is not the right tool for the job. But overall I've found the community (and that of Python) pretty receptive.
Thanks for the post - I regularly use a lot of these, and I'm a big fan of ng-bind attribute over the <div>{{ thing }}</div> approach.

Things that really caught my eye:

- ng-list: sounds very useful for user forms, tagging, etc

- ng-switch: I dont know how many times I've used ng-show to replicate this functionality. Thank you!
yeah the new Lumia is pretty interesting, as is the new Windows platform. I would be willing to consider the switch once there is truly seamless integration with Windows 8.1, as well as when the app store finally has quality apps.
Although I love the idea of not jumping from music app to music app - it really is a buzzkill - I wonder if listn will be able to integrate everything that's out there. I personally love: thefuture.fm, songza, soundcloud and obviously youtube (where else can you get all the splendor of wrecking ball) but then that means listn is half way to my dream coming true. The partnership with RDIO, which I know is super popular, is definitely impressive.
Without locks lost updates are possible because default isolation level is not SERIALIZABLE
There is zero chance that drugs like crack are going to ever be decriminalized.
I played with the idea of something like this a while back, but never finished it:

https://github.com/roboprog/buzzard/blob/master/test/src/mai...

It performed reasonably well in a demo doing a bunch of string concatenation, but I never followed up on it.

https://github.com/roboprog/mp_bench/blob/master/thd_frk.bzr...
Paramiko could be a good example i think...
The DEA has a budget of nearly $3BN. I doubt that money would go to the same types of jobs or companies if Bayer and Pfizer and others were licensed to sell Morphine and Amphetamines to the public. Seems like the FDA might get some more work, there'd be a bit larger need for customs inspections. But enforcement would go way down, especially without diversion control.

How much money and weapons are used in protecting bootlegged alcohol these days?
The scam is that they are skilled at not paying out when you need them.
What does "Flash Of Uncompiled Content" means?
I understand the line "By the nature of what they do, their successes are never clear." but I would think that will all of the bad "publicity" the NSA is receiving they would at least pull one example out where they prevented an attack. They have only release vague numbers on the number of incidents prevented and when put under a microscope they weren't a very big part of the plots they claimed to have foiled. I understand the "international disadvantage" but I don't think we can allow everything the NSA does with "Everyone else is doing it" defence.
My problem with your model is the apparent preconception that I (as an adult) shouldn't be able to take whatever drugs I feel like. Your regulatory scheme seems more appropriate for a substance like heroin rather than cannabis, as well.
I wonder why people aren't using calling the current unpleaseantness attacks (or war).
IT Security From The Eyes Of Data Scientists
"A lot can be done to use the data you collect around a particular environment to narrow down where you should be focusing on your security risks and that's where an in-house data scientist plays a part." Read more from Risk I/O Data Scientist Michael Roytman in this Dark Reading article
Global security sure is easy if you're an engineer working for a large tech company. I say that with as much sarcasm as possible.

Day after day I see post after post around the tech web about how horrible the actions are of the NSA but few if any propose a workable solution to balancing both securing and obscuring actions taken to protect a nation, with the public's need for privacy and protection from abuse.

Oversight, oversight, oversight is all we hear yet nothing concrete to describe how the US (or any nation) is supposed to provide security and keep the enemy from monitoring the techniques and actions taken by intelligence services.

Maybe I'm naive but I don't see a way to keep spying (something all nations do and have done for centuries) with the public's need for complete disclosure.
Sometimes I would really like to turn my internet connection off to get things done, but as a web developer it's quite impossible.

A few weeks ago I had no internet at home. It was great. Not having the possibility and not using it are two different pair of shoes.
Sweden, for example. Capital punishment was abolished for all crimes committed in peacetime in 1921, and for those committed in time of war in 1976[1].

But if you meant do say "wouldn't have executed" instead of "doesn't execute," I guess a European country that did not exercise capital punishment for treason during WWII might be hard to come by.

[1] http://en.wikipedia.org/wiki/Capital_punishment_in_Sweden
For Consistency (i.e. C, not I). Depending on the operations you are trying to perform and the isolation level you have chosen, locking may be the only way to update the database consistently, even within a single transaction.

See this paper for a good explanation of how C and I interact: http://aphyr.com/data/posts/294/tr-95-51.pdf
When Product Development is Better Than Customer Development
But let's say what we really hope for is true.
What if we somehow discover that a large number of these planets are teaming with life ?
What then ?
How would that help us ? Spiritually, economically ? Wouldn't that make us feel even less significant ?

I'm just wondering, why are we hoping there is life out there and what would we do if we find it ?
It depends on isolation level. Default isolation level in MySQL is REPEATABLE READ and not SERIALIZABLE. Without locks, lost updates are sometimes possible.
Insurance is a scam because insurance companies sell products with simple, big, headlines but complex fine print. They go to extreme measures to avoid paying out if possible.
The research says 22% of sun-like stars have Earth-like planets in their habitable zone. Seems like they're all based on different assumptions of the number of sun-like stars.

>Guardian: There are around 100bn stars in our galaxy, of which 10% are like the sun.

>ABC: There are about 200 billion stars in our galaxy, with 40 billion of them like our sun, Marcy said. One of his co-authors put the number of sun-like stars closer to 50 billion, meaning there would be at least 11 billion planets like ours.

>Kurzweil: The estimate was based on a statistical analysis of all the Kepler observations of NASA’s Kepler space telescope of the 200 billion stars in our galaxy. Given that about 20 percent of stars are Sun-like, the researchers say, that amounts to several tens of billions of potentially habitable, Earth-size planets in the Milky Way Galaxy.

n.b. Kurzweil's math clearly sums up to 8.8. Maybe he's adding in stars unlike the Sun and not mentioning it (given that the article discussed is based on earlier work showing 15% of red dwarfs have Earth-like planets in the habitable zone: http://www.nytimes.com/2013/11/05/science/cosmic-census-find... ).
Your design would be made vastly simpler by using LEDs that have the PWM built in. Then your MCU only needs to write to them when the settings need to change. Adafruit also carries this type. I've tried them and they are very easy to use. The interface is essentially a SPI bus. So, can I assume you're not willing to pay the extra cost for built-in PWM?
Why does everyone keep talking about removing it.

If the report is written from scratch every time, there's no need to remove the canary statement. You just don't include it in the next copy of the report.

The old statement is not changed or withdrawn, the new report just doesn't include the text.
The Unhealthy Truth About Obamacare’s Contractors
One problem with making them too inaccessible and too expensive is that it might make the illegal market attractive again, with the risk of bringing us back to the current situation. So I think the idea is viable but can only be pushed up to a certain point.
What to do if an asteroid was going to hit us
Batman.js - Build rich web apps in CoffeeScript and Rails
Privacy on the Internet today is so riddled with conflicts of interests and doublespeak that it's hard to know where anyone stands on anything.

Microsoft implemented a Do-Not-Track by default in IE 10 [0], only to later reveal it was planning an even more intrusive ad tracking system of its own [1]

Google added a Do-Not-Track feature belatedly to Chrome, buried within levels of settings and warnings [2]. And yeah, they're working on their own cookie replacement too [3].

Facebook meanwhile is tracking you across the web through its own re-targeting tech [4] and even your cursor movements on its site [5]

In fact, when companies like Google, Facebook and Microsoft want to dump cookies [6], I'd argue that we're already past the point where a Firefox can make a difference.

IMHO Internet tracking has become like fast food. A meaningful difference will only come when average users start caring about their privacy and are willing to make conscious choices for it.

[0] - http://arstechnica.com/information-technology/2012/08/micros...

[1] - http://adage.com/article/digital/microsoft-cookie-replacemen...

[2] http://www.pcmag.com/article2/0,2817,2411916,00.asp

[3] http://www.usatoday.com/story/tech/2013/09/17/google-cookies...

[4] - http://adage.com/article/digital/facebook-launches-retargeti...

[5] - http://www.pcmag.com/article2/0,2817,2426602,00.asp

[6] - http://online.wsj.com/news/articles/SB1000142405270230468250...
SelfControl: an OS X application which blocks mail and websites
Given that is where Mt.Gox is located, I would not be surprised to hear <5 days.

I have heard this before, "Mt.Gox is not a bad company to do business with if you're in Japan." They are not a sham company by any means, they are just hamstrung by US government intervention.
> It's free and open source, although

There's also kolab.org which is completely free software (uses Roundcube for web interface since 3.1).
Not all interruptions are created equal though. There are cases when interruptions should be tolerated. If someone is working on a problem (a tester, a support engineer, or another developer), and has a question I know the answer to off the top of my head, I’m fine with being interrupted.

Sure, my productivity takes a hit, but we should optimize for the company’s productivity, not only my productivity. If one (or several) other people in the company would be stalled, it’s better to ask me and get the answer in one minute, than to wait for an hour or two, or to dig around for an answer in the code or in the documentation.

From my blog post "Programmer Productivity – Interruptions, Meetings and Working Remotely" http://henrikwarne.com/2013/04/02/programmer-productivity-in...
I don't like the article either, but you're wrong about it being "extremely out of date", and you'd have a very hard time defending your argument with evidence. Do try.
Would it need to be decriminalized if cocaine was properly sold, like it used to be? One can quite easily cook cocaine into crack if they so desire.
You are so right. When I played a bit of chess I thought I'd teach my future kids chess, kind of like the Polgars. Then I read "Searching for Bobby Fisher" and "The Chess Artist" and completely changed my mind.
It's not like the Nazis had problems killing people who weren't spies. http://en.wikipedia.org/wiki/Weisse_Rose for example.
Nevertheless, requiring someone to actively act unlawfully is tricky. Furthermore, requiring someone to actively act against their beliefs is tricky. Getting someone to do so convincingly... very tricky.

Indeed, the fact that it's a civil matter makes it harder to circumvent, if anything - after all, there's a third party involved, and they don't need to accept the government's assertions that it was required (and note that the government doesn't automatically have a right to violate its own laws).

And of course, if any of this actually came to court, by that point it'd all be a moot.
An easy out when asked about current salary is to simply say "my contract does not allow me to discuss my compensation."
can we please try not to equate reality with "indiscriminate collection of private communications from every man, woman and child on the planet"
While the 5S is a pretty awesome phone, I have to agree with the author that it doesn't enable us to do anything fundamentally different than the 4. The major generational innovations:

3G - 3G data
4 - Retina display, FF camera
5 - LTE, screen size

All of those things are nice, but they simply make use of the phone faster, at a higher resolution with slightly more screen area. So I can check Facebook faster on a nicer screen.

I'd like to see some fundamental improvement in user interaction, something that enables us to do things we couldn't before. Google glass is pointing in that direction, but it's still along the same vein of more immediate, always on computing power. I don't think we've fully tapped the innovations that these devices can allow.

For example, I think the idea of the universal Ubuntu phone would fundamentally change the way people saw their phones, because it would allow their phone to become their ONLY personal computer by simply plugging into additional human interface devices (larger screens, keyboards).
Not all court cases are public.
Hard to answer, django 1.7 will take at least 9 months before become stable. You have(at minimum) to consider the calendar of your project.
I doubt most people know they have particular thinking pattern and when they think in images v/s words or in any other form.
A web poll would be nice though.
It's not decent enough, it's truly awesome! In fact it's the only reason I am reluctant to switch to a Mac.
Arthur Middleton-class attack transport
Not all Android compatibility layers are created equal.

BB10.0 shipped with an Android environment that could only run up to Android 2.3... And considering the power under the hood of the Z10, it was really laggy. And submitting them to BlackBerry World required the developer to modify it from a .apk to a .bar.

What matters is how big the barriers to entry are for getting Android apps on. Both for developers and users. Jolla can improve on this, and IIRC the Jolla Harbour won't be the only way of putting apps on the device, Jolla said there would be a 3rd party android app store.

And of Course, locking it down to a single app repo doesn't really fit with Jolla's vision of openness ;)
Good to know. 2$ is definitely worth. Pity there is not a trial version on the app store.

BTW, is it good to keep zero inbox? I'm so desperate that I was thinking about writing my own zero inbox-oriented client ...
Refers to when the page renders and still shows

{{ user }}

instead of the content that should really be shown in place of it.
That's exactly what politicians ought to do and exactly why politics should not be a career.

Granted, Kofi Annan was not a politician in the same way as the folks I'm really aiming this comment at, but still.
In the building where I live I have a neighbour that I thought he was 60 (or less) years old because it was very vitalized, moved very well.. and one day I happened to talk to him, he told me he is 74 years old, he obtained two university degrees when he was young, he had been a teacher, he also was a calligraphy national award and finalist of a novelist award..

I asked him what's his secret to being so active and vitalize at his age.. he told me "it's all in the mind" he then proceeds to tell me that he reads and writes every day (he is writing a piece of a novel everyday) I then ask him what is a better exercise to keep the mind active, reading or writing? his answer, "absolutely the writing, writing is the backing of the imagination".. and then I see this article on hacker news and start connecting dots..
Cool; support is limited. I like to think we did better at Sococo.com - we support dozens of simultaneous participants, a dedicated client and web clients too.

Here's a picture of Teamspace at work: https://www.dropbox.com/s/nb5tqqeux0n1xep/SococoMtg.png
We meet like this all the time; there were 23 people in that virtual room, 7 sharing webcams and one webcam in our central office. 2 documents were being shared, a common chat thread was going on. Probably many p2p chats going on; I couldn't see that as they're private.
مشاهدة مباراة برشلونة وميلان
مشاهدة مباراة برشلونة وميلان - http://www.alhqeqa.com/?p=26077
مشاهدة مباراة برشلونة وميلان - http://www.alhqeqa.com/?p=26077
مشاهدة مباراة برشلونة وميلان - http://www.alhqeqa.com/?p=26077
مشاهدة مباراة برشلونة وميلان - http://www.alhqeqa.com/?p=26077
NoScript will stop the jquery download. If that breaks the whole site then I probably don't need to use your webapp anyway.
My understanding is that Coinbase isn't 100% an exchange, though it does allow both selling and buying. I believe Coinbase bakes a profit into pricing; it's not a pure book.

A better point of comparison would be exchanges that were around at the previous peak, such as Bitstamp or BTC-E.
A concern is that the practicalities of such a legalization would just make things worse. It could make it much easier for children to get hold of. You would also need to define what is "pure" and police that for an endless list of possible products. It is difficult enough to keep salmonella out of food, effective regulation of cannabis sounds impossible. Any regulation would need to be sufficiently loose that you do not need a black market.

I would argue that the most important impact of drug use is to people who are not drug users. Any legislation should put the interests of those people first.
Slightly OT, but spending a bit of time on Gallup's website recently has shown me much I've misjudged the popularity of a lot of attitudes.
I submitted it earlier this year, however I do not think it qualifies since it was already published in a book.
valid point! I just think the line has moved just a tad since then and its important to define where it currently lies.
Uhm, who cares?
I'd say the last place to search for "moral leadership" is among the ranks of professional politicians.
That's the point. An extreme event will be something that puts you out of work for at least a month, and for many people, they will no longer have a job after not working for a month. Since their insurance is coupled in intricate ways with their job, it ends when they need it most.
I've used prerelease software and it is just phenomenal. I still work at Nokia but I have pre-ordered one and can't wait to get it!
"subsidies" is the new fancy term for "welfare" or "handouts". That's what it is, and there's no such thing as "free health insurance" only taxpayer-provided health insurance.
I've been waiting for this for a long time. The implementation looks great. Thank you!
I did not create this - I found it on HN a while ago, have shared it once or twice since in comments. I realised more people may want to use it and that it hasn't been submitted here for a while.
+1 for Ubuntu phone: THIS would be a fundamental game changer, and I can't wait to try it out.

I would have loved to expounded upon my thoughts on what the future looks like but I'm budgeting a certain amount of time every morning to blog and ready or not I'm hitting the publish button!
In some ranges, it's clearly the case that adding hours adds productivity. You are correct that we don't know it does this at the margin.
The log links don't send the full stack for every log line, only for the ones with fatal errors. moreover, the log links pace is controlled, so if your system "chokes" on logs, Takipi will lower the links rate, so they'll only appear when an "interesting" error occurs, i.e new/unfamiliar errors, or ones that provide you with new information.
Apple patents tech to detect movement at home
Show HN: Turn your favourite song into a t-shirt
Easy. Add to .mailcap:

image/*; yourviewer %s

Then hit "v" on the image attachment and it pops up in a window. I use xv (still) to view it which runs under X. Hit "d" to download it.

I handle HTML mail, PDFs, word documents, everything with complete ease.
What they should really do is open source their plugin or at the very least their spec.
I think it's more dangerous to seek alien life, spiritually and economically then it is to actually discover it.
Surely, Citizen, you're not arguing for a return to the dark days of the past, when words like 'treason' and 'espionage' had meaning.
Computer and Information Systems Managers are #12 on Highest Paying Jobs List
It's fucking terrible by comparison.
I was surprised to see Netflix so high and not to see Amazon on the list at all. Anyone else?