SQLite Forum

Can -wal -shm files be deleted if -wal file is empty?
Login
The power of using the <code>SELECT</code> method is that before it deletes the -wal and -shm files it checks to see whether SQLite thinks they are in use.  This is useful in making sure nothing has crashed while using the database.  You can delete the files yourself, but if any process accessing the database has crashed, or some process still has the database open, you may lose changes.