SQLite Forum

Can I get the file name of a temporary on-disk database?
Login
While I feel that this is out of band for SQLite, that's up to the SQLite devs to make that call.

Could you not open a temp file using `mktemp`, write in an empty SQLite file you provide as part of your applications assets (and perhaps even have that file prepopulated with your basic schema if that makes sense), then use it as a normal db file using SQLite's normal interface?