News for hackers. Stuff that matters.
Re:Databases in 2025: A Year in Review by thesz on Monday January 05, 2026 @01:59PM (#46503064)
For this database has to have nested transactions, where COMMITs do propagate up one level and not to the actual database, and not many databases have them. Also, a double COMMIT may propagate changes outside of agent's playbox.
Re:Databases in 2025: A Year in Review by quotemstr on Monday January 05, 2026 @02:01PM (#46503090)
> For this database has to have nested transactions, where COMMITs do propagate up one level and not to the actual database,

Correct, but nested transaction support doesn't seem that much of a reach if you're an MVCC-style system anyway (although you might have to factor out things like row watermarks to lookaside tables if you want to let them be branchy instead of XID being a write lock.)

You could version the index B-tree nodes too.

Re:Databases in 2025: A Year in Review by thesz on Monday January 05, 2026 @02:26PM (#46503470)

  > but nested transaction support doesn't seem that much of a reach if you're an MVCC-style system anyway
You are talking about code that have to be written and tested.

Also, do not forget about double COMMIT, intentional or not.