My primary database is opened for read/write. I use the ATTACH command to attach a second database that lives in a read-only filesystem.
It appears to mostly work, but is there anything I should be aware of or concerned about? One thing I noticed is if I run "ANALYZE" once the read-only is attached, then ANALYZE fails, perhaps for obvious reasons... Is there a way to ATTACH and explicitly specify a readonly flag? I'm not doing this yet, but what about the other way around - readonly main db, with attached read/write databases? Thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users