3 ms·

I think SQLite is a probably a better approach than manually snapshotting. How often to snapshot? You will get significantly less data loss and architecturally

by klabb3 3y ago

I think SQLite is a probably a better approach than manually snapshotting. How often to snapshot? You will get significantly less data loss and architecturally very similar operational simplicity. You can also handle disk sized data sets vs memory size.

0cf8612b2e1e 3y ago
Now I all wondering, can you use the LiteStream online backup tool against an in memory database? Or does that machinery only work against a materialized database?
- klabb3 3y ago
  Good Q. I don’t think so? But you could tune SQLite to not wait for disk writes and have a larger memory use, which would make it extremely fast for memory-sized data sets. If you’re not intend on using disk at all, then not too much point having backups?