SQLite Forum

sqlite opens a database file in R/W mode, even if the file is read-only
Login
I do not think you need to start a transaction to use the `sqlite3_db_readonly()` API.  It appears to work correctly without having to start a transaction first.