1.7.0 / 2023-12-27

1.7.0 / 2023-12-27

Ruby

This release introduces native gem support for Ruby 3.3.

This release ends native gem support for Ruby 2.7, for which upstream support ended 2023-03-31. Ruby 2.7 is still generally supported, but will not be shipped in the native gems.

This release ends support for Ruby 1.9.3, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, and 2.6.

Improved

• SQLite3::Statement, Database, and Backup objects have been converted to use the TypedData API. See https://bugs.ruby-lang.org/issues/19998 for more context. [#432] @casperisfine

---

sha256 checksums:

eaff7c58c5bfc82c0ebc522d9991615fd8f98c4556d3160f90ae8c89fb6501ce  sqlite3-1.7.0-aarch64-linux.gem
46d27b7079e63c852afbfb888355c7137f240a5c9106a4ef6e2df9791a1ff485  sqlite3-1.7.0-arm-linux.gem
b5a384f382099e2d09c2f05b9618c1177a5ecb19798ce1e65a50d84d49377451  sqlite3-1.7.0-arm64-darwin.gem
0fe774367f7d52e85e83c9b30f01bbedbb7d6fcaf5b7a0b119a2af196a6c1ddb  sqlite3-1.7.0-x64-mingw-ucrt.gem
e0f4a8be499ef6cdd3511f521c68c6145f53370040315c4d0e4ecaa1bb3b1ee1  sqlite3-1.7.0-x64-mingw32.gem
1ade17be3ca7c9ca3a8fa6313101bcf578c3e10e139f4249b222f6fd7e4cb450  sqlite3-1.7.0-x86-linux.gem
1bedf29318e01d7fc77ca398ce36f57feefb45a291d86069c1fc0e7d19770af0  sqlite3-1.7.0-x86_64-darwin.gem
6cf008a7a81eb54c99db0f06a958372512f2f8c24fbe59e76c49fd4bf4135161  sqlite3-1.7.0-x86_64-linux.gem
894b5965591fb2db7d95572e93942f4fddd1762d37ec4fbc198b36426fcdae3c  sqlite3-1.7.0.gem

1.6.9 / 2023-11-26

1.6.9 / 2023-11-26

Dependencies

• Vendored sqlite is update to v3.44.2. @flavorjones

Added

• Database.new now accepts a :default_transaction_mode option (defaulting to :deferred), and Database#transaction no longer requires a transaction mode to be specified. This should allow higher-level adapters to more easily choose a transaction mode for a database connection. [#426] @masamitsu-murase

---

sha256 checksums:

bf664e360101349fce44ef80284f3e3f1995c2a972855317ea26db07b8109e5e  sqlite3-1.6.9-aarch64-linux.gem
d666010cc56146dfc7eefd23aec383b27247fce56a16ae85d936469414138cb2  sqlite3-1.6.9-arm-linux.gem
bed643cefc56db014dc6a20f5a5c8aa1df5a200bc172a9f3ef0a92c596846147  sqlite3-1.6.9-arm64-darwin.gem
c31fc7d4538ee24aa830507c98c3c558854ea702ea014751e6cc2c09675d8a1a  sqlite3-1.6.9-x64-mingw-ucrt.gem
6fc5f58c5c17433367473f596f5be5dfb635e29753aaf00afeddf1b7877b1ef4  sqlite3-1.6.9-x64-mingw32.gem
cd69cc1aa808d54ada8de59fc734d7ba9bf41b0011275f3946a337d5b8e858e5  sqlite3-1.6.9-x86-linux.gem
65c6e4bab10d84369900ee94c1b7babc95e472ae2c2c3c836561cef00c9b7b65  sqlite3-1.6.9-x86_64-darwin.gem
924c2d4d425e964a60bc5177e71ed372f71325425b3ea75971521b1fe184d1a2  sqlite3-1.6.9-x86_64-linux.gem
55a191656316de5bdbec28291ca2f45e8e41f804b3cc592faa318c4f69f93922  sqlite3-1.6.9.gem

