加密/解密SQLite数据库并“在运行中”使用它-Encrypt/DecryptSQLite-databaseanduseit“onthefly”

13  

There is no built in support, that being said you do have options.

没有内置的支持，据说你确实有选择。

1) You can encrypt/decrypt all of your strings yourselves, but this is a lot of work, is not transparent, and won't allow you to do things like searching in the database.

1）您可以自己加密/解密所有字符串，但这是很多工作，不透明，不允许您在数据库中进行搜索等操作。

2) SQLiteCrypt and SQLCipher do what you're looking for.

2）SQLiteCrypt和SQLCipher做你想要的。

You can use them almost entirely transparent and typically they are said to have only about 5% overhead compared without encryption.

您可以使用它们几乎完全透明，并且通常认为与没有加密相比，它们仅有大约5％的开销。

4  

I would suggest using a library that does this for you, rather than building in your own encryption.

我建议使用一个为您执行此操作的库，而不是使用您自己的加密。

http://www.hwaci.com/sw/sqlite/see.html or http://sqlite-crypt.com/documentation.htm

http://www.hwaci.com/sw/sqlite/see.html或http://sqlite-crypt.com/documentation.htm

Use your favorite search engine for some alternatives.

使用您最喜欢的搜索引擎来寻找其他选择

2  

The best way I can think about is to use FUSE - "filesystems in user-land" - available for Linux , Mac OS X and other systems, or a different encrypted file-system. This will make SQLite see it as unencrypted while being physically encrypted on the disk. By playing with the permissions you can make sure people cannot access the unecrypted file system.

我能想到的最好的方法是使用FUSE - “用户界的文件系统” - 适用于Linux，Mac OS X和其他系统，或者不同的加密文件系统。这将使SQLite在磁盘上进行物理加密时将其视为未加密。通过使用权限，您可以确保人们无法访问未加密的文件系统。

I'm not sure if SQLite has a way to over-ride the low-level read/write routines which will allow you to implement the encryption on the fly without filesystem games. At least I never needed to do that. You may wish to search for such a feature request and file one it if it's not in the SQLite issue tracker.

我不确定SQLite是否有办法覆盖低级读/写例程，这将允许您在没有文件系统游戏的情况下实时加密。至少我从来不需要这样做。如果它不在SQLite问题跟踪器中，您可能希望搜索此类功能请求并将其归档。

1  

An additional option would be the SQLite encryption codec that comes with Botan 1.9.x (src/wrap/sqlite).

另一个选项是Botan 1.9.x（src / wrap / sqlite）附带的SQLite加密编解码器。

That option gives you the ability to customize the encryption type at compile time, including the cipher and mode.

该选项使您能够在编译时自定义加密类型，包括密码和模式。

Disclosure: I contributed the codec to Botan.

披露：我为Botan贡献了编解码器。