SQLite3 Multiple Ciphers 2.5.0 (based on SQLite 3.53.4)

Changes since previous release

• Based on SQLite version 3.53.4
• Adjusted visibility of internal functions and global data
  Many functions and global data of the AEGIS and Ascon crypto algorithms were visible to the linker possibly causing name clashes. They have been made consequently static.
• Added 2 compile time symbols, SQLITE3MC_USE_DISPATCH_TABLE and SQLITE3MC_API_TABLE_PREFIX
  • Symbol SQLITE3MC_USE_DISPATCH_TABLE allows to effectively hide all SQLite API functions' symbols from the linker by establishing dispatch tables for calling the SQLite API functions. This avoids linker and runtime conflicts, if an application can't avoid to load multiple SQLite instances. In general, applications should avoid to load multiple instances of SQLite, because that can easily lead to database file corruption, if multiple SQLite instances access the same database file(s). However, if each SQLite instance only accesses a set of database files disjunct to each other, it is usually safe to have multiple SQLite instances in the same process.
  • Symbol SQLITE3MC_API_TABLE_PREFIX allows to adjust the external names of the dispatch tables, so that even 2 instances of SQLite3MC could operate in parallel, as long as they don't access the same database file(s). If the symbol is not defined, the default prefix sqlite3mc will be used.

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

Verification

Release artifacts were built by GitHub Actions and are published with GitHub Artifact Attestations for provenance verification.

The SHA256SUMS file containing the checksums of the release artifacts is additionally signed using Sigstore Cosign.

To verify the integrity and authenticity of the checksum file, install Cosign and run:

cosign verify-blob \
  --certificate sqlite3mc-2.5.0-SHA256SUMS.pem \
  --signature sqlite3mc-2.5.0-SHA256SUMS.sig \
  --certificate-identity-regexp '^https://github.com/utelle/SQLite3MultipleCiphers/.*' \
  --certificate-oidc-issuer https://token.actions.githubusercontent.com \
  sqlite3mc-2.5.0-SHA256SUMS

SQLite3 Multiple Ciphers 2.4.0 (based on SQLite 3.53.4)

Changes since previous release

• Based on SQLite version 3.53.4
• Regenerated build files (with some additional options enabled)
• Modified rekey operation to support rekeying in WAL mode
  Up to now the rekey operation generated a new key salt, but in WAL mode that would have led to corrupted databases, and was therefore not supported. Rekeying in WAL mode is now supported at the price of keeping the previous key salt. However, this is usually only a minor security degradation.
• Added extension for value-level encryption (VLE)
  SQL functions sqlite3mc_vle_key, sqlite3mc_vle_encrypt, and sqlite3mc_vle_decrypt were implemented to allow to set up an encryption key for encrypting resp decrypting individual column values.

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

Verification

Release artifacts were built by GitHub Actions and are published with GitHub Artifact Attestations for provenance verification.

The SHA256SUMS file containing the checksums of the release artifacts is additionally signed using Sigstore Cosign.

To verify the integrity and authenticity of the checksum file, install Cosign and run:

cosign verify-blob \
  --certificate sqlite3mc-2.4.0-SHA256SUMS.pem \
  --signature sqlite3mc-2.4.0-SHA256SUMS.sig \
  --certificate-identity-regexp '^https://github.com/utelle/SQLite3MultipleCiphers/.*' \
  --certificate-oidc-issuer https://token.actions.githubusercontent.com \
  sqlite3mc-2.4.0-SHA256SUMS

SQLite3 Multiple Ciphers 2.3.6 (based on SQLite 3.53.3)

Changes since previous release

• Based on SQLite version 3.53.3

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

Verification

Release artifacts were built by GitHub Actions and are published with GitHub Artifact Attestations for provenance verification.

The SHA256SUMS file containing the checksums of the release artifacts is additionally signed using Sigstore Cosign.

To verify the integrity and authenticity of the checksum file, install Cosign and run:

