=== 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 ] === 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 ] * Ruby 1.9 compatibility tweaks [Roman Le Negrate ] * Various performance enhancements [thanks Erik Veenstra] * Correct busy_handler documentation [Rob Holland ] * Use int_bind64 on Fixnum values larger than a 32bit C int can take. [Rob Holland ] * 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 ] * Various documentation, test, and style tweaks [Rob Holland ] * Be more granular with time/data translation [Rob Holland ] * Use Date directly for parsing rather than going via Time [Rob Holland ] * Check for the rt library and fdatasync so we link against that when needed [Rob Holland ] * Rename data structures to avoid collision on win32. based on patch by: Luis Lavena [Rob Holland ] * Add test for defaults [Daniel Rodríguez Troitiño] * Correctly unquote double-quoted pragma defaults [Łukasz Dargiewicz ]