Hi! On 2018-10-05 19:05, Simon Slavin wrote: > 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.
I'm actually aware of litetree, and yes, it does support my usecase. But there are two things that I'm worried about: One is that it seems to keep old revisions forever without any means to "checkpoint them away". So if I keep changing my database, the storage size grows forever even if the database itself does not grow. And the second is that it is most likely not as well maintained and supported in the future as stock SQLite (even if it seems to be actively developed at the moment). If there is indeed no way to achieve my requirements with SQLite, I will most likely give litetree a try (as both of those issues are no show stoppers for me). But from reading about WAL mode it seemed to me that SQLite would most likely be at least close to supporting my usecase, so I hoped it could perhaps do it. Yours, Daniel -- https://www.domob.eu/ OpenPGP: 1142 850E 6DFF 65BA 63D6 88A8 B249 2AC4 A733 0737 Namecoin: id/domob -> https://nameid.org/?name=domob -- 3.6.0: Bar-Pri-Ran-Rog-Sam-Val-Wiz To go: Arc-Cav-Hea-Kni-Mon-Tou
signature.asc
Description: OpenPGP digital signature
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
