SQLite3 + encryption for WinCE (arm4i)

[vincococka]

Hi all,

in first post you can find link to DLL of SQLite 3.8.7.4 compiled with AES/128 encryption.
Library was built from wxSqlite3 3.2.0 codebase (thanks Ullrich - KUDOZ !).
Tested on emulator and 2 real devices ;-).

I hope that you`ll find it usefull.

Regards, 
  Jan

[vincococka]

Update to version 3.9.2.
See first post for download links.

Enjoy :-)

[bambamns]

Hi,

All links are dead - can you mak them alive ?

Thx

[vincococka]

In case somebody is interested, I`ve recompiled SQLite 3.11.1 with wxSqlite AES 128bit encryption enabled + set THREADSAFE=1. Thanks Ulrich for your great work!

SQLite3ce: http://itm8.sk/sqlite3ce/

[ertank]

I am sorry if it is already posted.

Is there any sqlite3 dll that is supposed to be faster than others (all compiler optimizations at max & all necessary parameters ON of sqlite)

I am not an sqlite guy, I do not know correct parameters. I am lacking information as to how to compile it for WinCE platform, too. Or else I would gladly do it.

Thanks.

[vincococka]

Hi ,

sorry for replying so late but I was pretty busy.

I think that there is not any king of magic bullet available for this kind of requirement.
SQLite has lot of compile-time IFDEFs, also Visual C++ compiler offers some nice optimizations (but your library will grow in binary size).
Most of the time engine will spent processing data so you have to think of more about how to properly squeeze maximum performance from engine via queries and think about every one you type. Even best compilers in the world won`t solve developer lazyness.

One example from life: there was a report (data are in Oracle DB 11.2) that was running for 11-12 hours till it finishes. After some SQL queries tuning it`s now finished 3 minutes .

[ertank]

Is there any simple 3.11.1 sqlite dll for wince? Or, this AES128 encryption can open regular sqlite3 databases? Database which created using regular sqlite3. I constantly get "database malformed" or "file is encrypted or is not a database" error messages when I switched using 3.11.1 with aes128 and thread safe version.

[vincococka]

This 3.11.1 version that I`ve compiled is fully able to operate on encrypted/non-encrypted files.
Please see first post - I`ve written there some hints how to work with encryption.

V.

[ertank]

Hi,

Is it possible that we get a new version of DLL compiled for wince, please? If possible a simple DLL with no encryption and another one with encryption is appreciated.

There is some kind of a bug in 3.11.1 DLL version.

1) When I use a code like below:

Code: [Select]

Transaction.Action := caCommit;
Transaction.Options := [stoUseImplicit];

Transaction.StartTransaction;
[... do some insert/delete/update ...]
Transaction.Commit;

I cannot see changes until a database close/open, or application complete close and start again. On the other hand, same application runs without any problem with version 3.9.2 DLL.

2) I have a database with 4 million records inside. Database size is about 1.3GB. There is no problem opening and using it with 3.9.2 DLL, and 3.11.1 simply says database corrupt, or bad or something like that and cannot even open that database.

Thanks.

[bambamns]

Hi,

Link on first post is dead - can you make it alive ?

Thx

[ertank]

Trying to attach in a message here. Version 3.21.0.0

[ertank]

Here is a DLL of sqlite3 version 3.28 compiled for WinCE ARMv4