News for hackers. Stuff that matters.

A comment on What If OpenDocument Used SQLite?. Parent comment

Re:What If OpenDocument Used SQLite? by remram on Monday September 18, 2023 @07:28AM (#37554800)
Why not use a transaction?
[ Parent | on HN ]
Re:What If OpenDocument Used SQLite? by p4bl0 on Monday September 18, 2023 @03:12PM (#37560604)
A single transaction for the whole user session? That seems a bad idea. Also I'm not sure you can do transactions during another transaction, and I need them for other purpose for what they were designed (doing changes in multiple tables that need to stay consistent).
[ Parent | on HN ]
Re:What If OpenDocument Used SQLite? by subleq on Monday September 18, 2023 @05:09PM (#37562096)
It’s exactly what transactions are for. A nested transaction is called a savepoint, which sqlite does support.
[ Parent | on HN ]
Re:What If OpenDocument Used SQLite? by remram on Wednesday September 20, 2023 @10:41AM (#37584788)
How could your database get inconsistent if you never write it?
[ Parent | on HN ]