New blog post: Caveats Using Read-only SQLite Databases from the App Bundle
https://twocentstudios.com/2025/06/07/sql-databases-bundle/
A quick debugging story where I learnan some new things about SQLite's journal mode while building an database export/import feature for Eki Live.
TLDR:
- Journal mode is embedded in the sqlite database file itself.
- The `backup` command changes the journal mode of the target database to match the source database.
- Check the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode;"`.
- Change the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode=DELETE;"`.