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.
I wonder how you connect to SQLCipher with PHP? php_pdo_sqlcipher?
need to pass PRAGMA key before connect. Then need to connect.
PRAGMA key = ‘passphrase’;
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?
pdo_sqlite does not support SQLCipher. However, from v2021, PHPMaker supports encrypted connection with MySQL/PostgreSQL.