Hi Olaf, so I took a quick look and it looks interesting, certainly very affordable. One caveat could be that it doesn't seem to work under OS X which will be important to me. Also all I coud find was how to encrypt stuff through their GUI, but nothing about available API. When I distribute the app the database must be already in encrypted mode and my frontend will take care of decrypt through the API. At least that's what I kind of envision. But maybe I missed something.
Thanks Marek Olaf Beckman Lapré wrote: > > Hi, > > Why not just encrypt the file system or part of the disk where the > database > is situated? I use TrueCrypt, a free open-source program, for this and it > works great and it's very fast. Unless you're doing hundreds of > transactions > per second, you'll hardly notice the performance loss (with > AES/Whirlpool). > You can then also encrypt USB memory sticks when you take the database > with > you. > > Regards, Olaf > > ----- Original Message ----- > From: "mxs" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Saturday, February 24, 2007 04:14 > Subject: [sqlite] SQLite - how to protect the data > > >> >> Hi guys, >> >> I am quite new here and quite new to SQLite. I am shocked how small and >> fast >> this database is. So far I've been using MS Access for my little projects >> and I cannot wait to replace it with SQLite. >> >> Now, I have a question which I will have to deal with. One of the >> application I work on contains data which have very high value. In >> another >> words the whole value of the app is the database, rather than the front >> end. >> If somebody makes a clone of the front end I don't care, but if somebody >> copies the database and uses the data for his own front end that would be >> a >> disaster. It is not a privacy issue, but rather the amount of effort put >> into filling the database up. I used to use a kind of crypto ActiveX when >> Access was used. It worked although slowed already not fastest database >> down >> which showed during search and filter operations. >> >> If anybody knows hot to ensure that the data is not readable without the >> front end I would appreciate it. >> >> I found a link talking about encryption, but this is not exactly >> affordable >> for my type of project. >> http://www.hwaci.com/sw/sqlite/prosupport.html#crypto >> >> >> Thanks for any suggestions. >> >> Cheers >> >> Marek >> -- >> View this message in context: >> http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9130596 >> Sent from the SQLite mailing list archive at Nabble.com. >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> ----------------------------------------------------------------------------- >> >> > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9136345 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------