Re: [sqlite] SQLite - how to protect the data

2007-02-25 Thread mxs
PI, namely >>>sqlite3_key and sqlite3_rekey (see sqlite3.h header file of SQLite), which >>>are not implemented in the normal SQLite distribution. To use encryption >>>sqlite3_key has to be called immediately after the call to sqlite3_open. >>>That's all. >>> >>>Regards, >>> >>>Ulrich >>> >>>---------------

Re[2]: [sqlite] SQLite - how to protect the data

2007-02-25 Thread Teg
Hello All, You also have to accept that, if it's on the user's PC and they REALLY want that data, they can get it. They don't even need to crack the encryption. They just need to figure out what key the program's using to unlock the DB. There's absolutely no way to protect data that's stored on

Re: [sqlite] SQLite - how to protect the data

2007-02-25 Thread Adriano
> 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 Somebody is using that Sqlite Author solution ? May i used that solution on all the platform ? I need it for windows, mac os, windos ce

Re: [sqlite] SQLite - how to protect the data

2007-02-25 Thread John Stanton
One way or another you have to apply sweat or treasure to protect your data asset. Just how valuable is it? mxs wrote: Thanks Ulrich, but I think that goes beyond the scope of my knowledge and tools I have available to me. I wish somebody (who has C++ knowledge) has done it already and

Re: [sqlite] SQLite - how to protect the data

2007-02-25 Thread mxs
--- > To unsubscribe, send email to [EMAIL PROTECTED] > ----- > > > -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9144207 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite - how to protect the data

2007-02-25 Thread Ulrich Telle
Hi Roger, > The problem isn't so much how you generate keys, but how you use them. > Google shows over a million hits for 'pdf encryption crack'. You're certainly right. But there is a difference between the PDF encryption and the SQLite encryption I implemented. PDF encryption is designed in

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Ulrich Telle
Hi Marek, > Thanks Ulrich, but I think that goes beyond the scope of my knowledge > and tools I have available to me. > > I wish somebody (who has C++ knowledge) has done it already and > released version of SQLite with encrypt and decrypt functionality. Well, there is a prebuilt DLL with

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Nuno Lucas
On 2/25/07, mxs <[EMAIL PROTECTED]> wrote: I realize that, but this is about making it difficult for the average Joe not to stop professional hackers who I assume can steal anything they want. Look for SQLITE_FILE_HEADER in the code (it's in the btree.c file). By redefining it, only your

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
; To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a914

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
-------------- > > > -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9140103 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
to [EMAIL PROTECTED] > ----------------- > > > -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9140086 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 mxs wrote: > One of the > application I work on contains data which have very high value. [...] > I found a link talking about encryption, but this is not exactly affordable > for my type of project. >

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Ulrich Telle
Hi Marek, > I'll be honest with you I had to google around to find out what is > wxWidgets (obviously I've seen it before, but never dipped in). Pls > understand I've been messing around for years with VB (not even the > .NET version) and it served me quite well. But I decided to move on > to

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Florian Weimer
* mxs: > If anybody knows hot to ensure that the data is not readable without the > front end I would appreciate it. You need to turn your application into some kind of web-based service which is actively monitored for misuse. Anybody who's got a copy of the application can reverse-engineer

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Rich Shepard
On Sat, 24 Feb 2007, Martin Jenkins wrote: mxs wrote: I decided I'd like to try Python and SQLite Check out wxPython too. Python->wxPython->pysqlite2->sqlite3 Works for me. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services,

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
e, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9136419 Sent from the SQLite mailing list archive at Nabble.com. -

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Martin Jenkins
mxs wrote: I had to google around to find out what is wxWidgets ... I decided I'd like to try Python and SQLite Check out wxPython too. Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
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 > Sub

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
though) ahead of me and your solution sounds very much ready and usable as soon as I am confident of my steps in Python etc. Thanks for your tip. Regards Marek -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484.html#a9136243 Sent from the SQLite

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread mxs
Hi John, thanks for the suggestion, but that is rather more than I can swallow right now. I will have to keep looking for more complete solution which I can just benefit from. Regards Marek -- View this message in context: http://www.nabble.com/SQLite---how-to-protect-the-data-tf3282484

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread John Stanton
You could use encryption like DES etc in your application. Since sqlite is open source you could build encryption into the DB. Since an Sqlite database is one file you can encrypt that file in the file system. If those are too difficult, make a deal with Dr Hipp for his encrypted Sqlite.

Re: [sqlite] SQLite - how to protect the data

2007-02-24 Thread Adriano
I'm in the same boat too. I've just found http://www.sqlcrypt.com/ not tryed yet i need something that can works either on pc or on windoes mobile devices thanks Adriano - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] SQLite - how to protect the data

2007-02-23 Thread Olaf Beckman Lapré
(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 - h

[sqlite] SQLite - how to protect the data

2007-02-23 Thread mxs
://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] -