SQLite temp files not getting cleaned up

[cinnamon-bun]

*-shm and *-wal temp files are getting left behind when quitting the process. SQLite is supposed to delete these on exit, and also if it finds them when starting up, but it doesn't for some reason.

https://www.sqlite.org/tempfiles.html

The WAL file is created when the first connection to the database is opened and is normally removed when the last connection to the database closes. However, if the last connection does not shutdown cleanly, the WAL file will remain in the filesystem and will be automatically cleaned up the next time the database is opened.

[pietgeursen]

This might point to things not being done right in patchql. But it might also be a bug in a lower layer.

I'm tempted to think this is a non-issue if there are a couple of small files that hang around along side the main sqlite file. What do you think?