1.6.5.rc1 / 2023-09-08

1.6.5.rc1 / 2023-09-08

Packaging

• Allow setting compiler flags for the sqlite library via a --with-sqlite-cflags argument to extconf.rb. See INSTALLATION.md for more information. [#401, #402] (@flavorjones)

---

sha256 checksums:

1bfb73e8cc8ea478861072a238d9e99cb54adf6acf134367681409e41415f9b3  sqlite3-1.6.5.rc1-aarch64-linux.gem
b5c6ebee7748449a2f4a740358c9cbac76b488cc81cfc7be88a6326b0062aa20  sqlite3-1.6.5.rc1-arm-linux.gem
f6151d691595f116278221ef58400ea5c5f53b5f95bb1af7cdde351a2e48290a  sqlite3-1.6.5.rc1-arm64-darwin.gem
588535944732260bd24327935ae61507f04cbf904e301d324d448c78a94d6fac  sqlite3-1.6.5.rc1-x64-mingw-ucrt.gem
c77290d887b57548f639038500b52f26309dfaae4d3c21f5866b89c2e38bec4d  sqlite3-1.6.5.rc1-x64-mingw32.gem
4aed65d6e7344bb3d39c9d5abe44ad563b80dc754202e9b2371c42e1cbb18915  sqlite3-1.6.5.rc1-x86-linux.gem
21c39c9b0d5ebca9ef9576ed99c2ae83eb2068c6e3296cfc4f43b9b4e0fc76e1  sqlite3-1.6.5.rc1-x86_64-darwin.gem
bba80f38bae631dc671a21548dc8840a2b964eee2c6170b858957ce031768733  sqlite3-1.6.5.rc1-x86_64-linux.gem
ae75935edb2e379b5cd9dd958745afcf92174c94fdfd54c5aa4be059d2ada816  sqlite3-1.6.5.rc1.gem

1.6.4 / 2023-08-26

1.6.4 / 2023-08-26

Dependencies

Vendored sqlite is updated to v3.43.0.

Upstream release notes:

SQLite Release 3.43.0 On 2023-08-24

• Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
• Enhancements to the date and time functions:
  • Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
  • Added the timediff() SQL function.
• Added the octet_length(X) SQL function.
• Added the sqlite3_stmt_explain() API.
• Query planner enhancements:
  • Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
  • Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
• Enhancements to the decimal extension:
  • New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
  • New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
  • If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent.
• Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings.
• New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
• Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is enabled by default when building on Windows using Makefile.msc.
• The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0.

---

sha256 checksums:

612cffeb329d282226fe56c160ec3a98e2ee6a1a39020f18bf5db7c3cf3108f3  sqlite3-1.6.4-aarch64-linux.gem
60803013a225021574a8b11485fb98f56b0f0c6723a8a85813f24b8828361a4a  sqlite3-1.6.4-arm-linux.gem
4e3faaf9707284d0835944dd444105a6eaa441cfdd12514aa38e61bea79dd7f4  sqlite3-1.6.4-arm64-darwin.gem
4e269ff73b126e98bf9674f1e9f7ee7fd1d3b62cc61f680beeb832c782ca2a4b  sqlite3-1.6.4-x64-mingw-ucrt.gem
715e3e9acc253441a51593f508ddfb11c6ac325037c0183ccc550a9858c50a65  sqlite3-1.6.4-x64-mingw32.gem
4062f32f3506cb8215df8328ad5ca38dd4a9c2c76683d165753da916a14bc0fb  sqlite3-1.6.4-x86-linux.gem
2d17a20990d2a5b451470e26064600d58501ad73a62874dad1a3adce5d760943  sqlite3-1.6.4-x86_64-darwin.gem
0fb593369047f70016afc9ab79ce4ffa0a8976d0ba3a470f9fc7a4702dc11655  sqlite3-1.6.4-x86_64-linux.gem
f908a60df7bf19cf559ba7a5da369e5eb19d48fad639225037c70b26d66af635  sqlite3-1.6.4.gem

1.6.3 / 2023-05-16

1.6.3 / 2023-05-16

Dependencies

Vendored sqlite is updated to v3.42.0.

From the release announcement:

This is a regular enhancement release. The main new features are:

• SQLite will now parse and understand JSON5, though it is careful to generate only pure, canonical JSON.
• The secure-delete option has been added to the FTS5 extension.

---

sha256 checksums:

a6127f665f7a628ff53ebf5009b911c0a0580f57f679cffeb9e664827281a12e  sqlite3-1.6.3-aarch64-linux.gem
826182274353850009c9c3ec07b07c0baaf4b81535f144064fe6f265b91d129d  sqlite3-1.6.3-arm-linux.gem
eb95b8e4d90506ff4eaf7eeab419ab01894cc223f97e1a71b6ae7cdbf7840548  sqlite3-1.6.3-arm64-darwin.gem
5df1dcf85b2027fa5bc054250ca2201cf28721151470cb0c45fbb8e21b92399e  sqlite3-1.6.3-x64-mingw-ucrt.gem
b92b02e02d20acd5a6cb719df126237fe5aac8545a10aa08ff8ca1dc7c9a958a  sqlite3-1.6.3-x64-mingw32.gem
32bf8139aba22bccab19c44e72388f0da3c07921ad80738785fd4b4fe2fa369d  sqlite3-1.6.3-x86-linux.gem
b74b8694e3e090c2e08ccb85b23fb889690d068ca0cace49f9e1d118058bdc46  sqlite3-1.6.3-x86_64-darwin.gem
aebdc5821f4ddeeb9cc36983f0a9c3815e1024e3bd4ddb0dcbc212bb20569de8  sqlite3-1.6.3-x86_64-linux.gem
67b476378889b15c93f9b78d39f6d92636dda414194d570d3a1b27514a9e2541  sqlite3-1.6.3.gem

1.6.2 / 2023-03-27

1.6.2 / 2023-03-27

Dependencies

Vendored sqlite is updated from v3.41.0 to v3.41.2.

Packaging

• Allow compilation against system libraries without the presence of mini_portile2, primarily for the convenience of linux distro repackagers. [#381] (Thank you, @voxik!)

1.6.1 / 2023-02-22

1.6.1 / 2023-02-22

Dependencies

• Vendored sqlite is updated to v3.41.0.

---

sha256 checksums:

99d334b06d81edf5ab112c5025908d4228afa8031c19117ab21e9dd7752094cd  sqlite3-1.6.1-aarch64-linux.gem
d286563c448269489b2be5655ac8330e522aa3e2c3088b612c1bc533ec2b6319  sqlite3-1.6.1-arm-linux.gem
a877b19ddabd30960e22aa79a0f4a4126f87f51df4be88050034e71293d7477a  sqlite3-1.6.1-arm64-darwin.gem
46c262f07dae7057e817519f030cafbc2e837ee6f5730071bcd98129d5396acd  sqlite3-1.6.1-x64-mingw-ucrt.gem
07f215047eec18473bbaab51a89252bea00263ab26fb7ad2766fb9c3ca69bb10  sqlite3-1.6.1-x64-mingw32.gem
ad395e8794a694140dad33aa7164968d05ed52b32cfaa579f645900c0839ef53  sqlite3-1.6.1-x86-linux.gem
074082d1fdda1f2e326b4860e2b12b35988823a31847e6b6c2d58dad0b37c1ce  sqlite3-1.6.1-x86_64-darwin.gem
b36fee5821ed28b547327317a0ee63b0cb2191060dbfb1ea40d93d343dfc8f59  sqlite3-1.6.1-x86_64-linux.gem
54b8afa57e341d381b1cfcd8849aa826d87118abcd002a8159d9f4bdbf498f18  sqlite3-1.6.1.gem

1.6.0 / 2023-01-13

1.6.0 / 2023-01-13

Ruby

This release introduces native gem support for Ruby 3.2.

This release ends native gem support for Ruby 2.6, for which upstream support ended 2022-04-12.

Dependencies

• Vendored sqlite3 is updated to v3.40.1.

Fixes

• get_boolean_pragma now returns the correct value. Previously, it always returned true. [#275] (Thank you, @Edouard-chin!)

---

sha256 checksums

360ac488c2e0f7569ee757c80e73941c30cf5d5be3e5e6af747d2d9c8058841b  sqlite3-1.6.0-aarch64-linux.gem
8adbe1c4845832c8ff295d263adf880f6e045f7dd06eb1c179e45349a963eced  sqlite3-1.6.0-arm-linux.gem
b691ab812651de0607aabd6005642c8f4611f773e324cbed66b4bfa0da864c59  sqlite3-1.6.0-arm64-darwin.gem
c4ccd5a01c2feeb7370d34887f97c0c62fe58d7830d81adf9977afd48425fa4d  sqlite3-1.6.0-x64-mingw-ucrt.gem
43211334166269933fbd85b04f45be681521f36f7e779bd37f2d6005257d8360  sqlite3-1.6.0-x64-mingw32.gem
639e3a9909897c03d5a014da7412506afb985a55007b86f6830c8a7cac65385a  sqlite3-1.6.0-x86-linux.gem
e177778f16415370eb1e7401a492ec25c48d00ac5ff83789ba905e50ee083c64  sqlite3-1.6.0-x86_64-darwin.gem
a2488dcf0e72928bab2b15b934113ce8d7a3b4031277e362d66e40956d5c709e  sqlite3-1.6.0-x86_64-linux.gem
3d74af62d3cbf51856c4f9acd17e350d1d58c7e9639dbd3d7a38b00acac54438  sqlite3-1.6.0.gem

1.6.0.rc2 / prerelease

1.6.0.rc2 / prerelease

Please note that Ruby 3.2 changes how symbols are resolved on MacOS, so we're particularly interested in hearing feedback from MacOS users about the native (precompiled) gem packages for Ruby 3.2.

We're waiting for the following to do a final release:

• a final release of rake-compiler-dock that supports Ruby 3.2
• feedback to build confidence that our approach to Darwin symbol resolution in the precompiled extension works for everyone

Note that this build was created using rake-compiler-dock snapshot images based on rake-compiler/rake-compiler-dock@ce619f2 (2023-01-04)

Note that this version differs from rc1 in that many symbols previously being exported on ELF platforms (Linux, Darwin) are now hidden in the shared object file. If you need to be able to link your C code against the sqlite gem's C extension, we want to hear from you! Please open an issue and let us know how you're using the library.

Ruby

This release introduces native gem support for Ruby 3.2.

This release ends native gem support for Ruby 2.6, for which upstream support ended 2022-04-12.

Dependencies

• Vendored sqlite3 is updated to v3.40.1.

Fixes

• get_boolean_pragma now returns the correct value. Previously, it always returned true. [#275] (Thank you, @Edouard-chin!)

---

sha256 checksums:

75e5ac5a6abff0168751ca073aab8c21a564348cb3df42c89c65d30b8e53bdf6  sqlite3-1.6.0.rc2-aarch64-linux.gem
248b63fd49bc2bd74fade94c45364fdee835d1d26a81976fa8596cc93c20f5a6  sqlite3-1.6.0.rc2-arm-linux.gem
88e1b281d88d3da4150a4411f3fe8465d7fd48876f9e2431f77fda70f63d6076  sqlite3-1.6.0.rc2-arm64-darwin.gem
a1ea01430e86716f6bfe066f19b6bd3e1d53ab1995f7b262e108770edd75b5d6  sqlite3-1.6.0.rc2-x64-mingw-ucrt.gem
12ad4286be68d415aa4b04b337b3d087335c901f9539e368f1f5a3c0f78d50e6  sqlite3-1.6.0.rc2-x64-mingw32.gem
451f7630d1a8c43717b0b9e3687f28d0d5dfc1b62010ac8fb5890b6d2d333814  sqlite3-1.6.0.rc2-x86-linux.gem
dcb85822def5d6d8c8d4e319d30af52e9bb2b8cab95694ec6e9d09a26bb6f9f0  sqlite3-1.6.0.rc2-x86_64-darwin.gem
ee76076a5546334542c8e4b1e9a3164914d25870095d586a319aff70dee44fb1  sqlite3-1.6.0.rc2-x86_64-linux.gem
fdf286b46fcf67ee4c31a50b4bea0ef8d9c04e628bda9d9ae7232b991773030e  sqlite3-1.6.0.rc2.gem

1.6.0.rc1 / prerelease

1.6.0.rc1 / prerelease

Please note that Ruby 3.2 changes how symbols are resolved on MacOS, so we're particularly interested in hearing feedback from MacOS users about the native (precompiled) gem packages for Ruby 3.2.

We're waiting for the following to do a final release:

• a final release of rake-compiler-dock that supports Ruby 3.2
• feedback to build confidence that our approach to Darwin symbol resolution in the precompiled extension works for everyone

Note that this build was created using rake-compiler-dock snapshot images based on rake-compiler/rake-compiler-dock@0f4b2c2

Ruby

This release introduces native gem support for Ruby 3.2.

This release ends native gem support for Ruby 2.6, for which upstream support ended 2022-04-12.

Dependencies

• Vendored sqlite3 is updated to v3.40.1.

Fixes

• get_boolean_pragma now returns the correct value. Previously, it always returned true. [#275] (Thank you, @Edouard-chin!)

---

sha256 checksums:

663bc916f35e8f737b539ec123098dd8ebfe525f5e2049ca0cbb40176fc9e256  sqlite3-1.6.0.rc1-aarch64-linux.gem
eb1231165badf219709e262e3ec9601de4cecbe426c9dcac0733fe9a81eacd63  sqlite3-1.6.0.rc1-arm-linux.gem
e72f38139f7d65f3a91ba4648f5032927f228094db6ddcd3a7d5117766877aba  sqlite3-1.6.0.rc1-arm64-darwin.gem
581ba8cdb70ab34543afc130fce602abfd3e5abfa4566acbaf9a2a9a7fe93dac  sqlite3-1.6.0.rc1-x64-mingw-ucrt.gem
f6b082db021a5e412e48b887d598f52923ba7e2b93df67e89215debfac7f4d6b  sqlite3-1.6.0.rc1-x64-mingw32.gem
3240261d9af7f10ba730f08475bdd6c6c44b395b264e547883a0c3d24166913b  sqlite3-1.6.0.rc1-x86-linux.gem
549261ce906694d01404fb5d47921ff0b6a1d83cc35e2389698dd3d0efa4b78f  sqlite3-1.6.0.rc1-x86_64-darwin.gem
f87fc954e04c8f2c450687c75699d841ba23e119104a29874d71db31e8ad46f6  sqlite3-1.6.0.rc1-x86_64-linux.gem
80a5aa3d3916691a80ce82bd24d9cfed7b41f93fc3bc6edd46834b1fe11a0d56  sqlite3-1.6.0.rc1.gem

1.5.4 / 2022-11-18

1.5.4 / 2022-11-18

Dependencies

• Vendored sqlite is updated to v3.40.0.

---

sha256 checksums:

6b5df9845b54de0933e829c40b222100c7bd5190c53adfd88a19bfafd4520132  sqlite3-1.5.4-aarch64-linux.gem
cfed00e8f9200ea38451856e53e891dc11d3297e95120f1f2879ec8000169941  sqlite3-1.5.4-arm-linux.gem
6e70813a40bc4524623f0d66b96cf3068397973c661ca33773f85cc3e49141a6  sqlite3-1.5.4-arm64-darwin.gem
186bcdd7869b9098f9091640c7e6b250951988eb9f0d92f05e5160b64bed0000  sqlite3-1.5.4-x64-mingw-ucrt.gem
28a4daf8386d67590f86f32284229de2fa66c7e19389fc7e18c60143be616729  sqlite3-1.5.4-x64-mingw32.gem
495757cc3d65484055706adf416ea3ce8040c4b5847d7a3e959e7f22a1990739  sqlite3-1.5.4-x86-linux.gem
d5db3d52c9bfffc172eaae265cb367ad6f8ee99e15deb3386c97889ef1673a95  sqlite3-1.5.4-x86_64-darwin.gem
28a91539287a4a19d1beb1b168cbbec969eda3035a1c8c9208475d9765152f89  sqlite3-1.5.4-x86_64-linux.gem
5d4f6bed23a629651c965f5107861f11df479d74eeef3a70d6ec702f28112101  sqlite3-1.5.4.gem

1.5.3 / 2022-10-11

1.5.3 / 2022-10-11

Fixed

• Fixed installation of the "ruby" platform gem when building from source on Fedora. In v1.5.0..v1.5.2, installation failed on some systems due to the behavior of Fedora's pkg-config implementation. [#355]

---

sha256 checksums:

6780cc379c25a1395568cfd9a422024a0a18e7e2a39024f4120815b1a9d9ddec  sqlite3-1.5.3-aarch64-linux.gem
a8c09c5df83058712489ca7a5b072be8efb62db1d1c30fef4b64e386ff20a408  sqlite3-1.5.3-arm-linux.gem
ed25f7d3a8edc2d0a7b64c51dbb12665e45f750249e88937ae7a4ecdc4a53d13  sqlite3-1.5.3-arm64-darwin.gem
11cd815acd898c1dda022d8145365235fff29cdc2cc155f611c12d66ec925211  sqlite3-1.5.3-x64-mingw-ucrt.gem
10aea826628e6bd4339dccac74679cea6709b95adb78f2661b97101658ac998d  sqlite3-1.5.3-x64-mingw32.gem
c427322e6deb8807165ebb17d027aa8127ae267be2dba769574722f468c0815e  sqlite3-1.5.3-x86-linux.gem
6237622911b170eaf53fa931e3128656d027452acfffdd8cd2d0584f70a40376  sqlite3-1.5.3-x86_64-darwin.gem
12bc33cd1e063651985801a877463aad86645e3bd27d46577dced1a0a41b3826  sqlite3-1.5.3-x86_64-linux.gem
66524f404db0b697620b601dea6381b139e9ce6f47e8eb628759c8d6ddcb25c5  sqlite3-1.5.3.gem