* * *

Author Topic: SQLite3 + encryption for WinCE (arm4i)  (Read 19639 times)

vincococka

  • Jr. Member
  • **
  • Posts: 94
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #30 on: March 02, 2015, 11:20:56 am »
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
---
  Guide me God and I`ll find you

vincococka

  • Jr. Member
  • **
  • Posts: 94
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #31 on: November 26, 2015, 08:20:45 am »
Update to version 3.9.2.
See first post for download links.

Enjoy :-)
---
  Guide me God and I`ll find you

bambamns

  • Full Member
  • ***
  • Posts: 216
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #32 on: February 20, 2016, 05:10:50 am »
Hi,

All links are dead - can you mak them alive ?

Thx
Lazarus 1.2.6 + FPC 2.6.4 x86 (rebuild), Windows 7 x64, unless otherwise specified

vincococka

  • Jr. Member
  • **
  • Posts: 94
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #33 on: March 09, 2016, 12:15:33 am »
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/
« Last Edit: March 09, 2016, 12:19:14 am by vincococka »
---
  Guide me God and I`ll find you

ertank

  • Full Member
  • ***
  • Posts: 201
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #34 on: April 12, 2016, 10:34:47 pm »
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

  • Jr. Member
  • **
  • Posts: 94
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #35 on: April 28, 2016, 12:15:39 am »
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 :).
---
  Guide me God and I`ll find you

ertank

  • Full Member
  • ***
  • Posts: 201
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #36 on: May 06, 2016, 09:55:18 am »
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

  • Jr. Member
  • **
  • Posts: 94
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #37 on: May 10, 2016, 09:46:33 pm »
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.
---
  Guide me God and I`ll find you

ertank

  • Full Member
  • ***
  • Posts: 201
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #38 on: May 18, 2016, 06:10:14 pm »
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

  • Full Member
  • ***
  • Posts: 216
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #39 on: December 16, 2017, 08:35:34 pm »
Hi,

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

Thx
Lazarus 1.2.6 + FPC 2.6.4 x86 (rebuild), Windows 7 x64, unless otherwise specified

ertank

  • Full Member
  • ***
  • Posts: 201
Re: SQLite3 + encryption for WinCE (arm4i)
« Reply #40 on: December 19, 2017, 09:57:26 pm »
Trying to attach in a message here. Version 3.21.0.0

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus