ANN: Sequel 0.0.19 Released and Sequel discussion list

[Sharon Rosner]

== Sequel 0.0.19 Released

Sequel: Concise ORM for Ruby. Sequel provides thread safety,
connection pooling and a concise DSL for constructing database queries
and table schemas. Version 0.0.19 fixes a bunch of minor bugs has
improved code coverage (rcov reports 74.5% coverage!)

Sequel currently supports SQLite, PostgreSQL and MySQL databases.

== Sequel by Example

require 'sequel/sqlite'
DB = Sequel.open 'sqlite:/:memory:'

DB.create_table osts
column :title, :text
column :category, :text
end

posts = DB[osts]

posts << {:title => 'first', :category => 'ruby'}
posts << {:title => 'second', :category => 'orm'}

posts.count #=> 2
posts.sql #=> 'SELECT * FROM posts'
posts.filtercategory => 'orm').count #=> 1
posts.filtercategory => 'orm').sql #=> "SELECT * FROM posts WHERE
(category = 'orm')"
posts.ordercategory).print # pretty-prints the table ordered by
category

== Installing Sequel

sudo gem install sequel

You can also check out the trunk and install locally:

svn co http://ruby-sequel.googlecode.com/svn/trunk sequel
cd sequel
rake install

== Changes in 0.0.19

* More specs for Dataset.
* Fixed Dataset#invert_order to work correctly with strings.
* Fixed Model#== to check equality of values.
* Added Model#exclude and Model#order.
* Fixed Dataset#order and Dataset#group to behave correctly when
supplied with qualified field name symbols.
* Removed Database#literal. Shouldn't have been there.
* Added SQLite:ataset#explain. Returns an array of opcode hashes.
* Specs for ConnectionPool.

== Sequel Discussion List

I've created a google group dedicated to Sequel. Youcan find it here:
http://groups.google.com/group/sequel-talk

== Sequel RDoc

http://sequel.rubyforge.org