Top all-time · #23992
Michael Melanson
Personal blog · michaelmelanson.net · on HN as a-prioriprogrammingsystemscareer
Michael Melanson's personal blog at michaelmelanson.net covers programming, systems and career. Since 2014, 3 different Hacker News readers have linked it 4 times, most often “Transactions: the limits of isolation”. The last post was in 2019, but the archive is still widely read.
Too few sampled comments (1) to say how often HN recommends it.?
Why HN links it
HN readers link Michael Melanson's Hermitage post, which tests the "I" (isolation) in ACID for databases. The comment discusses default isolation levels and lost updates in RDBMSs.
Summarised by Claude from a sample of 1 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Transactions: the limits of isolation3 people · 3 mentions · first linked 2014-11-25
What Hacker News says?
Your first ("very unnatural") example is what I had in mind. And since read committed is the default isolation level in most RDBMS, it is prone to the lost update anomaly. (In MySQL, repeatable read is the default, but its implementation of repeatable read doesn't prevent lost updates.) Note I did point out that I'm referring to the default configuration, not the strongest supported isolation level. Although your se…
Comment linking /2014/03/20/transactions/
on “Hermitage: Testing the “I” in ACID”Submitted Transactions: the limits of isolation as a story · 4 points
HN discussionIn case it's interesting to people, here's a blog post I made earlier this year on the topic of what exactly transaction isolation means: http://www.michaelmelanson.net/2014/03/20/transactions/
Comment linking /2014/03/20/transactions/
on “Hermitage: Testing the “I” in ACID”Submitted Running on the treadmill as a story · 2 points
HN discussion