Tom Spencer wrote:
> I did actually think of chmodding the file with every connection.

The sqlite3_open_v2 call does let you specify SQLITE_OPEN_READONLY.  If
your wrapper doesn't provide this then the simplest thing would be to
update the wrapper.

  http://www.sqlite.org/c3ref/open.html

Altering the file permissions is a bad idea unless the database is never
going to be modified again.  This is because a crash at an inopportune
moment may require using the journal to fix the database, even when
opening read only.

Roger
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to