Page 1 of 1

Encrypted DB - Page size

Posted: Wed 22 Aug 2012 13:54
by TomekC
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.

Re: Encrypted DB - Page size

Posted: Thu 23 Aug 2012 11:19
by ZEuS
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.

Re: Encrypted DB - Page size

Posted: Thu 23 Aug 2012 11:36
by TomekC
Thank you.
Could you give me any estimation on when the next LiteDAC build might be released?

Re: Encrypted DB - Page size

Posted: Wed 05 Sep 2012 08:11
by ZEuS
We plan to release a new version of LiteDAC in a few days.

Re: Encrypted DB - Page size

Posted: Wed 05 Sep 2012 08:14
by TomekC
Great news.

Re: Encrypted DB - Page size

Posted: Mon 15 Jul 2013 01:26
by FerCastro
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?

Re: Encrypted DB - Page size

Posted: Mon 15 Jul 2013 07:01
by AlexP
Hello,

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