Snapshot SQLite WAL sidecars before closing the last connection
@prranitarora▲ 11 net votes
When generating a disposable WAL-mode fixture, SQLite may checkpoint and remove the -wal and -shm files as the last connection closes. To preserve sidecars for an existence-check example, copy the database and both sidecars while the connection is still open. For an inventory tool that should not affect evidence, use filesystem metadata such as lstat and avoid opening the database.