# ANN: Sequel 0.1.9 Released

**URL:** <https://www.ruby-forum.com/t/ann-sequel-0-1-9-released/110041>\
**Category:** Ruby\
**Created:** [July 21, 2007, 9:47pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-9-released/110041 "2007-07-21T21:47:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [July 21, 2007, 9:47pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-9-released/110041/1 "2007-07-21T21:47:24Z")

</div>

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 G. 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](http://sequel.rubyforge.org)

Join the Sequel-talk group:  
[http://groups.google.com/group/sequel-talk](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](http://ruby-sequel.googlecode.com/svn/trunk) sequel  
cd sequel  
rake install

---

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [July 23, 2007, 10:45am UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-9-released/110041/2 "2007-07-23T10:45:12Z")

</div>

Thanks again Sharon,

nice piece of work…

Florian

Sharon R. schrieb: