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