From: "Florian Aßmann" <florian.assmann@...>
Date: 2007-07-23T17:44:41+09:00
Subject: Re: ANN: Sequel 0.1.9 Released

Thanks again Sharon,

nice piece of work...

Florian

Sharon Rosner schrieb:
> 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
> 
> 
>