cosign verify-blob \
  --certificate sqlite3mc-2.3.6-SHA256SUMS.pem \
  --signature sqlite3mc-2.3.6-SHA256SUMS.sig \
  --certificate-identity-regexp '^https://github.com/utelle/SQLite3MultipleCiphers/.*' \
  --certificate-oidc-issuer https://token.actions.githubusercontent.com \
  sqlite3mc-2.3.6-SHA256SUMS

SQLite3 Multiple Ciphers 2.3.5 (based on SQLite 3.53.2)

Changes since previous release

• Based on SQLite version 3.53.2

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

Verification

Release artifacts were built by GitHub Actions and are published with GitHub Artifact Attestations for provenance verification.

SQLite3 Multiple Ciphers 2.3.4 (based on SQLite 3.53.1)

Changes since previous release

• Based on SQLite version 3.53.1
• Fixed issue #232 - Zero out one-time-keys (for cipher schemes chacha20, aegis, and ascon128) after encrypt/decrypt operation
• Resolved issue #233 - Add support for specifying plaintext header size in non-legacy mode of the SQLCipher cipher scheme. This option was supported only for legacy mode version 4 (legacy=4), but there is no reason to not support it for non-legacy mode.

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

SQLite3 Multiple Ciphers 2.3.3 (based on SQLite 3.53.0)

Changes since previous release

• Based on SQLite version 3.53.0
• Fixed issue #230: Cipher data structures are not nullified securely on freeing

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

SQLite3 Multiple Ciphers 2.3.2 (based on SQLite 3.51.3)

Changes since previous release

• Based on SQLite version 3.51.3
• Fixed issue #227: Compile AEGIS with clang version 22 and above
• Fixed issue #228: Function sqlite3mc_cipher_name not thread-safe
• Fixed issue #229: Symbol conflicts when static linking to both sqlite3mc and libsodium

Caution

For applications using SQLite in a multi-threaded environment an upgrade is highly recommended, because issue #228 could lead to runtime errors.

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

SQLite3 Multiple Ciphers 2.3.1 (based on SQLite 3.51.3)

Changes since previous release

• Based on SQLite version 3.51.3

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

SQLite3 Multiple Ciphers 2.3.0 (based on SQLite 3.52.0)

Changes since previous release

• Based on SQLite version 3.52.0
• Added build support for VS2026
• Unified architecture names in build files (use x64 instead of Win64) (to avoid VS2026 conflicts)
• Add support for issue #222
• Fixed issue #226

Caution

March 13, 2026
SQLite version 3.52.0 has been withdrawn because some of the new features found in 3.52.0 are not 100% compatible with prior releases. Those new features and their associated APIs need to be reworked before 3.52 is made available.

Version 3.52.0 works fine and is fully backwards compatible as long as the database does not contain indexes on expressions or indexes on VIRTUAL computed columns where the expression evaluates to a floating-point number that is derived from text or JSONB inputs. If indexes of that type are present, then version 3.52.0 might not interoperate correct with prior releases, in rare cases.

Therefore it is recommended to use a prior release of SQLite3 Multiple Ciphers until version SQLite 3.52 has been reworked.
Alternatively, the release SQLite3 Multiple Ciphers 2.3.1 based on the SQLite patch release 3.51.3 is available.

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).

SQLite3 Multiple Ciphers 2.2.7 (based on SQLite 3.51.2)

Changes since previous release

• Based on SQLite version 3.51.2

Important

📌 The amalgamation source package including configure is still experimental. 📌
Currently, only POSIX compliant systems are supported. Support files for building on Windows are included, but will only be adapted if the need arises.
Please report any issue you may experience using the GitHub issue tracker.
❗ Please share your experiences with this source package. TIA. ❗

Notes
This release contains the following precompiled binaries:

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows. The SQLite3 shell applications support the SQLite Archive feature,
• Source code amalgamation (amalgamation) - a single C source file and a single C header file,
• Source code amalgamation (autoconf) - a single C source file and a single C header file - including a configure script for POSIX compliant systems,
• Precompiled SQLite Android library (see SQLite Android Bindings),
• Precompiled bundle of sqlite3.wasm and its JavaScript APIs, ready for use in web applications (see SQLite3 WebAssembly).