in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Platform independency of encryped databases

Last post 09-08-2010 12:45 PM by Robert Simpson. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 09-03-2010 8:20 AM

    Platform independency of encryped databases

     Dear developers,

    I would like to ask about platform independency of the encryption concept. There is a note on the front page which states that encrypted databases can be accesed only on Windows platforms. I'd like to know that for example assuming that I'm on Windows platform, can I access the enrypted SQLite file from native c++, Java, or from any other platform? In other words how much is this encryption depending on .NET Framework?

     I've read about SEE (SQLite Encryption Extension), and it seems to be completely platform independent. Is the provided encryption wrapping some known tool for SQLite, or has it its own algorythm depending on .NET Framework?

     I hope I was clear enough, any clarification would be appreciated. Thank you in advance, regards:

    Zoltan Tamasi

    Filed under:
  • 09-06-2010 1:39 AM In reply to

    Re: Platform independency of encryped databases

     Hello,

     actually I've found some infrmation about the enryption algorythm in another forum topic, when Robert staed that it uses Microsoft Crypto API and RC4. I tried to use RC4 and my key to decrypt the file in another application, but I couldn't reach the goal. So it seems like it has some .NET specific addon maybe?

    So my question is getting simpler: Is it possible to use encrypted databases outside of .NET environment? If yes, then it is needed to know how exactly this RC4 encrypting works.

    I'm looking forward to a reply from the author please. Best wishes,

    Zoltan

    Filed under:
  • 09-08-2010 12:23 PM In reply to

    Re: Platform independency of encryped databases

    Hello Zoltan, I tested about 2 weeks before I gave up to access the SQLite.NET databases from a non-windows environment. It all ends at the function CryptDeriveKey that scrambles the RC4-key in a way, I could not reproduce. I'm using SEE now and it works. TeDe
  • 09-08-2010 12:45 PM In reply to

    Re: Platform independency of encryped databases

    The dependency on Windows was deliberate.  The SQLite project is partially funded by folks purchasing the SEE encryption module, and I do not want to intrude on that revenue stream for them by offering a cross-platform encryption module for free.

     

Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems