It would have been great if you could support SQLCipher encrypted DB.
This keeps many away from using the SQLite DB freely like other databases.
Support for DB with SQLCipher encryption
-
- User
- Posts: 86
- Location: Almaty, Kazakhstan
-
- User
- Posts: 86
- Location: Almaty, Kazakhstan
need to pass PRAGMA key before connect. Then need to connect.
PRAGMA key = 'passphrase';
PRAGMA key = 'passphrase';
-
- User
- Posts: 9445
Problem is, you need a PHP extension that supports SQLCipher. What PHP extension do you use? Did you mean you can use pdo_sqlite (https://www.php.net/manual/en/ref.pdo-sqlite.php) to connect to SQLCipher encrypted database by executing PRAGMA key = 'passphrase'? Can you post your PHP code?