SQLite3 Multiple Ciphers 1.9.2 (based on SQLite 3.47.2)

Changes since previous release

• Based on SQLite version 3.47.2
• Fixed issue with page size change request for encrypted databases

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

1978b9ea2896e7617839e565d38b89764bcb192abc8262091421f3fcb5b0dde2 sqlite3mc-1.9.2-sqlite-3.47.2-icu-win32.zip
ea6089af394ffdbb9763d4ad5d830108af8cb4a1366a20737ada9fdee858c164 sqlite3mc-1.9.2-sqlite-3.47.2-icu-win64.zip
7417127ac26014d9b6adb9d2c5a0f7295e92f74eb166c1eeb2a903e2ada35b0b sqlite3mc-1.9.2-sqlite-3.47.2-win32.zip
9c39e879a4056e715eaec7d5d53842c338b51216295621041c5a7dec775f51f1 sqlite3mc-1.9.2-sqlite-3.47.2-win64.zip

be692e2f623fa14b99c30ac35f5933483a682f4e225aa8b4ef56c963f2a79d36 sqlite3mc-1.9.2-sqlite-3.47.2-amalgamation.zip

2289a2bc3422a79174422e281780d3f96fa9228eba9c4384bdb43dee6a9e2f40 sqlite3mc-1.9.2-sqlite-3.47.2-android.aar
bd6db7ddc04d043977e9ad4399be94d2793c09451edf77aed94b13026d007c0d sqlite3mc-1.9.2-sqlite-3.47.2-wasm.zip

SQLite3 Multiple Ciphers 1.9.1 (based on SQLite 3.47.1)

Changes since previous release

• Based on SQLite version 3.47.1
• Remove need to specify AES hw compile time options

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

ea101cffa200dbea249383ac71c808b7a3927c5b9cff5e7f5009339ea70133f1 sqlite3mc-1.9.1-sqlite-3.47.1-icu-win32.zip
80342a9aa8b96c7547ef6c2c36d57358d7ab711d3a5c5e36f9d2bd05c6ea0a1f sqlite3mc-1.9.1-sqlite-3.47.1-icu-win64.zip
27246ed794a3a89b0b56d1dfbc2c856ee047da589dfff14f44b35b725d934a30 sqlite3mc-1.9.1-sqlite-3.47.1-win32.zip
0b65c46c6c672248fcdd776d82d30544ea83237c27c8cbc3d877eadd440971ef sqlite3mc-1.9.1-sqlite-3.47.1-win64.zip

f5efa3f700f98bf2a3c48d4719b822d0d9f4102af5af3c243ab7c0b6215c4a46 sqlite3mc-1.9.1-sqlite-3.47.1-amalgamation.zip

f829c86d6bf733b8d09758d210dd981b927f63635cdb3941398ac73f191812ed sqlite3mc-1.9.1-sqlite-3.47.1-android.aar
87a4ce7bfa2c41f14eb96017e5b5efb4dc0b6742d9fb2798a833adf8a258a9c2 sqlite3mc-1.9.1-sqlite-3.47.1-wasm.zip

SQLite3 Multiple Ciphers 1.9.0 (based on SQLite 3.47.0)

Changes since previous release

• Based on SQLite version 3.47.0
• Changed signature of cipher scheme method GenerateKey (affects only developers of dynamic cipher schemes)
• Fixed SQLCipher incompatibility. Using differing KDF and HMAC algorithms resulted in databases incompatible with the original SQLCipher library. Setting the parameter hmac_algorithm_compat to 0 restores the (incompatible) behaviour.

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

d5c55ba2d25e6d40ab0685f9ea280d3161467a9a6f113d63c74709a188b29359 sqlite3mc-1.9.0-sqlite-3.47.0-icu-win32.zip
70df41e77e2dd692c2bbab428e700ae130b5f36e9c3ef5e4d05df51e84b39414 sqlite3mc-1.9.0-sqlite-3.47.0-icu-win64.zip
377f1ccd92638e792d2c9535534dcef597c2a3ab87b637d7228361367bd41f7f sqlite3mc-1.9.0-sqlite-3.47.0-win32.zip
164502bbc12c708f3edd0ba55adf14efa8c84870a1d98c860e56922a41f8c416 sqlite3mc-1.9.0-sqlite-3.47.0-win64.zip

162681d1a08dec3c96f6ded1963a417dec759ace929d6405e017624a31d5cc9b sqlite3mc-1.9.0-sqlite-3.47.0-amalgamation.zip

ef76caa930b1de86a3537f392d3afbfba611465484862d94153cd72a4064650e sqlite3mc-1.9.0-sqlite-3.47.0-android.aar
c37475d108a29d23625f72316c546dd454ebdff028eacac86eb5bca2996a4192 sqlite3mc-1.9.0-sqlite-3.47.0-wasm.zip

