An Sqlite database is one file. How about using an encrypted file system. If you have web access try SSL,
Jay A. Kreibich wrote: > On Mon, Apr 07, 2008 at 09:34:51AM -0700, Gerald Johnson scratched on the > wall: >> Hope I am sending this to the correct group. Sorry if I should be >> posting this to a different one. >> >> I have a CD application that a vendor is suggesting that I use SQLite as >> the db. My concern is security. Currently we are using Access which is >> password protected, but very slow. I have not found any information >> about having SQLite password protected. Is it possible, and I just >> missed it? And/or do you have another suggestion. > > Depending on the level of security you require, you could write a VFS > module that encrypts the pages as they are written and decrypts them > when they are loaded. If you can hook into the default functions, > this would be pretty straight forward. > > If you only need to protect specific columns, you could also just > write a user database function that encrypts the values before they > are written. Write a decrypt function that is used in a view and > you're good to go. This would only work for moderately large text > or blob values, however, and only if the actual values (and not the > structure of the database, number of records, etc.) needed to be > protected. > > -j > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
