QSQLCIPHER

SQLCipher/sqlite plugin for Qt6 projects. Based on original CMakeLists.txt`s from Qt 6.7.2 srcs (from sqldrivers and sqlite3 folders) with minimal changes/additions. Checked on Visual Studio 2022 projects. Project uses OpenSSL x64 static libraries built for Visual Studio. If you need another libraries you should change CMakeLists.txt

Prerequisites

1. SQLCipher/sqlite amalgamation
2. OpenSSL binaries (//TODO)

Building debug and release plugins

1. Open the Visual Studio Command Prompt (Tools -> Command Line -> Developer Command Prompt)
2. cd to Projects folder
3. Clone this project

> git clone git@github.com:9241304/qsqlcipher.git

5. cd to project folder and create .build folder and cd to it

> cd qsqlcipher
> mkdir .build
> cd .build

6. Configure the project (use your paths and keywords instead of example). Make sure all paths use '/' slash

> cmake .. -G "Visual Studio 17 2022" -A x64 -DCMAKE_INSTALL_PREFIX=../.install -DCMAKE_DEBUG_POSTFIX=d -DQt6_DIR=c:/Qt/6.7.2/msvc2019_64/lib/cmake/Qt6 -DSQLITE3_SRC_AM_DIR=d:/proj/sqlcipher/.am -DOPENSSL_INSTALL_DIR=c:/SDK/openssl/1.1.1m/OpenSSL-Win64

7. Build and install

> cmake --build . --config Debug
> cmake --build . --config RelWithDebInfo
> cmake --install . --config Debug
> cmake --install . --config RelWithDebInfo

Usage

In .install folder you will find release and debug version of plugin. Just copy these files to sqldrivers folder of Qt6 installation and/or your project. So, now you can use your plugin

  auto db{QSqlDatabase::addDatabase("QSQLCIPHER")};
  db.setDatabaseName("encrypted.db");
	
  if (!db.open())
    return {};

  QSqlQuery query(db);

  //Use the safer way to enter password 
  query.exec("PRAGMA key = 'yourpassword';");
  
  ...