4 ms·

Using SQLite for persistence is quite interesting! http://drakon-editor.sourceforge.net/instant_save.html http://drakon-editor.sourceforge.net/instant_save.htm

• vog 11y ago
  I fully agree with their strategy of persistent saving incremental steps. However, the article misses one vital point: Undo! Persistent saving without undo is a no-go. If I try something and the program (or OS) crashes, my previous state would be lost. It would be a state worse than not having saved the changes at all. In particular, I find it troubling that they describe their SQLite actions as "insert", "update", "delete". I would have expected this to be insert-only, to preserve undo functionality after a crash. Then, from time to time some "delete" for garbage collection (maybe triggered by the user).