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
= 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:
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.