1.4.2¶ ↑

• 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¶ ↑

• Enancements

  • 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 conditionaly 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 / 25 Jul 2009¶ ↑

• 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) / 5 Jul 2009¶ ↑

• 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 / 27 Aug 2008¶ ↑

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

1.2.3 / 26 Aug 2008¶ ↑

• 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 / 31 May 2008¶ ↑

• 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>]