SQLite3 Multiple Ciphers 1.8.7 (based on SQLite 3.46.1)

Changes since previous release

• Based on SQLite version 3.46.1

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

245b09ddef467f929e082ce12315b037f3ab4330c2b22c17eb7a20a1e0d699b9 sqlite3mc-1.8.7-sqlite-3.46.1-icu-win32.zip
cf99fb8ee6912c9645a5df5fcd475d025061e3155205c8b41f0a2b04a73ad5ad sqlite3mc-1.8.7-sqlite-3.46.1-icu-win64.zip
d5bb6cb4bf176f903cc13392f6f0d842a1c5b4c17781d3bc2f4321e85ecdcf7f sqlite3mc-1.8.7-sqlite-3.46.1-win32.zip
c6b45041a71839b7b43f9ff5ee0dfc9dea842225f7fed0a7b340b5139c29e025 sqlite3mc-1.8.7-sqlite-3.46.1-win64.zip

fb1f8240acba984ed7158f139ac2417c9b7cd727b5b9c0b67c98465778e8cc65 sqlite3mc-1.8.7-sqlite-3.46.1-amalgamation.zip

29764e28b007452eb6759bdcf875a1724ff0f300418f049556fe17b9962b1191 sqlite3mc-1.8.7-sqlite-3.46.1-android.aar
fc42d43f77ef97a5c9b67f1902e7dd4b1d892e5ec06d6a7714cc38aba23c27e0 sqlite3mc-1.8.7-sqlite-3.46.1-wasm.zip

SQLite3 Multiple Ciphers 1.8.6 (based on SQLite 3.46.0)

Changes since previous release

• Based on SQLite version 3.46.0
• The cipher configuration parameter legacy_page_size now accepts only valid page sizes
• The cipher configuration parameter plaintext_header_size now accepts only values that are multiples of 16
• Cleaned up code (removed trailing white space, removed extern keyword in function declarations, added SQLITE_PRIVATE for several internal functions)

Fixed issues

• Fixed issue #156 - corrupted database if MMAP_SIZE > 0 was used
• Fixed issue #158 - add check to verify compatibility of source and target database in backup operation
• Fixed issue #160 - fix accessing memory out of array bounds
• Fixed issue #162 - fix loading/storing misaligned data
• Fixed issue #164 - fix return of error messages from rekey
• Fixed issue #165 - fix rekey function by enforcing page size and number of reserved bytes per page
• Fixed issue #166 - missing attribute SQLITE_PRIVATE for several internal functions
• Fixed issue #167 - improve VFS error reporting
• Fixed issue #168 - add check for encryption support

Important

Most issues listed above were detected during the development of the Python binding apsw-sqlite3mc.
Updating is recommended, because some of the issues can lead to corrupted databases (although not always and usually only under certain circumstances).

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

25b7109cf4b75a5b354930c2b8e19e6dd211cd406a2f490ba3b1d1c99f4f6eed sqlite3mc-1.8.6-sqlite-3.46.0-icu-win32.zip
414f8f3812d217e90793cd1fa750ee04f45e8e37688cc448a6fa1c749fbf72b9 sqlite3mc-1.8.6-sqlite-3.46.0-icu-win64.zip
d6f494cc5e8018019045bf2c0d2badc43b5cd4b37cc7cd4ac52895809a87377b sqlite3mc-1.8.6-sqlite-3.46.0-win32.zip
3cb5bf7c609d47bb2d6c09982ae8aa9b5f6be997ce7d9c8b36eea735e0cea25c sqlite3mc-1.8.6-sqlite-3.46.0-win64.zip

0f93deec815ba0a856c5d1dde7b8826321478b5801a65657b73e8f1f3a97947f sqlite3mc-1.8.6-sqlite-3.46.0-amalgamation.zip

7619411228df9f657690119395737646ce2f2c18a285fe1d1ce71ab4b812b536 sqlite3mc-1.8.6-sqlite-3.46.0-android.aar
c8194c5ef62e1c1164781381d2209aac5113c131fe1ce77d05b59627e4325bf1 sqlite3mc-1.8.6-sqlite-3.46.0-wasm.zip

SQLite3 Multiple Ciphers 1.8.5 (based on SQLite 3.46.0)

Changes since previous release

• Based on SQLite version 3.46.0

