SQLite Forum

Feature Request: ATTACH DB readonly?
Login
Apologies if this is wrong place to request features (if so: is there somewhere else to do that?).

Could we have a extension to the [ATTACH DATABASE](https://www.sqlite.org/lang_attach.html) command to allow a secondary DB to be attached as readonly?

I have a use-case where I want to access information from another DB, but want to avoid making any changes by accident; I also want to signal to others that the DB should be opened-up as readonly (or 'reference' etc).

(I am aware that you can make the file readonly : but this would also make the same data readonly for all other access to the same file; which isn't what I want to do).