sqlcipher的一些问题

1、sqlcipher的常用命令

参考链接：SQLCipher文档（未完待续）_太阳别落下啊的博客-优快云博客_sqlcipher

2、sqlcipher3.x 升级至4.x

PRAGMA key = 'VI5PuP0m374Sd4J9';
PRAGMA cipher_page_size = 1024;
PRAGMA kdf_iter = 64000;
PRAGMA cipher_hmac_algorithm = HMAC_SHA1;
PRAGMA cipher_kdf_algorithm = PBKDF2_HMAC_SHA1;
ATTACH DATABASE 'sqlcipher-4.db' AS sqlcipher4 KEY 'VI5PuP0m374Sd4J9';
SELECT sqlcipher_export('sqlcipher4');
DETACH DATABASE sqlcipher4;
select * from encrypt_file_table;

参考链接：SQLCipher API - Zetetic

3、sqlcipher编译

./configure --enable-tempstore=yes --enable-fts5 CFLAGS="-DSQLITE_HAS_CODEC" LDFLAGS="/build/opt/local/lib/libcrypto.a" --prefix=/build/opt/local/

make

make install