Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Ruby > ANN: Sequel 0.0.19 Released and Sequel discussion list

Thread Tools

ANN: Sequel 0.0.19 Released and Sequel discussion list

Sharon Rosner
Posts: n/a
== 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 = 'sqlite:/:memory:'

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

posts = DB[osts]

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

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

== Installing Sequel

sudo gem install sequel

You can also check out the trunk and install locally:

svn co 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:

== Sequel RDoc

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ANN: Sequel 0.1.4 Released - ODBC adapter and more Sharon Rosner Ruby 1 05-25-2007 07:45 PM
ANN: Sequel 0.1.3 Released - now with DBI support! Sharon Rosner Ruby 0 05-20-2007 11:33 AM
ANN: Sequel 0.1.2 Released Sharon Rosner Ruby 0 05-19-2007 01:08 PM
ANN: Sequel 0.1.0 Released Sharon Rosner Ruby 0 04-22-2007 07:20 PM
ANN: Sequel 0.0.20 Released Sharon Rosner Ruby 0 04-18-2007 08:57 PM