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.
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.
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.
Bugfixes
Abort on installation if sqlite3_backup_init is missing. Fixes #19
Gem has been renamed to 'sqlite3'. Please use `gem install sqlite3`
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.
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
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
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
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
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]
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.
Package the updated C file for source builds. [Jamis Buck]
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>]
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>]