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

On Wed, Feb 2, 2011 at 2:37 AM, Jeremy E. [email protected]
wrote:

Sequel is a lightweight database access toolkit for Ruby.

minor nit…

Installing ri documentation for sequel-3.20.0…
unable to convert “\x92” from ASCII-8BIT to UTF-8 for
doc/validations.rdoc, skipping
unable to convert “\x92” from ASCII-8BIT to UTF-8 for
doc/active_record.rdoc, skipping

thanks for sequel
best regards -botp

botp wrote in post #979014:

On Wed, Feb 2, 2011 at 2:37 AM, Jeremy E. [email protected]
wrote:

Sequel is a lightweight database access toolkit for Ruby.

minor nit…

Installing ri documentation for sequel-3.20.0…
unable to convert “\x92” from ASCII-8BIT to UTF-8 for
doc/validations.rdoc, skipping
unable to convert “\x92” from ASCII-8BIT to UTF-8 for
doc/active_record.rdoc, skipping

thanks for sequel
best regards -botp

Thanks for the heads up:

https://github.com/jeremyevans/sequel/commit/3f6d9daa61012c536047a35b53c39f0598747b4f
https://github.com/jeremyevans/sequel/commit/82af4846aeeb21bcbb617db1cc4aa526e82f0bb0

Jeremy

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs