I've noticed that every time my project runs these files are created.
If I make any changes in the database (for example a new entry) and delete .db-shm and .db-wal files the changes are lost.
When I was using journal mode the foreign key records were not was deleted on cascade. Now I use only PRAGMA foreign_keys = ON.
The files .db-shm and .db-wal are created quando app run. They are automatic deleted when I use SQL1.Close.