Is there an easy way to open an sqlite3 database using the DB-compliant sqlite3 module in a way that is read-only? I want to access a database read-only on a file system that doesn't support locking. I know that the C api supports this, but can't figure out a way to do this with the sqlite3 interface.
As of Python 3.4.0 you can open the database in read only mode with the following:
db = sqlite3.connect('file:/path/to/database?mode=ro', uri=True)
Apparently it is possible using APSW, which is not DB API compliant.
At least that was the case in 2009.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With