> Sequel version 0.1.9 has just been released. This release contains a
> much improved MySQL adapter, a new single-threaded database feature
> and a few bug fixes.

> Following is a discussion of the main changes:

> Improved MySQL adapter
> ======================

> The MySQL adapter has been extensively rewritten to make it more solid
> and useful. Here is a breakdown of the changes:

> * Column values are now cast correctly according to the column types.
> * Fields are quoted using back-ticks.
> * Support for boolean literals.
> * Transactions work.
> * Added support for ORDER and LIMIT clauses in UPDATE statements.
> * Improved performance.

> Many thanks to Aman Gupta for his attention to details.

> Single-threaded database mode
> =============================

> By default Sequel provides a connection-pool for each open database,
> allowing to write multi-threaded applications without having to worry
> about managing and synchronizing database access. The Sequel
> connection pool does, however, invoke some performance penalty.

> The latest release of Sequel offers much improved performance for
> single-threaded applications with a single-threaded mode.

> Single-threaded mode can be set globally:

>   Sequel::Database.single_threaded = true

> Or for specific databases:

>   Sequel.open 'sqlite:/', :single_threaded => true

> I have not done any extensive benchmarking, but it seems you can
> easily get 10-20% better performance in single-threaded mode. Would
> anyone be interested in measuring this?

> Miscellaneous
> =============

> * Added parens around postgres LIKE expressions using regexps.

> * Fixed bug in Dataset#format_eq_expression where Range objects would
> not be literalized correctly.

> * Wrote specs for SQLite and MySQL adapters.

> ================================

> Sequel documentation:
>   <http://sequel.rubyforge.org>

> Join the Sequel-talk group:
>   <http://groups.google.com/group/sequel-talk>

> Install the gem:
>   sudo gem install sequel

> Or check out the source and install manually:
>   svn co http://ruby-sequel.googlecode.com/svn/trunk sequel
>   cd sequel
>   rake install