SQLite3 encrypted version

sqlite3 Encrypted version 

1.lib、dll  stay github Download address on 
https://github.com/rindeal/SQLite3-Encryption

2. Description of encryption interface 

//  Decryption or for the first encryption 
int sqlite3_key(sqlite3 *db, const void *zKey, int nKey);
//  Reset password 
int sqlite3_rekey(sqlite3 *db, const void *zKey, int nKey);

sqlite3_key Yes, enter the key , If the database is encrypted, you must execute this function and enter the correct key before you can operate ; If the database is not encrypted , After executing this function, the database operation will appear “ This database is encrypted or not a database file （file is encrypted or is not a database）” Error of .
int sqlite3_key( sqlite3 *db, const void *pKey, int nKey),
db  Is the specified database ,pKey  It's the key ,nKey  It's the key length .

sqlite3_rekey Is to change the key or add the key to the database without encryption or empty the key , Before changing the key or emptying the key, it must be executed correctly  sqlite3_key. In the correct implementation  sqlite3_rekey  After the  sqlite3_close  Before closing the database, you can operate the database normally , No more execution  sqlite3_key.
int sqlite3_rekey( sqlite3 *db, const void *pKey, int nKey), The parameters are the same as above .


// Detailed instructions 
1. Add database password ： If you want to add a password , After creating the database file , Call... Any time before closing the database file sqlite3_key Function 
2. Read database data ： After opening the data file , call sqlite3_key function , that will do （ If the database is not encrypted , After executing this function, the database operation will appear “ This database is encrypted or not a database file ” Error of ; After testing , The password can only be set when creating a new database ！）
3. Change database password ：  First, you need to use the current password to open the database correctly , Then you can call sqlite3_rekey(db,"112233",6)  To change the database password .
4. Delete database password ： First, you need to use the current password to open the database correctly , Then you can call sqlite3_rekey(db,"112233",6)  To delete the database password .

 Reference resources ：
1.https://blog.csdn.net/Best_ZYJ/article/details/102483847
2.https://blog.csdn.net/weixin_33770878/article/details/94542946?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-0.pc_relevant_paycolumn_v3&spm=1001.2101.3001.4242.1&utm_relevant_index=3