New Features
- An mssql_optimistic_locking plugin has been added. This is similar to the
regular optimistic_locking plugin, but instead of using an integer lock
column, it uses a timestamp/rowversion lock column.
- Database#create_table with the :temp=>true option on PostgreSQL now
supports an :on_commit option. This option can be set to :drop or
:delete_rows to either drop or empty the temporary table on transaction
commit.
Other Improvements
- Dataset#insert no longer errors on PostgreSQL if the related table is a
placeholder literal string.
- Unique constraints are now copied when emulating alter_table operations on
SQLite.
- Clob column values are no longer returned as SQL::Blob instances by the db2
and ibmdb adapters unless use_clob_as_blob is true.
- SQL::Blob objects now work correctly as prepared statement arguments in the
jdbc/db2 adapter if use_clob_as_blob is false.
Backwards Compatibility
- The Model.primary_key array for models with composite keys is now frozen.
- On DB2, use_clob_as_blob now defaults to false instead of true.
- Sequel no longer uses RubyForge.
The Sequel website is now
located at sequel.jeremyevans.net.