Forum: Ruby ANN: Sequel 0.1.9 Released

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
6d21f1858dda3716c76cd2a7f92ca08f?d=identicon&s=25 Sharon Rosner (ciconia)
on 2007-07-21 21:47
(Received via mailing list)
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
Ee469623eb1b8e6e35d192822b9c4aa2?d=identicon&s=25 Florian Aßmann (Guest)
on 2007-07-23 10:45
(Received via mailing list)
Thanks again Sharon,

nice piece of work...

Florian

Sharon Rosner schrieb:
This topic is locked and can not be replied to.