ANN: Sequel 0.4.1 Released

Sequel version 0.4.1 has just been released. This release includes
error-handling in worker threads, support for DISTINCT ON clauses,
better support for database access using DBI and automatic adapter
loading.

Sequel is a lightweight ORM library for Ruby. Sequel provides thread
safety, connection pooling and a simple and expressive API for
constructing database queries and table schemas.

=== Changes in this release

  • Improved error-handling for worker threads. Errors are saved to an
    array and are accessible through #errors (#91).

    w = Sequel::Worker.new
    w.add {raise “blah blah”}
    w.join
    w.errors.first.message #=> “blah blah”

  • Dataset#uniq/distinct can now accept a column list for DISTINCT ON
    clauses.

    DB[:items].distinct(:category, price).sql
    #=> “SELECT DISTINCT ON (category, price) * FROM items”

  • Added support for dbi-xxx URI schemes (#86).

    DB = Sequel.open ‘dbi-pg://localhost/mydb’

  • Put adapter files in lib/sequel/adapters. Requiring sequel/
    is now deprecated. Users can now just require ‘sequel’ and adapters
    are automagically loaded (#93).

  • Reorganized lib directory structure.

  • Fixed problem in Database#uri where setting the password would raise
    an error (#87).

  • Improved Dataset#insert_sql to correctly handle string keys (#92).

  • Fixed Model.all.

  • Fixed literalization of strings with escape sequences in postgres
    adapter (#90).

  • Added support for literalizing BigDecimal values (#89).

  • Fixed column qualification for joined datasets (thanks Christian).

  • Implemented experimental informix adapter.

=== More info

Sequel project page:
http://code.google.com/p/ruby-sequel

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

On Nov 26, 2007 2:37 PM, Sharon R. [email protected] wrote:

adapter (#90).

  • Added support for literalizing BigDecimal values (#89).

  • Fixed column qualification for joined datasets (thanks Christian).

  • Implemented experimental informix adapter.

Thanks Sharon. I’ll give this a try and let you know.

I just wonder why the gem requires hoe.