sqlite3-ruby Changelog¶ ↑

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]

1.4.4 / 2022-06-14¶ ↑

Fixes¶ ↑

• Compilation no longer fails against SQLite3 versions < 3.29.0. This issue was introduced in v1.4.3. [#324] (Thank you, @r6e!)

1.4.3 / 2022-05-25¶ ↑

Enhancements¶ ↑

• Disable non-standard support for double-quoted string literals via the :strict option. [#317] (Thank you, @casperisfine!)

• Column type names are now explicitly downcased on platforms where they may have been in shoutcaps. [#315] (Thank you, @petergoldstein!)

• Support File or Pathname arguments to Database.new. [#283] (Thank you, @yb66!)

• Support building on MSVC. [#285] (Thank you, @jmarrec!)

1.4.2 / 2019-12-18¶ ↑

• Travis: Drop unused setting “sudo: false”

• The taint mechanism will be deprecated in Ruby 2.7

• Fix Ruby 2.7 rb_check_safe_obj warnings

• Update travis config

1.4.1¶ ↑

• Don’t mandate dl functions for the extention build

• bumping version

1.4.0¶ ↑

Enhancements¶ ↑

• Better aggregator support

Bugfixes¶ ↑

• Various

1.3.13¶ ↑

Enhancements¶ ↑

• Support SQLite flags when defining functions

• Add definition for SQLITE_DETERMINISTIC flag

1.3.12¶ ↑

Bugfixes¶ ↑

• OS X install will default to homebrew if available. Fixes #195

1.3.11 / 2015-10-10¶ ↑

Enhancements¶ ↑

• Windows: build against SQLite 3.8.11.1

Internal¶ ↑

• Use rake-compiler-dock to build Windows binaries. Pull #159 [larskanis]

• Expand Ruby versions being tested for Travis and AppVeyor

1.3.10 / 2014-10-30¶ ↑

Enhancements¶ ↑

• Windows: build against SQLite 3.8.6. Closes #135 [Hubro]

1.3.9 / 2014-02-25¶ ↑

Bugfixes¶ ↑

• Reset exception message. Closes #80

• Reduce warnings due unused pointers. Closes #89

• Add BSD-3 license reference to gemspec. Refs #99 and #106

1.3.8 / 2013-08-17¶ ↑

Enhancements¶ ↑

• Windows: build against SQLite 3.7.17

Bugfixes¶ ↑

• Reset exception message. Closes #80

• Correctly convert BLOB values to Ruby. Closes #65

• Add MIT license reference to gemspec. Closes #99

• Remove unused pointer. Closes #89

Internal¶ ↑

• Backport improvements in cross compilation for Windows

• Use of Minitest for internal tests

• Use Gemfile (generated by Hoe) to deal with dependencies

• Cleanup Travis CI

1.3.7 / 2013-01-11¶ ↑

Bugfixes¶ ↑

• Closing a bad statement twice will not segv.

• Aggregate handlers are initialized on each query. Closes #44

Internal¶ ↑

• Unset environment variables that could affect cross compilation.

1.3.6 / 2012-04-16¶ ↑

Enhancements¶ ↑

• Windows: build against SQLite 3.7.11

• Added SQLite3::ResultSet#each_hash for fetching each row as a hash.

• Added SQLite3::ResultSet#next_hash for fetching one row as a hash.

Bugfixes¶ ↑

• Support both UTF-16LE and UTF-16BE encoding modes on PPC. Closes #63

• Protect parameters to custom functions from being garbage collected too soon. Fixes #60. Thanks hirataya!

• Fix backwards compatibility with 1.2.5 with bind vars and query method. Fixes #35.

• Fix double definition error caused by defining sqlite3_int64/uint64.

• Fix suspicious version regexp.

Deprecations¶ ↑

• ArrayWithTypesAndFields#types is deprecated and the class will be removed in version 2.0.0. Please use the types method on the ResultSet class that created this object.

• ArrayWithTypesAndFields#fields is deprecated and the class will be removed in version 2.0.0. Please use the columns method on the ResultSet class that created this object.

• The ArrayWithTypesAndFields class will be removed in 2.0.0

• The ArrayWithTypes class will be removed in 2.0.0

• HashWithTypesAndFields#types is deprecated and the class will be removed in version 2.0.0. Please use the types method on the ResultSet class that created this object.

• HashWithTypesAndFields#fields is deprecated and the class will be removed in version 2.0.0. Please use the columns method on the ResultSet class that created this object.

1.3.5 / 2011-12-03 - ZOMG Holidays are here Edition!¶ ↑

Enhancements¶ ↑

• Windows: build against SQLite 3.7.9

• Static: enable SQLITE_ENABLE_COLUMN_METADATA

• Added Statement#clear_bindings! to set bindings back to nil

Bugfixes¶ ↑

• Fixed a segv on Database.new. Fixes #34 (thanks nobu!)

• Database error is not reset, so don’t check it in Statement#reset!

• Remove conditional around Bignum statement bindings. Fixes #52. Fixes #56. Thank you Evgeny Myasishchev.

Internal¶ ↑

• Use proper endianness when testing database connection with UTF-16. Fixes #40. Fixes #51

• Use -fPIC for static compilation when host is x86_64.

1.3.4 / 2011-07-25¶ ↑

Enhancements¶ ↑

• Windows: build against SQLite 3.7.7.1

• Windows: build static binaries that do not depend on sqlite3.dll be installed anymore

Bugfixes¶ ↑

• Backup API is conditionally required so that older libsqlite3 can be used. Thanks Hongli Lai.

• Fixed segmentation fault when nil is passed to SQLite3::Statement.new

• Fix extconf’s hardcoded path that affected installation on certain systems.

1.3.3 / 2010-01-16¶ ↑

Bugfixes¶ ↑

• Abort on installation if sqlite3_backup_init is missing. Fixes #19

• Gem has been renamed to ‘sqlite3’. Please use gem install sqlite3

1.3.2 / 2010-10-30 / RubyConf Uruguay Edition!¶ ↑

Enhancements¶ ↑

• Windows: build against 3.7.3 version of SQLite3

• SQLite3::Database can now be open as readonly

  db = SQLite3::Database.new('my.db', :readonly => true)

• Added SQLite3::SQLITE_VERSION and SQLite3::SQLITE_VERSION_NUMBER [nurse]

Bugfixes¶ ↑

• type_translation= works along with Database#execute and a block

• defined functions are kept in a hash to prevent GC. #7

• Removed GCC specific flags from extconf.

Deprecations¶ ↑

• SQLite3::Database#type_translation= will be deprecated in the future with no replacement.

• SQlite3::Version will be deprecated in 2.0.0 with SQLite3::VERSION as the replacement.

1.3.1 / 2010-07-09¶ ↑

Enhancements¶ ↑

• Custom collations may be defined using SQLite3::Database#collation

Bugfixes¶ ↑

• Statements returning 0 columns are automatically stepped. [RF #28308]

• SQLite3::Database#encoding works on 1.8 and 1.9

1.3.0 / 2010-06-06¶ ↑

Enhancements¶ ↑

• Complete rewrite of C-based adapter from SWIG to hand-crafted one [tenderlove] See API_CHANGES document for details. This closes: Bug #27300, Bug #27241, Patch #16020

• Improved UTF, Unicode, M17N, all that handling and proper BLOB handling [tenderlove, nurse]

• Added support for type translations [tenderlove]

  @db.translator.add_translator(‘sometime’) do |type, thing| ‘output’ # this will be returned as value for that column end

Experimental¶ ↑

• Added API to access and load extensions. [kashif] These functions maps directly into SQLite3 own enable_load_extension() and load_extension() C-API functions. See SQLite3::Database API documentation for details. This closes: Patches #9178

Bugfixes¶ ↑

• Corrected gem dependencies (runtime and development)

• Fixed threaded tests [Alexey Borzenkov]

• Removed GitHub gemspec

• Fixed “No definition for” warnings from RDoc

• Generate zip and tgz files for releases

• Added Luis Lavena as gem Author (maintainer)

• Prevent mkmf interfere with Mighty Snow Leopard

• Allow extension compilation search for common lib paths [kashif] (lookup /usr/local, /opt/local and /usr)

• Corrected extension compilation under MSVC [romuloceccon]

• Define load_extension functionality based on availability [tenderlove]

• Deprecation notices for Database#query. Fixes RF #28192

1.3.0.beta.2 / 2010-05-15¶ ↑

Enhancements¶ ↑

• Added support for type translations [tenderlove]

  @db.translator.add_translator(‘sometime’) do |type, thing| ‘output’ # this will be returned as value for that column end

Bugfixes¶ ↑

• Allow extension compilation search for common lib paths [kashif] (lookup /usr/local, /opt/local and /usr)

• Corrected extension compilation under MSVC [romuloceccon]

• Define load_extension functionality based on availability [tenderlove]

• Deprecation notices for Database#query. Fixes RF #28192

1.3.0.beta.1 / 2010-05-10¶ ↑

Enhancements¶ ↑

• Complete rewrite of C-based adapter from SWIG to hand-crafted one [tenderlove] See API_CHANGES document for details. This closes: Bug #27300, Bug #27241, Patch #16020

• Improved UTF, Unicode, M17N, all that handling and proper BLOB handling [tenderlove, nurse]

Experimental¶ ↑

• Added API to access and load extensions. [kashif] These functions maps directly into SQLite3 own enable_load_extension() and load_extension() C-API functions. See SQLite3::Database API documentation for details. This closes: Patches #9178

Bugfixes¶ ↑

• Corrected gem dependencies (runtime and development)

• Fixed threaded tests [Alexey Borzenkov]

• Removed GitHub gemspec

• Fixed “No definition for” warnings from RDoc

• Generate zip and tgz files for releases

• Added Luis Lavena as gem Author (maintainer)

• Prevent mkmf interfere with Mighty Snow Leopard

1.2.5 / 2009-07-25¶ ↑

• Check for illegal nil before executing SQL [Erik Veenstra]

• Switch to Hoe for gem task management and packaging.

• Advertise rake-compiler as development dependency.

• Build gem binaries for Windows.

• Improved Ruby 1.9 support compatibility.

• Taint returned values. Patch #20325.

• Database.open and Database.new now take an optional block [Gerrit Kaiser]

1.2.4.1 (internal) / 2009-07-05¶ ↑

• Check for illegal nil before executing SQL [Erik Veenstra]

• Switch to Hoe for gem task management and packaging.

• Advertise rake-compiler as development dependency.

• Build gem binaries for Windows.

• Improved Ruby 1.9 support compatibility.

1.2.4 / 2008-08-27¶ ↑

• Package the updated C file for source builds. [Jamis Buck]

1.2.3 / 2008-08-26¶ ↑

• Fix incorrect permissions on database.rb and translator.rb [Various]

• Avoid using Object#extend for greater speedups [Erik Veenstra]

• Ruby 1.9 compatibility tweaks for Array#zip [jimmy88@gmail.com]

• Fix linking against Ruby 1.8.5 [Rob Holland rob@inversepath.com]

1.2.2 / 2008-05-31¶ ↑

• Make the table_info method adjust the returned default value for the rows so that the sqlite3 change in 3.3.8 and greater can be handled transparently [Jamis Buck jamis@37signals.com]

• Ruby 1.9 compatibility tweaks [Roman Le Negrate roman2k@free.fr]

• Various performance enhancements [thanks Erik Veenstra]

• Correct busy_handler documentation [Rob Holland rob@inversepath.com]

• Use int_bind64 on Fixnum values larger than a 32bit C int can take. [Rob Holland rob@inversepath.com]

• Work around a quirk in SQLite’s error reporting by calling sqlite3_reset to produce a more informative error code upon a failure from sqlite3_step. [Rob Holland rob@inversepath.com]

• Various documentation, test, and style tweaks [Rob Holland rob@inversepath.com]

• Be more granular with time/data translation [Rob Holland rob@inversepath.com]

• Use Date directly for parsing rather than going via Time [Rob Holland rob@inversepath.com]

• Check for the rt library and fdatasync so we link against that when needed [Rob Holland rob@inversepath.com]

• Rename data structures to avoid collision on win32. based on patch by: Luis Lavena [Rob Holland rob@inversepath.com]

• Add test for defaults [Daniel Rodríguez Troitiño]

• Correctly unquote double-quoted pragma defaults [Łukasz Dargiewicz lukasz.dargiewicz@gmail.com]