SQLite3 Multiple Ciphers 1.3.8 (based on SQLite 3.38.0)

Changes since previous release

• Based on SQLite version 3.38.0
• Updated build files (JSON extension is now integral part of SQLite)
• Eliminated compile time warning (issue #66)

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

SQLite3 Multiple Ciphers 1.3.7 (based on SQLite 3.37.2)

Changes since previous release

• Based on SQLite version 3.37.2

Notes

• Update is recommended due to important bug fixes in the underlying SQLite library, for details see this SQLite forum post.

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.

• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

• For the first time, Android binaries are provided. They were built according to the information given on the SQLite Android Bindings website; all information given there applies - especially the remarks regarding encryption. Whether Android binaries will be included in future releases, will depend on the feedback (or the lack thereof).

Attention [January 9, 2022]

The list of header files to be installed in the file Makefile.am includes the header file sqlite3.h accidentally twice. To avoid error messages on performing make install remove one entry. AFAICT the header files are installed correctly nevertheless. However, the problem has been fixed in the repository already.

SQLite3 Multiple Ciphers 1.3.6 (based on SQLite 3.37.1)

Changes since previous release

• Based on SQLite version 3.37.1

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

SQLite3 Multiple Ciphers 1.3.5 (based on SQLite 3.37.0)

Changes since previous release

• Based on SQLite version 3.37.0
• Added build support for Visual C++ 2022
• Fix issue #55: Set pager error state on reporting decrypt error condition to avoid assertion when SQLITE_DEBUG is defined
• Fix issue #54: Check definition of symbol __QNX__ to support compilation for QNX
• Apply minor adjustments to ChaCha20 implementation (taken from upstream resilar/sqleet)
• Fix issue #50 and #51: Numeric cipher ids are now handled correctly, if some of the cipher schemes are excluded from compilation
• The SQLite3 Multiple Ciphers version information is now exposed in the amalgamation header
• The compile-time configuration options have been moved to a separate header file

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

SQLite3 Multiple Ciphers 1.3.4 (based on SQLite 3.36.0)

Changes since previous release

• Allow empty passphrase for PRAGMA key
• Allow to fully disable including of user authentication by defining SQLITE_USER_AUTHENTICATION=0

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

SQLite3 Multiple Ciphers 1.3.3 (based on SQLite 3.36.0)

Changes since previous release

• Update to SQLite 3.36.0
• Adjust build files

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

Release Update [July 5, 2021]

The binaries sqlite3mc-1.3.3-sqlite-3.36.0-win64.zip contained a wrong shell executable version (issue #41). This has been fixed.

SQLite3 Multiple Ciphers 1.3.2 (based on SQLite 3.35.5)

Changes since previous release

• Added configuration parameter mc_legacy_wal (issue #40)
• Fix issue #39: Corrupted WAL journal due to referencing the wrong codec

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

⚠️ Important Information when operating SQLite in WAL journal mode ⚠️

To allow concurrent use of SQLite databases in WAL journal mode with legacy encryption implementations like System.Data.SQLite or SQLCipher a new WAL journal encryption implementation was introduced in SQLite Multiple Ciphers version 1.3.0.

Unfortunately, WAL journals left behind by versions <= 1.2.5 are not compatible with this new implementation. To be able to access WAL journals created by prior versions, the configuration parameter mc_legacy_wal was introduced. If the parameter is set to 1, then the prior WAL journal encryption mode is used. The default of this parameter can be set at compile time by setting the symbol SQLITE3MC_LEGACY_WAL accordingly, but the actual value can also be set at runtime using the pragma or the URI parameter mc_legacy_wal.

In principle, operating generally in WAL legacy mode is possible, but it is strongly recommended to use the WAL legacy mode only to recover WAL journals left behind by prior versions without data loss.

SQLite3 Multiple Ciphers 1.3.1 (based on SQLite 3.35.5)

Changes since previous release

• Prevent rekeying a database in WAL journal mode, because performing a rekeying operation (PRAGMA rekey) in WAL journal mode could cause database corruption
• Fix issue in the user authentication extension that caused VACUUMing or rekeying to fail
• Add some error messages (key, rekey, pragma handling)

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

🛑 Attention [May 6, 2021] 🛑
As described in issue #39 using SQLite in WAL journal mode is currently broken in SQLite3 Multiple Ciphers version 1.3.0 and 1.3.1. A fix was applied in commit 43bd436, but a new release has not yet been made, but is planned for the near future.

SQLite3 Multiple Ciphers 1.3.0 (based on SQLite 3.35.5)

Changes since previous release

• Fix issue #37: Allow concurrent access from legacy applications by establishing WAL journal mode compatibility.
  This change allows concurrent use of applications still using SQLite versions (< 3.32.0) based on the SQLITE_HAS_CODEC encryption API and applications using the new SQLite3 Multiple Ciphers implementation in WAL journal mode.
• Fix issue #36: Clear pager cache after setting a new passphrase to force a reread of the database header
• Adjust build files for MinGW. The compile option was changed from -march=native to -msse4.2 -maes.
  Additionally, the MinGW variant TDM-GCC is now supported by replacing the use of RtlGenRandom (aka SystemFunction036) with the use of the standard function rand_s (which internally calls RtlGenRandom). The direct call to RtlGenRandom can be activated by defining the compile time symbol SQLITE3MC_USE_RAND_S=0.

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

🛑 Attention [May 6, 2021] 🛑
As described in issue #39 using SQLite in WAL journal mode is currently broken in SQLite3 Multiple Ciphers version 1.3.0 and 1.3.1. A fix was applied in commit 43bd436, but a new release has not yet been made, but is planned for the near future.

SQLite3 Multiple Ciphers 1.2.5 (based on SQLite 3.35.5)

Changes since previous release

• Update to SQLite 3.35.5

Notes

• SQLite3 binaries for Windows (SQLite3 shell and DLLs) can be found as separate downloads with resp. without enabled ICU support in variants for 32-bit and 64-bit Windows.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.