I have a database that I want to be only read-only. I read in the optimization FAQ that this will make sqlite not create a journal and so run faster. I changed the permissions of my database file in Linux (removed the write permission), and sqlite was still able to create a new table. Since this file should never be written I also want to get an error if it is by some fault in a querry I write. So any ideas about how to make this entire database read-only? Is there a way to do this in sqlite itself? Thanks!
Josh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users