SQLite - creating encrypted databases. How...?

Question

How to create an encrypted SQLite database that actually remains encrypted or that I can open later.

I used SQLite2009 Pro Enterprise Manager, which "can" create encrypted databases, but after entering the encryption key, they can no longer open.

I used SQLiteManager from SQLabs to create an encrypted database, and although you can open it later, you can do this with any SQLite tool or control code without requiring a key.

So how can you create an encrypted SQLite database?

I plan to use the database in an Adobe Flex application.

Thank.

Answer 1

SQLite supports encryption integration, but the default open source SQLite distribution does not support encryption. Encrypted versions of SQLite will only migrate for different clients or tools if they all use the same encryption extension.

SQLite developers themselves are distributing a commercial version of SQLite that transparently supports encryption. When this module is used for encryption, encryption works on different platforms, and each byte written to the file is encrypted. There is nothing in the encrypted SQLite file stored on disk to indicate its SQLite database. Many tools support this implementation, allowing you to instead download the commercial sqlite.dll file instead of open source.

, . , System.Data.SQLite , .NET , System.Data.SQLite , System.Data.SQLite( , SQLite ).

Adobe AIR 1.5. , , . , AIR AIR. . : AIR:

http://probertson.com/articles/2008/11/18/air-1_5-encrypted-sqlite-database-how-to/

Answer 2

Re:

" , , , ?"

. SQLConnection.reencrypt(), :

http://help.adobe.com/en_US/FlashPlatform/reference/actionscript/3/flash/data/SQLConnection.html#reencrypt()

SQLConnection, . , , db:

https://github.com/probertson/air-sqlite/blob/DB-copy-dev/src/com/probertson/data/DBCopier.as

Answer 3

Take a look: http://elromdesign.com/blog/2009/04/16/adobe-air-sqlite-manager-api-for-adobe-air-15-with-password-encryption/

This can help.