How to connect Base document to encrypted Sqlite3 database

[socius]

Hello,

I managed to connect a Base front end document to Sqlite3 database file thanks to this tread:

Base: how to connect to an SQLite database?

Config: LO 5.3.7.2, Linux 4.13, Fedora 26 (I have another “experimental” config under Fedora 27, but problem is the same) This is a duplicate/refresh of this old question because its answer is not satisfactory or outdated. I searched through this site and googled without finding the appropriate fix. I want to generate summary report from an existing active SQLite DB. In order to connect to the database, I installed packages unixODBC and sqliteODBC, but when configuring access to said base wit…

and some other sources.

I found a working SQLite3 prebuilt binaries with encryption.

GitHub - darkman66/SQLite3-Encryption: SQLite3 with enabled encryption

Prebuilt binaries

https://github.com/rindeal/SQLite3-Encryption/releases/download/v3.9.2/bin.zip

To open an encrypted SQLite3 database is easy.

sqlite3 db1
sqlite> PRAGMA key='passphrase';

Would it be possible to implement this solution when connecting Base front end document to encrypted SQLite3 database by using ODBC driver?