ANN: Sequel 0.1.9 Released

S

Sharon Rosner

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,263
Messages
2,571,312
Members
47,987
Latest member
Gaurav

Latest Threads

Top