On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer <tspenc...@gmail.com> wrote: > Is there a way to set the current database handle as read-only? I'm > connecting to an SQLite3 database (actually two including an attached > database) using Perl with DBD::SQLite, which doesn't seem to implement > the ReadOnly database handle attribute. Is there some kind of setting > or pragma that will set the handle as read only just for that > connection? >
This is puzzling... you are the one writing the programs... just don't write to the database. How hard can that be? On the other hand, you can always just chmod the SQLite db file to 444. -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
