Encrypted DB - Page size

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
TomekC
Posts: 8
Joined: Mon 20 Aug 2012 11:36
Location: Poland

Encrypted DB - Page size

Post by TomekC » Wed 22 Aug 2012 13:54

Hi.
I am creating encrypted database with Page Size different then default 1024 .
Two problems happen:
1 Sometimes when viewing database file, I can still see some unencrypted data in it (data that was in column of type TEXT)
2 Sometimes I get an error: "database disk image is malformed" when creating indexes

I tried different encryption algorithms (BlowFish, AES128, AES256, RC4) and page sizes (2048, 4096, 8192).
I am setting Page Size (with "PRAGMA page_size = 4096") on an empty database and then creating tables, adding data and creating indexes.
I am using LiteDac trial.

ZEuS
Devart Team
Posts: 240
Joined: Thu 05 Apr 2012 07:32

Re: Encrypted DB - Page size

Post by ZEuS » Thu 23 Aug 2012 11:19

Thank you for the information.
We have fixed the errors you have listed, and the fix will be included in the nearest LiteDAC build.
Unfortunatelly, this is more complex fix than the previous one ( http://forums.devart.com/viewtopic.php?f=48&t=24727 ). Therefore, now we can not send you a fixed dcu.

TomekC
Posts: 8
Joined: Mon 20 Aug 2012 11:36
Location: Poland

Re: Encrypted DB - Page size

Post by TomekC » Thu 23 Aug 2012 11:36

Thank you.
Could you give me any estimation on when the next LiteDAC build might be released?

ZEuS
Devart Team
Posts: 240
Joined: Thu 05 Apr 2012 07:32

Re: Encrypted DB - Page size

Post by ZEuS » Wed 05 Sep 2012 08:11

We plan to release a new version of LiteDAC in a few days.

TomekC
Posts: 8
Joined: Mon 20 Aug 2012 11:36
Location: Poland

Re: Encrypted DB - Page size

Post by TomekC » Wed 05 Sep 2012 08:14

Great news.

FerCastro
Posts: 47
Joined: Mon 26 Jun 2006 17:32
Location: México City
Contact:

Re: Encrypted DB - Page size

Post by FerCastro » Mon 15 Jul 2013 01:26

Hello Tomeck

I am trying to make an evaluation of the Lite Dac and of course, the main featur and advange I can see is the encryption.

Have you done something or, do you have any idea about encrypt or work with an encrypted database?

I have been trying to do somenthing but in the main demo I can not find anything related with encryption.

Thanks a lot in advance and best regards.

FerCastro

-- Add

What are the libraries (DLL) I do have to add to my application, in order to work with encrypted databases?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Encrypted DB - Page size

Post by AlexP » Mon 15 Jul 2013 07:01

Hello,

The detailed description of work with Encrypted DB can be found in the "Database File Encryption" article of the LiteDAC help

Post Reply