5 ms·

In sqlite the on-disk file format does not matter. All that matters is that you should be able to issue sql to the sqlite embedded library and get back the res

• quickthrower2 3y ago
  It matters for 2 reasons. One, the expectation that the file changes only when you click Save is broken (as mentioned in another comment), and Two, unless you pin the version of sqlite forever then the file format may have braking changes or your need to deal with migrations.
  • eastern 3y ago
    > expectation that the file changes only when you click Save is broken This has nothing to do with sqlite. You can have (or not have) gradual saves in any file format. It's a choice that the developers of that app made. > file format may have braking changes The sqlite file format is unchanged for 19 years now. A world of features and capabilities have been added since. Don't hold your breath waiting for the sqlite format to change.
    • quickthrower2 3y ago
      This is not gradual saves. File changes when nothing has saved even, according to that comment. Fair enough about the history of it not changing and you can always embed a frozen copy if it does. But this is a pragmatic assumption not a guarantee.