Forum: Ruby ANN: Sequel 0.0.19 Released and Sequel discussion list

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.
Sharon R. (Guest)
on 2007-04-16 13:50
(Received via mailing list)
== 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 :posts
  column :title, :text
  column :category, :text
end

posts = DB[:posts]

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
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::Dataset#explain. Returns an array of opcode hashes.
* Specs for ConnectionPool.

== Sequel Discussion L.

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
This topic is locked and can not be replied to.