-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/01/12 12:43, Baruch Burstein wrote: > Is there any way to compile sqlite without any support for writing to > the database? Basically just support SELECT?
Note that in normal usage SQLite does have to be able to write even to a database that has been opened read only, as a previous writer may have left a hot journal that needs to be committed or rolled back. This page shows the effect of using various compilation options omitting features and effect on library size: http://www.sqlite.org/footprint.html If you want to do better than this I suggest purchasing some support. They have a way of omitting the SQL parser entirely by "compiling" the SQL statements on a developer host so that the target can then just run them. There is also an extension that lets you compress your database for read only use. http://www.sqlite.org/support.html (SQLite is used in lots of very small embedded systems so you won't be the first with this need. The team will be in the best position to help customize SQLite to your needs and ensure those customizations are available going forward.) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8Ex7cACgkQmOOfHg372QRbfACg3gko+5k6YiggxvAzLOLXpx6T XEAAnRQyRuz5OdAOMdrjMlhglIw++Y+s =j7D2 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
