Repository navigation
Expose an interface to sqlite3_file_control #128505
Description
Feature or enhancement
Proposal:
sqlite3_file_control can affect the semantics of a sqlite3 database, but is not exposed by the sqlite.Connection class. In particular, I would like to use the SQLITE_FCNTL_PERSIST_WAL opcode, which ensures that callers can open a WAL-mode database on a read-only mount even when the writers have closed the DB.
Has this already been discussed elsewhere?
This is a minor feature, which does not need previous discussion elsewhere
Links to previous discussion of this feature:
No response
Linked PRs
Reacted by Chris Wilson and Jeffrey Bosboom
Activity
jbosboom commentedon Apr 25, 2026
I'd like to use the SQLITE_FCNTL_DATA_VERSION opcode. This is SQLite's only interface that detects changes on both the current connection and other connections. It isn't exposed as an SQL-level pragma.