Determine if a database is read-only
Small. Fast. Reliable.
Choose any three.
SQLite C Interface
int sqlite3_db_readonly(sqlite3 *db, const char *zDbName);
The sqlite3_db_readonly(D,N) interface returns 1 if the database N of connection D is read-only, 0 if it is read/write, or -1 if N is not the name of a database on connection D.