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 -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
