npub1y4…jh9df on Nostr: I guess we have a different view of the reliability of sqlite, I believe it is so ...

I guess we have a different view of the reliability of sqlite, I believe it is so used and documentend and dissected that in case of emergency it will be easier to concoct a one-shot extractor of data

> but they are more work if one can rely on SQLite

sqlite also provides indexing, which will be unavoidable for pruning old content, deduplicating blobs, finding files that actually changed, etc...

> Would you have a link?

You may 'pragma wal_autocheckpoint=0' to disable autocheckpointing in wal mode

https://sqlite.org/pragma.html#pragma_wal_autocheckpoint

and then manually checkpoint with 'pragma wal_checkpoint(TRUNCATE)'

https://sqlite.org/pragma.html#pragma_wal_checkpoint