Note regarding future development
Please consider to vote on Handling of temporary SQLite files regarding encryption (Discussion/Poll #150).

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

a8fc74cecd195b0bb9360b1c434279ba7571cf8cbe506677233a1dfe9e3b97f9 sqlite3mc-1.8.5-sqlite-3.46.0-icu-win32.zip
e566e95afeb8c25526b4b8bed4189df47dbeaa24927cb42fe2718c62a2b9883b sqlite3mc-1.8.5-sqlite-3.46.0-icu-win64.zip
2e222b474cdba76c8860b951af3beaef8cf4b26c1b16eb94515fabc834792d71 sqlite3mc-1.8.5-sqlite-3.46.0-win32.zip
dc68811c763b1b9ab8f5a390f0f1687f5ea5a0276d892f2bcc8fbc28c3e17c4c sqlite3mc-1.8.5-sqlite-3.46.0-win64.zip

212a5eb8e30975f739f3fb32283473ddf9d38e35b3425270bec5b723dfa9a407 sqlite3mc-1.8.5-sqlite-3.46.0-amalgamation.zip

39da4810c84146be64ce480bebf412f715db8b8b1adace6ed6d3c9a8eaddefe7 sqlite3mc-1.8.5-sqlite-3.46.0-android.aar
25e5ab0d80be5e4386b83fcb9a3ea90d3a122bbe7ea19f37d90274b9b9f4a838 sqlite3mc-1.8.5-sqlite-3.46.0-wasm.zip

SQLite3 Multiple Ciphers 1.8.4 (based on SQLite 3.45.2)

Changes since previous release

• Based on SQLite version 3.45.2
• Disable user authentication extension by default

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

d031655140c8c6b35680c1131a6023caf701939e3c6d791499ac5e2d8a8a457a sqlite3mc-1.8.4-sqlite-3.45.2-icu-win32.zip
ce839d9572e9769c23a9b952315cfc38dadf64fe868faac13d7f0eae3aba3acd sqlite3mc-1.8.4-sqlite-3.45.2-icu-win64.zip
995d450eb283a96fcfa6b6757b03d427b45420a5ec9be5fa4c990fe3f070f8f6 sqlite3mc-1.8.4-sqlite-3.45.2-win32.zip
39ad804f4f658ccbc5c32c0ba76031b73f6b5ff6b542ce5cac36c8870688d2c6 sqlite3mc-1.8.4-sqlite-3.45.2-win64.zip

e27cd7c5f8e525980f38df25a91b45abd69957397ad2797409abba43c0dffc7c sqlite3mc-1.8.4-sqlite-3.45.2-amalgamation.zip

5e0db100675096bee5ab579838c7c9aeb15a3d04695024ad14920f0b6810f8f4 sqlite3mc-1.8.4-sqlite-3.45.2-android.aar
7f77a4d6a4728423be757a6eaa479879cd70b5406f436b2695812963389c4dfd sqlite3mc-1.8.4-sqlite-3.45.2-wasm.zip

SQLite3 Multiple Ciphers 1.8.3 (based on SQLite 3.45.1)

Changes since previous release

• Based on SQLite version 3.45.1

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 - a single C source file and a single C header file,
• 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).

To verify your download please use the following SHA256 checksums:

304c6543351515b0ad322dfe1a456a5fb47d4cbe923f7c4d519c18edb4139f16 sqlite3mc-1.8.3-sqlite-3.45.1-icu-win32.zip
46c8d06b4a23a1ca76c46300be2dfca4e8ee968c621d0984d22b8ac7947d96ef sqlite3mc-1.8.3-sqlite-3.45.1-icu-win64.zip
b1206dc5fcb1717242f5c77b1f42698aaf2c62b03d7720a542556752342387b4 sqlite3mc-1.8.3-sqlite-3.45.1-win32.zip
2213218f84a9a0d901a1828a84620e1b2221717e143b79132c1b80e502a1d724 sqlite3mc-1.8.3-sqlite-3.45.1-win64.zip

2fb66f8a39971060179d5b63c87d3e3fee6e9887f04b0cdd5e8ac4662e3ab8a7 sqlite3mc-1.8.3-sqlite-3.45.1-amalgamation.zip

cde97eb09eefd87195ce627ea0c59ed77df10effa450fd5d0ff74d216bab3166 sqlite3mc-1.8.3-sqlite-3.45.1-android.aar
1c0fd2fcffa67127921f82e29c8d22f1b8558bfd84afb150745cc0cbb4bb9add sqlite3mc-1.8.3-sqlite-3.45.1-wasm.zip

SQLite3 Multiple Ciphers 1.8.2 (based on SQLite 3.45.0)

Changes since previous release

• Based on SQLite version 3.45.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. The SQLite3 shell applications support the SQLite Archive feature.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.

SQLite3 Multiple Ciphers 1.8.1 (based on SQLite 3.44.2)

Changes since previous release

• Based on SQLite version 3.44.2
• Applied several modifications to improve support for SQLite3 WASM
• Fixed issue #133 - missing API symbols

🔵 This release includes for the first time a precompiled bundle of sqlite3.wasm and its JavaScript APIs with SQLite3 Multiple Ciphers encryption support, ready for use in web applications.

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. The SQLite3 shell applications support the SQLite Archive feature.
• Additionally, a source code amalgamation is provided. That is, a single C source file and a single C header file.