4 ms·
> if the blobs (e.g. images) in the DBs are static, and transactions are read only/writes happen infrequently, then having all your blobs in one SQLite DB makes
by Repulsion9513 2y ago
> if the blobs (e.g. images) in the DBs are static, and transactions are read only/writes happen infrequently, then having all your blobs in one SQLite DB makes for an insanely easy backup strategy
Does it? Suddenly instead of just backing up the whole database you have to do delta backups which can make it quite a bit more difficult...
- gfv 2y agoYou can use streaming WALs, like Litestream does. It is a pretty simple way to do incremental backups.