On 5 Oct 2018, at 4:39pm, Daniel Kraft <d...@domob.eu> wrote: > I need the ability to make multiple changes / commits to my SQLite > database but keep snapshots of previous states and potentially roll back > to those states later on. All of that needs to be persistent, i.e. > survive closing the database and restarting the process.
This cannot be done within SQLite as it is written. You need a project which takes those requirements into account, such as <https://github.com/aergoio/litetree> That project may be what you want, but I have no experience with it. But it looks like it's worth a try. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users