Support for DB with SQLCipher encryption

innovativeshadow · Post by **innovativeshadow** » Thu Jul 30, 2020 3:25 am

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.

arbei · Post by **arbei** » Mon Aug 03, 2020 6:42 pm

I wonder how you connect to SQLCipher with PHP? php_pdo_sqlcipher?

innovativeshadow · Post by **innovativeshadow** » Mon Aug 03, 2020 9:51 pm

need to pass PRAGMA key before connect. Then need to connect.

PRAGMA key = 'passphrase';

arbei · Post by **arbei** » Tue Aug 04, 2020 9:31 am

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?

Post by **Webmaster** » Tue Sep 08, 2020 9:20 am

pdo_sqlite does not support SQLCipher. However, from v2021, PHPMaker supports encrypted connection with MySQL/PostgreSQL.