1.6.6 / 2023-09-12

1.6.6 / 2023-09-12

Dependencies

Vendored sqlite is updated to v3.43.1.

Upstream release notes:

• Fix a regression in the way that the sum(), avg(), and total() aggregate functions handle infinities.
• Fix a bug in the json_array_length() function that occurs when the argument comes directly from json_remove().
• Fix the omit-unused-subquery-columns optimization (introduced in in version 3.42.0) so that it works correctly if the subquery is a compound where one arm is DISTINCT and the other is not.
• Other minor fixes.

---

sha256 checksums:

36e3629930b08d2554b246ea46d0468f04db6cdfccc81ee58fdea21df7d194bf  sqlite3-1.6.6-aarch64-linux.gem
4afd1b62178f7a349f9d6c7c0266b5e58bd2168abcfc8f4a40b52e0e2d76bb32  sqlite3-1.6.6-arm-linux.gem
7c25128d54e71e96e880d82568986959f353e0873c5de3dbfe06d9c798cc9140  sqlite3-1.6.6-arm64-darwin.gem
8da1341f364c17714669de82386a0a1c695b16db690a495475257e09db3a28c5  sqlite3-1.6.6-x64-mingw-ucrt.gem
4388e188e394c9bae5b19934a9af48e7a1a283c577a864adbd3158b453b57c43  sqlite3-1.6.6-x64-mingw32.gem
7541a3cf51ea71b54b08f75e695436f50d69b2521e496d9f0f8f33943fa14e79  sqlite3-1.6.6-x86-linux.gem
651ea58dc43254c548aef5126ff970675216051ab180fb7c7a1f9da27d9c1e3b  sqlite3-1.6.6-x86_64-darwin.gem
b4f53e9515a37180edaa4aff00a4ccd0a8b5a2ba3a9b25d68900072ab110b83b  sqlite3-1.6.6-x86_64-linux.gem
6cf72c2b9d713ce0df06de4c6b8e2105ec2e052d9840660dfd4b26f32b2d8194  sqlite3-1.6.6.gem

1.6.5 / 2023-09-08

1.6.5 / 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:

2d342317a08a7ad18b89119374fd20267538962508e114eeab24f908a3ff64ca  sqlite3-1.6.5-aarch64-linux.gem
61b6a616eb39f6821bdb9f08a14a6a7220f3c52eebf58e051ee0e0bafa43fe14  sqlite3-1.6.5-arm-linux.gem
18268f6dce859472858bfafef1246112072de8785828d71b46b32660487472a0  sqlite3-1.6.5-arm64-darwin.gem
9e7b12bb1f8cd95b75115329a1a7fd385d1e3ef92008f70c12e7fe74d31c826a  sqlite3-1.6.5-x64-mingw-ucrt.gem
f95994280dd5cf002299e794e7305171e0ba8af016b028fea34b70e66021a1f7  sqlite3-1.6.5-x64-mingw32.gem
143ad8a28acc0a09c42c3230701172529efc1d94b0a841a25a38fc2e4f95872f  sqlite3-1.6.5-x86-linux.gem
a1eb5f5d34583bee786a9b83679f23a0a32987be9a77c0d46c46af72083d2c44  sqlite3-1.6.5-x86_64-darwin.gem
f322e3a5d670c7726ff0f2aefd7cb3c0d6d58f792b67d7bd33d859d4c4bdc816  sqlite3-1.6.5-x86_64-linux.gem
fb26fed260b95575ab396919c740de7a11989f6947fea4818e01962d6f77fdce  sqlite3-1.6.5.gem

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