2016年6月12日 星期日

[SQLITE] sqlite3 encryption/decryption

SQLite3 Simple works

sqlite3 commands.
http://www.runoob.com/sqlite/sqlite-syntax.html

SQLite Manager on Firefox. (Of course, it's free.)
https://addons.mozilla.org/zh-tw/firefox/addon/sqlite-manager/
https://dotblogs.com.tw/toysboy21/2014/04/21/144813

Android SQLite Database Tutorial.
http://www.tutorialspoint.com/android/android_sqlite_database.htm

SQLite for iOS.
http://pro.ctlok.com/2010/07/iphone-ipad-with-sqlite.html
https://www.facebook.com/teacherchi/posts/359338594127416

SQLite for Android.
https://github.com/sqlcipher/android-database-sqlcipher

CopyFiles.
http://www.iforce2d.net/cc2dxres/fileutils

SQLite Manager
http://www.sqlabs.com/sqlitemanager.php

SQLite3 Encryption/Decryption

Types of sqlite3 encryption/decryption

sqlcipher_export() to make plain text database to be encrypted.
https://www.zetetic.net/sqlcipher/sqlcipher-api/#sqlcipher_export

SQL Cipher is free but need some works.
Here is SQL Cipher official web site:

sqlcipher gits:

Make Sqlcipher available on iOS and Android.
To Make Sqlcipher available on iOS.

To Make Sqlcipher available on Android.

Reference web sites:
My Solution:
1. Use SQLiteManager to encrypt the database.


2. To decrypt the database in code.

沒有留言:

張貼留言