On 12 Apr 2010, at 5:59am, Steve Bywaters wrote: > I am currently using a proprietary ISAM database for an application. > These files are .TPS/Topspeed format files, for Clarion, which have built-in > encryption via a 'password'. > > Since sensitive setup and sales data is contained in these, I would want to > maintain that level of security. > Any way I can do that with a SQLite db? > Both for access (ODBC) and for content (should not be human-readable via > query).
The main architect behind SQLite runs a company that maintains a non-free encryption add-on to SQLite. You use all the SQLite commands just as you would with an unencrypted database, but you pass in a password when, or just after, you open the file. Without the password you get nothing. And reading the file from the disk just gets you gibberish. For further details see <http://www.hwaci.com/sw/sqlite/see.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
