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

1.5.2 / 2022-10-01

1.5.2 / 2022-10-01

Packaging

This version correctly vendors the tarball for sqlite v3.39.4 in the vanilla "ruby" platform gem package, so that users will not require network access at installation.

v1.5.0 and v1.5.1 mistakenly packaged the tarball for sqlite v3.38.5 in the vanilla "ruby" platform gem, resulting in downloading the intended tarball over the network at installation time (or, if the network was not available, failure to install). Note that the precompiled native gems were not affected by this issue. [#352]

---

sha256 checksums:

94626203958f9abf5e7d28b0337af6d00fb10cabfc3d65e70eb95b878080a812  sqlite3-1.5.2-aarch64-linux.gem
ada7a8ec6b13165ebb56dfc8df9f896d2b41c78e92e2ba0b5bca969b6c376e1d  sqlite3-1.5.2-arm-linux.gem
472d837f79273bbfb7d626c787a0f3e9f0bd0a3855ed5bfee1ef70bee8808ced  sqlite3-1.5.2-arm64-darwin.gem
750bf833b72550244c672cb3467b68b5c89b3e8be2c893a2749cdbc3841ee898  sqlite3-1.5.2-x64-mingw-ucrt.gem
e750e17784cd76b59f5dd9a3366f9b0d76626872700f0f59194f2f4c439cbb01  sqlite3-1.5.2-x64-mingw32.gem
caf0a7717375addb46157b1090ad02316a9491531d69e2389f56058ce784518e  sqlite3-1.5.2-x86-linux.gem
caff6c75b13874ce828514a95aa437744e042390fdeb0f73decde16235d3fe2f  sqlite3-1.5.2-x86_64-darwin.gem
245f2ef5dd9c6a2b3df41b4af41fa659c8917d0cc231d4c1b03b4d199ae412e7  sqlite3-1.5.2-x86_64-linux.gem
9b3153b5703b4619534135c16ff7c4e8ba1adbd8548ff61bb4a002dd632bcd5e  sqlite3-1.5.2.gem

1.5.1 / 2022-09-29

1.5.1 / 2022-09-29

Dependencies

• Vendored sqlite is updated to v3.39.4.

Security

The vendored version of sqlite, v3.39.4, should be considered to be a security release. From the release notes:

Version 3.39.4 is a minimal patch against the prior release that addresses issues found since the
prior release. In particular, a potential vulnerability in the FTS3 extension has been fixed, so
this should be considered a security update.

In order to exploit the vulnerability, an attacker must have full SQL access and must be able to
construct a corrupt database with over 2GB of FTS3 content. The problem arises from a 32-bit
signed integer overflow.

For more information please see GHSA-mgvv-5mxp-xq67.

---

sha256:

f9094440f8e561c5d37cf66a13c807f60ce5013d0a40ee5ee5942906b9cc77c4  sqlite3-1.5.1-aarch64-linux.gem
8ef2be3d373b4e4c4c3f7622b63403d1f7109fa5b9d922203ce29671f19d6b32  sqlite3-1.5.1-arm-linux.gem
aa38f01893530612dd1cb3083dc34fe3a22a7cb00393f9bdaa67c4498b228e06  sqlite3-1.5.1-arm64-darwin.gem
7940ee9080313fa44c9b33cd7c24c069f40f208b970234867239ef6b6d24db31  sqlite3-1.5.1-x64-mingw-ucrt.gem
1ee072798f8e10df1f34a8ee884eaad82a2d40b0cbbe5ebca2bcf937a9ca954c  sqlite3-1.5.1-x64-mingw32.gem
0e3807ad01aa6c77896d68658706b950328dd991e1dc8e9c56cafa69d64b4282  sqlite3-1.5.1-x86-linux.gem
319b1227e4983549f35997518dfa48df89239055e2460ec13277d84b2f3b200f  sqlite3-1.5.1-x86_64-darwin.gem
d983ba51eff37c3679963949f4132b32f528d0a0bc3df09150c8e1a0a88e0444  sqlite3-1.5.1-x86_64-linux.gem
9148b84e4810284fe18573fce214060011d3f7af3a46a3ebd65b066da8242fbc  sqlite3-1.5.1.gem

1.5.0 / 2022-09-08

1.5.0 / 2022-09-08

Packaging

Faster, more reliable installation

Native (precompiled) gems are available for Ruby 2.6, 2.7, 3.0, and 3.1 on all these platforms:

• aarch64-linux
• arm-linux
• arm64-darwin
• x64-mingw32 and x64-mingw-ucrt
• x86-linux
• x86_64-darwin
• x86_64-linux

If you are using one of these Ruby versions on one of these platforms, the native gem is the recommended way to install sqlite3-ruby.

See the README for more information.

More consistent developer experience

Both the native (precompiled) gems and the vanilla "ruby platform" (source) gem include sqlite v3.39.3 by default.

Defaulting to a consistent version of sqlite across all systems means that your development environment behaves exactly like your production environment, and you have access to the latest and greatest features of sqlite.

You can opt-out of the packaged version of sqlite (and use your system-installed library as in versions < 1.5.0). See the README for more information.

Release notes for this version of sqlite

Rubies and Platforms

• TruffleRuby is supported.
• Apple Silicon is supported (M1, arm64-darwin).
• vcpkg system libraries supported. [#332] (Thanks, @MSP-Greg!)

Added

• SQLite3::SQLITE_LOADED_VERSION contains the version string of the sqlite3 library that is dynamically loaded (compare to SQLite3::SQLITE_VERSION which is the version at compile-time).

Fixed

• SQLite3::Database#load_extensions now raises a TypeError unless a String is passed as the file path. Previously it was possible to pass a non-string and cause a segfault. [#339]

---

sha256 checksums:

075f634aefaf00bcec3186ac01527315df8de4c7b67636aee286d3878413ca1b  sqlite3-1.5.0-aarch64-linux.gem
07803d427d839badacd9eae0b3f91496b730dc91731b86b8a29a140d40e7c7db  sqlite3-1.5.0-arm-linux.gem
a0c849dcbf7496e521a6de8ff0f47a30ce9d3403ce85f483705a7fd8a88b52ef  sqlite3-1.5.0-arm64-darwin.gem
58cc3f1a933a7392e07d8f3f8deb09b0fe884a6ee7b292b62d13ead1bd2eb1c5  sqlite3-1.5.0-x64-mingw-ucrt.gem
975abf40f39f4277ce695a9ecdaa155f47c704ffe9f96c30a5fed13b7dbe655f  sqlite3-1.5.0-x64-mingw32.gem
11a9a51e2cd2dafecbaef2d95e2e22a0fc77bcf3b00826367ae41d69573d60ab  sqlite3-1.5.0-x86-linux.gem
e89b9f958f5ac658de66f5e654dab898b8bcc53c5a0f11b58eed9ce6baea433f  sqlite3-1.5.0-x86_64-darwin.gem
cd996d8fe08244b9bcc81f217eb67171cb6df26d6c5cff2bfdade09248e1842b  sqlite3-1.5.0-x86_64-linux.gem
8eeb6dab3c7ff6b1aa88f8a4a3879b33048c74b309077dba67fa71b72352048a  sqlite3-1.5.0.gem

1.5.0.rc2 / release candidate / 2022-08-30

1.5.0.rc2 / release candidate / 2022-08-30

Packaging

Faster, more reliable installation

Native (precompiled) gems are available for Ruby 2.6, 2.7, 3.0, and 3.1 on all these platforms:

• aarch64-linux
• arm-linux
• arm64-darwin
• x64-mingw32 and x64-mingw-ucrt
• x86-linux
• x86_64-darwin
• x86_64-linux

If you are using one of these Ruby versions on one of these platforms, the native gem is the recommended way to install sqlite3-ruby.

See the README for more information.

More consistent developer experience

Both the native (precompiled) gems and the vanilla "ruby platform" (source) gem include sqlite v3.39.2 by default.

Defaulting to a consistent version of sqlite across all systems means that your development environment behaves exactly like your production environment, and you have access to the latest and greatest features of sqlite.

You can opt-out of the packaged version of sqlite (and use your system-installed library as in versions < 1.5.0). See the README for more information.

Release notes for this version of sqlite

Rubies and Platforms

• TruffleRuby is supported.
• Apple Silicon is supported (M1, arm64-darwin).
• vcpkg system libraries supported. [#332] (Thanks, @MSP-Greg!)

Added

• SQLite3::SQLITE_LOADED_VERSION contains the version string of the sqlite3 library that is dynamically loaded (compare to SQLite3::SQLITE_VERSION which is the version at compile-time).

Fixed

• SQLite3::Database#load_extensions now raises a TypeError unless a String is passed as the file path. Previously it was possible to pass a non-string and cause a segfault. [#339]

---

sha256 checksums:

7b756b09294626702c765874e7c4895051cb1376b81ae656666498d544ed3277  sqlite3-1.5.0.rc2-aarch64-linux.gem
8a40518bbfdc560c91464904a00459070516b7b1fdb18569498a3a02461dff83  sqlite3-1.5.0.rc2-arm-linux.gem
7964187515319e095c4ccf2ea490f77e319af990627dbcb6513c7fc1432a35d9  sqlite3-1.5.0.rc2-arm64-darwin.gem
bfff5801b5abf53f8f2ef2a226e5d35b6741d26256d5fbfa3f052f331d4583a2  sqlite3-1.5.0.rc2-x64-mingw-ucrt.gem
600959c4af340c438b88218560ea594a4251f946e99c6b6303a12c27aecb859c  sqlite3-1.5.0.rc2-x64-mingw32.gem
967cb9fdab77f5f4a4204a3edb0dfd4f6d252212f87e807976f94dcda6f6e49f  sqlite3-1.5.0.rc2-x86-linux.gem
9938a3d4d42512cac64cce7cfb4e5756e908c60003933467195ca4685672e824  sqlite3-1.5.0.rc2-x86_64-darwin.gem
e38c14b45824e8d54538cd79c69cdd1f09e8df436af7e3a03965d09e7938ec4f  sqlite3-1.5.0.rc2-x86_64-linux.gem
a6aef3857bf15e318080e603f02b383e1b15d89a88aee162f01799e87d887430  sqlite3-1.5.0.rc2.gem