If it didn’t “ever” happen, there’s a fair chance you weren’t closing SQLite cleanly. In the default configuration, those files only exist while a program is actively using the DB. You might want to check for this in the read/write case in case you’re causing SQLite to drop partially-complete transactions and such.