Re:What If OpenDocument Used SQLite?
by rakoo on Monday September 18, 2023 @10:30AM
(#37556617)
You can keep a distinction between old and new version inside the same database, by having a pointer to the "current" version, and updating the pointer when clicking on "save". You could store all changes in the database in a "staging area", such that when you reopen the app you can load the changes and you don't need a recovery phase, but with the "save" button active meaning that something changed since last save.
[ Parent
| on HN ]