How to use wxsqlite3 secure in linux?

Question

I used wxsqlite3 (version 3.11.1) to encrypt SQLite database on Windows OS. I simply included sqlite3.h and sqlite3.lib into my projects, and used sqlite3_key to encrypt my database. It works fine, but now I want to use wxsqlite3 on Linux (Centos 7).

I spent many days trying to compile but failed. How I can use the same methods as on Windows on Linux? Could anyone who has experience, share their knowledge and practice on how to compile SQLite and wxSqlite3 in order to be able to access encryption functions.

Answer 1

1. There never existed a version 3.11.1 of wxSQLite3. However, there was a release of SQLite 3.11.1 in March 2016. Current version of SQLite is version 3.23.1.
2. wxSQLite3 is mainly a thin wrapper for the SQLite library for wxWidgets based applications. Are you developing a wxWidgets application? Or are/were you just using the SQLite library with encryption extension that is included in wxSQLite3?
3. Starting with wxSQLite3 version 3.5.0 the included build system was overhauled, making it easier to build wxSQLite3 under Windows and Linux. Up to version wxSQLite3 3.5.9 pre-generated build files were included for the wxWidgets wrapper library only, but a premake5 script for generating build files was included. Since version wxSQLite3 4.0.0 pre-generated build files are also included for the SQLite library with encryption extension.

So, my advice would be to download a recent version of wxSQLite3 and try the included build files for Linux (and other Linux-like systems).