I Copied a Live SQLite Database and the Copy Had No Tables: WAL Mode Keeps Commits in a Second File
python
dev.to
How can a byte-for-byte copy of a SQLite database file be missing a table the writer had already committed? I copied a live database with shutil.copy, opened the copy, and asked it for the table I had just created. It said there was no such table. The writer had committed every row. The copy was a faithful duplicate of the file I pointed it at. That file was not the whole database. Disclosure: I make an Android camera app. Nothing below uses its code or describes how it stores anything. Every