sqlite3-ruby

URL: http://sqlite-ruby.rubyforge.org/sqlite3
Author(s): Jamis Buck
Summary: SQLite3/Ruby is a module to allow Ruby scripts to interface with a SQLite database.

Comments

sqlite3-ruby (1.3.1) is Working
for Rajinder Yadav (GNU/Linux, about 1 year ago)

sqlite3-ruby (1.2.5) is Failing
for -jul- (GNU/Linux, over 2 years ago)

The current implementation creates ASCII-8BIT strings out of database code, while sqlite3's connection charset is utf-8 (or utf-16). Therefore it's very hard to integrate it into a multilingual environment.

sqlite3-ruby (1.2.5) is Working
for Andryusha (Mac OSX, over 2 years ago)

sqlite3-ruby (1.2.5) is Working
for Cloves Carneiro Jr (Mac OSX, over 2 years ago)

sqlite3-ruby (1.2.5) is Working
for german_in_the_town (GNU/Linux, over 2 years ago)

works on ubuntu 8.10
ruby 1.9.2dev release 1

sqlite3-ruby (1.2.5) is Working
for Jones Lee (GNU/Linux, over 2 years ago)

On Ubuntu 9.04, Rails 2.3.3, it just works perfectly.

sqlite3-ruby (1.9.1 p243) is Working
for Felipe Rodrigues (GNU/Linux, over 2 years ago)

At Ubuntu 9.0.4

sqlite3-ruby (1.2.4) is Failing
for SCHAEFER Erwin (GNU/Linux, over 2 years ago)

(on ruby 1.9.1p129, compiled on Fedora 8)
db.transaction does not work (SQLite3::SQLException: near "deferred": syntax error)
Also, performing a SQLite3::Database.new takes up to 5 seconds, even on an empty database (very fast with ruby 1.8.6p287)

sqlite3-ruby (1.2.4) is Working
for Anthony Lauzon (GNU/Linux, over 2 years ago)

sqlite3-ruby (1.2.4) is Working
for Marcus Wyatt (Mac OSX, over 2 years ago)

Installed without any issues on os x.

sqlite3-ruby (1.2.3) is Failing
for Joel Dezenzio (Windows, over 2 years ago)

Using Ruby 1.9.1 p129 compiled w/ming on Windows Vista. Gem installs OK but I receive "unable to locate the driver". sqlite3.exe and .dlls are all located in Windows;Windows\System32;Ruby\bin

sqlite3-ruby (1.2.4) is Failing
for Trevor Wennblom (GNU/Linux, over 2 years ago)

uses deprecated STR2CSTR which is no longer defined in Ruby 1.9, need to replace instances of 'STR2CSTR' with 'StringValuePtr'.

see
http://rubyforge.org/tracker/index.php?func=detail&aid=25905&group_id=254&atid=1043

sqlite3-ruby (1.2.4) is Working
for nofxx (GNU/Linux, over 2 years ago)

sqlite3-ruby (1.2.6) is Working
for Andrew Clink (Mac OSX, over 2 years ago)

Using Qoobaa's fork:

http://github.com/qoobaa/sqlite3-ruby/tree/master

1.2.4 returns ASCII-8BIT encoded strings regaurdless of the encoding of the database.

sqlite3-ruby (1.2.4) is Working
for kates (GNU/Linux, over 2 years ago)

Works on ubuntu 9.04 with ruby 1.9.1p129

you will need to apt-get install libsqlite3-dev

sqlite3-ruby (1.2.4) is Working
for Evil Trout (Mac OSX, over 2 years ago)

sqlite3-ruby (1.2.3) is Working
for vtypal (Windows, over 2 years ago)

sqlite3-ruby on Win32 platforms works fine but only with version 1.2.3 (this applies also for Ruby 1.8)

$ gem install sqlite3-ruby -v 1.2.3

sqlite3-ruby (1.2.4) is Failing
for shunie (GNU/Linux, over 2 years ago)

Using passenger / modrails:

symbol lookup error: /usr/local/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.2.4/lib/sqlite3_api.so: undefined symbol: STR2CSTR

ruby 1.9.2dev (2009-05-05 trunk 23348) [x86_64-linux]

Ubuntu 9.04 / jaunty

sqlite3-ruby (1.2.4) is Failing
for Andreas Haller (Mac OSX, over 2 years ago)

same as Thomas Preymesser

sqlite3-ruby (1.2.4) is Working
for Pistos (GNU/Linux, over 2 years ago)

Works for me as tested with DBI's test suite.

sqlite3-ruby (1.2.4) is Working
for Vidmantas (GNU/Linux, over 2 years ago)

Seems OK in simple usage but one test fails:

1) Failure:
test_busy_handler_impatient(Integration::TC_Database_Native)
[/home/vidmantas/tmp/sqlite3-ruby/test/tc_integration.rb:585:in `block (3 levels) in <module:Integration>'
/usr/lib/ruby19/gems/1.9.1/gems/mocha-0.9.5/lib/mocha/test_case_adapter.rb:69:in `run']:
<SQLite3::BusyException> exception expected but none was thrown.

(Mocha is reported as 1.9.1 compatible)

sqlite3-ruby (1.2.4) is Working
for janfri (GNU/Linux, over 2 years ago)

sqlite3-ruby (1.2.4) is Failing
for Nick Barlow (Windows, over 2 years ago)

sqlite3-ruby (1.2.4) is Failing
for Thomas Preymesser (GNU/Linux, over 2 years ago)

at runtime i get this error:
ruby: symbol lookup error: /usr/local/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.2.4/lib/sqlite3_api.so: undefined symbol: STR2CSTR