A plain file copy of a SQLite database that a program is still using can be inconsistent or miss recent writes. What SQLite's own documentation says goes wrong, and three supported ways to take a safe copy.
An inactive PostgreSQL replication consumer can retain write-ahead log files. Learn how to inspect slot state and choose between unbounded retention and a finite recovery window.
Marco Bambini's sqlite-multiwriter, a VFS extension created 8 October 2026, claims concurrent writers on one SQLite file. The 5.7x and 3.0x figures are the project's own runs.
A transaction can update two attached SQLite databases, but crash atomicity across both files depends on the main database and journal mode. Here is the boundary to check before relying on it.
Most small AI tools are better served by one database file than by a database server. Where SQLite fits, where its own documentation says to pick something else, and four settings worth turning on from day one.