Hacker News with Generative AI: Transactions

Things that go wrong with disk IO (eatonphil.com)
There are a few interesting scenarios to keep in mind when writing applications (not just databases!) that read and write files, particularly in transactional contexts where you actually care about the integrity of the data and when you are editing data in place (versus copy-on-write for example).
Distributed Transactions at Scale in Amazon DynamoDB (2023) (blogspot.com)
This paper appeared in July at USENIX ATC 2023. If you haven't read about the architecture and operation of DynamoDB, please first read my summary of the DynamoDB ATC 2022 paper. The big omission in that paper was discussion about transactions. This paper amends that. It is great to see DynamoDB, and AWS in general, is publishing/sharing more widely than before.
DSQL Vignette: Transactions and Durability (brooker.co.za)
The hard half of a database system?
Why is Snapshot Isolation not enough? (blogspot.com)
Postgres Storage as a Transaction Journal (neon.tech)
Eight Transaction Papers by Jim Gray (arxiv.org)