Re:SQLite is not a toy database
by sangnoir on Thursday March 25, 2021 @12:27PM
(#26582241)
It supports multiple readers, and writes are atomic - no reader should ever get corrupt data just because there is a write happening in parallel. You probably should not use the OS to copy the live db file, rather, have an in-process thread that reads the db and writes to a backup location periodically.
[ Parent
| on HN ]