2.3.0 / 2024-11-20

2.3.0 / 2024-11-20

Added

• The SQLITE_DBPAGE extension is now enabled by default, which implements an eponymous-only virtual table that provides direct access to the underlying database file by interacting with the pager. See https://www.sqlite.org/dbpage.html for more information. [#578] @flavorjones
• The DBSTAT extension is now enabled by default, which implements a read-only eponymous virtual table that returns information about the amount of disk space used to store the content of an SQLite database. See https://sqlite.org/dbstat.html for more information. [#580] @pawurb @flavorjones
• Database#optimize which wraps the pragma optimize; statement. Also added Constants::Optimize to allow advanced users to pass a bitmask of options. See https://www.sqlite.org/pragma.html#pragma_optimize. [#572] @alexcwatt @flavorjones
• SQLite3::VERSION_INFO contains a bag of metadata about the gem and the sqlite library used. SQLite3::SQLITE_PACKAGED_LIBRARIES and SQLite3::SQLITE_PRECOMPILED_LIBRARIES indicate how the gem was built. [#581] @flavorjones

Fixed

• Database#encoding= support for switching the database encoding to UTF-16BE, which has been broken since Database#encoding= was introduced in v1.3.12 in 2016. [#575] @miyucy
• Omit mention of the pkg-config gem when failing to build from source, since it is not used. [#358] @flavorjones

sha256 checksums

87cbf39ca2ca07c4e6f3d7a5168bfc2fcca845ea36e6d04408622226900e7f92  sqlite3-2.3.0-aarch64-linux-gnu.gem
0e67ea7d8dc42178ac7b57f499177288cc1edf9c7932e86cf631e932947228c2  sqlite3-2.3.0-aarch64-linux-musl.gem
c2beb302a07e106722cd63bae42425bd0e913a4e90b552df64b1f04dec3d676d  sqlite3-2.3.0-arm64-darwin.gem
78ef24e763e513635e51a26709ad23cc11c30a895b5e2bc8c7ae2407a4f56059  sqlite3-2.3.0-arm-linux-gnu.gem
3815a8adc37f6d65e460c97eba725334b4db3a8bc68dbd2b2cfd2079656b20be  sqlite3-2.3.0-arm-linux-musl.gem
dc1b2afd5d099931d5fca7dfec44af3b78b9ec383c382edc6d35e268064b3673  sqlite3-2.3.0.gem
fb32821ae861135e670828f084de9d9e69b4598cd1643f7f8e6c7deeea06b000  sqlite3-2.3.0-x64-mingw-ucrt.gem
6ab00fbf07537e14cebd66e97159053e9094e68da9c6db8f82c21b4333a17345  sqlite3-2.3.0-x86_64-darwin.gem
5b8bbd85e661e04da863cb3d092fbf4e37c9817828ecc6f40a81791bd2111612  sqlite3-2.3.0-x86_64-linux-gnu.gem
db5fef66552d7e10c750f737f8838a63c39055711afac8e16025dbe274217b2b  sqlite3-2.3.0-x86_64-linux-musl.gem
bdb241da2bebe2bc5449cf121a552fe89f2476ed21cff169aa4d0f5ad9d750ff  sqlite3-2.3.0-x86-linux-gnu.gem
9c0989eb572331f569b4b976d6bf4010e322b4f591eb03fbcbf42674cacb4310  sqlite3-2.3.0-x86-linux-musl.gem