1.6.8 / 2023-11-01

1.6.8 / 2023-11-01

Dependencies

• Vendored sqlite is updated to v3.44.0. @flavorjones
• rake-compiler-dock updated to v1.3.1 for precompiled native gems. @flavorjones

Added

• SQLite3::Database.open now returns the block result. Previously this returned the Database object. [#415] @toy
• Documentation improvement in lib/sqlite3/database.rb. [#421] @szTheory

---

sha256 checksums:

abc3318a84043144af10ed129b89419b103f17cd01c5882f6b565934ac739ef0  sqlite3-1.6.8-aarch64-linux.gem
46a970aabca4a876eb009a45d573d16fbba8b728b885b9df11a2e67251c7b983  sqlite3-1.6.8-arm-linux.gem
d747a0e51345b05d6eebbbd2009f561f3a1636125a97d182e87869e2d63c50e1  sqlite3-1.6.8-arm64-darwin.gem
5516d61103ad67e3ef9f81a4914eb4bea81ab297af4408e1b4bcdffae6b57faf  sqlite3-1.6.8-x64-mingw-ucrt.gem
71859f902a30cad52bfe702467dad04c979cb80203df11a9868753feecd77f43  sqlite3-1.6.8-x64-mingw32.gem
c607013f0b840c0c3c8a3e2bbd5576d07daa528996d1cc4e72a99bc563d36cdf  sqlite3-1.6.8-x86-linux.gem
47384c83a960e8553d015100d3375ccb6b25f9fc4ba6a9674da2ce75abd4a37b  sqlite3-1.6.8-x86_64-darwin.gem
9cf905b835d2444c77404023ffeac6140fdda7c90b6514556e400040f241d713  sqlite3-1.6.8-x86_64-linux.gem
30d8979972eb923928b8641e05548e7c552222b8c4c725762c039badf054c2d5  sqlite3-1.6.8.gem

1.6.7 / 2023-10-10

1.6.7 / 2023-10-10

Dependencies

Vendored sqlite is updated to v3.43.2.

Upstream release notes:

• Fix a couple of obscure UAF errors and an obscure memory leak.
• Omit the use of the sprintf() function from the standard library in the CLI, as this now generates warnings on some platforms.
• Avoid conversion of a double into unsigned long long integer, as some platforms do not do such conversions correctly.

Added

• Compile packaged sqlite3 with additional flags to explicitly enable FTS5, and set synchronous mode to normal when in WAL mode. [#408] (@flavorjones)

---

sha256 checksums:

c0a2523a982176f1f24201af2ac7a3b576598c9fc4eb4eff37cd6eccb5442601  sqlite3-1.6.7-aarch64-linux.gem
2d7487ae8260a23a58a7140252d63c6e2b93738ef4cd8e69f8d737663ca98845  sqlite3-1.6.7-arm-linux.gem
ccc3418105e1365f7ad0f6a253c54945c7b39c9823325be0dfd6b7648b2593a6  sqlite3-1.6.7-arm64-darwin.gem
d9ff6f69cb1b7d2d408098086957bf0af109c821ea65359c1070af4aa828b55b  sqlite3-1.6.7-x64-mingw-ucrt.gem
2672cc318063fc0c9bcdb0bf9fe914a550a9545fa18ec4c3a1246a9c8d2f7e3a  sqlite3-1.6.7-x64-mingw32.gem
adf7adb774c687c6f2881659c2d5ce9d30466fbfcbb0652c5e90f6722482b263  sqlite3-1.6.7-x86-linux.gem
ac386077bc043c2a0ef7334195e826b20fbc7382632da27637ad3f0620dc48d6  sqlite3-1.6.7-x86_64-darwin.gem
de24904b0679f043736d8e18931f1690ff2d20ea1a0cb491edc454f75718e8a2  sqlite3-1.6.7-x86_64-linux.gem
5c2b22210999a4f58b50f637cdd650d0aa9e333430f9bcd3e90c0a0aed7799bb  sqlite3-1.6.7.gem

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!)