From: Jeremy Evans Date: 2011-02-02T03:37:00+09:00 Subject: ANN: Sequel 3.20.0 Released Sequel is a lightweight database access toolkit for Ruby. * Sequel provides thread safety, connection pooling and a concise DSL for constructing SQL queries and table schemas. * Sequel includes a comprehensive ORM layer for mapping records to Ruby objects and handling associated records. * Sequel supports advanced database features such as prepared statements, bound variables, stored procedures, savepoints, two-phase commit, transaction isolation, master/slave configurations, and database sharding. * Sequel currently has adapters for ADO, Amalgalite, DataObjects, DB2, DBI, Firebird, Informix, JDBC, MySQL, Mysql2, ODBC, OpenBase, Oracle, PostgreSQL, SQLite3, and Swift. Sequel 3.20.0 has been released and should be available on the gem mirrors. = New Features * The swift adapter now supports an SQLite subadapter. Use the :db_type => 'sqlite' option when connecting. You can use an in memory database with the following connection string: swift:///?database=:memory:&db_type=sqlite * Arbitrary JDBC properties can now be set in the JDBC adapter using the :jdbc_properties option when connecting. The value of this option should be a hash where keys and values are JDBC property keys and values. * Basic Microsoft Access support was added to the ado adapter. The creation of autoincrementing primary key integers now works, and identifiers are now quoted with []. * The Database#indexes method now supports a :partial option when connecting to MySQL, which makes it include partial indexes (which are usually excluded). = Other Improvements * The class_table_inheritance plugin now handles subclass associations better. Previously, the implicit eager loading code had issues when you called an association method that only existed in the subclass. * The error message used when a validates_max_length validation is applied to a nil column value has been improved. You can override the message yourself using the :nil_message option. * The read_timeout and connect_timeout options now work correctly in the mysql adapter. * Another MySQL disconnect error message is now recognized. = Backwards Compatibility * The swift adapter was upgraded to support swift 0.8.1. Older versions of swift are no longer supported. Thanks, Jeremy * {Website}[http://sequel.rubyforge.org] * {Source code}[http://github.com/jeremyevans/sequel] * {Blog}[http://sequel.heroku.com] * {Bug tracking}[http://code.google.com/p/ruby-sequel/issues/list] * {Google group}[http://groups.google.com/group/sequel-talk] * {RDoc}[http://sequel.rubyforge.org/rdoc] -- Posted via http://www.ruby-forum.com/.