# ANN: Sequel 0.1.4 Released - ODBC adapter and more

**URL:** <https://www.ruby-forum.com/t/ann-sequel-0-1-4-released-odbc-adapter-and-more/105098>\
**Category:** Ruby\
**Created:** [May 25, 2007, 7:18pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-4-released-odbc-adapter-and-more/105098 "2007-05-25T19:18:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [May 25, 2007, 7:18pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-4-released-odbc-adapter-and-more/105098/1 "2007-05-25T19:18:24Z")

</div>

Sequel version 0.1.4 has just been released. This release adds an ODBC  
adapter, handling of multi-line SQL statements and improvements to the  
schema DSL.

## ODBC adapter

Sequel now includes an ODBC adapter which uses the odbc gem directly.

require ‘sequel/odbc’  
DB = Sequel.open ‘odbc:/my\_dsn’

# etc…

## Multi-line SQL statements

Database#\<\< can now accept strings and arrays of strings containing  
multiple SQL statements, line breaks and comments, making it easy to  
work with schema files and database dump files. e.g.:

DB \<\< IO.read(‘schema’)

You can also split a string into separate SQL statements (also  
stripped of comments and line breaks):

IO.read(‘schema’).split\_sql #=\> array of statements

## Improvements to Schema DSL

The schema generator DSL is improved to support data types as methods,  
so instead of writing:

DB.create\_table :items do  
column :name, :text  
column :price, :decimal  
end

You can now write:

DB.create\_table :items do  
text :name  
decimal :price  
end

======================

Sequel documentation:  
[http://sequel.rubyforge.org](http://sequel.rubyforge.org)

Join the Sequel-talk group:  
[http://groups.google.com/group/sequel-talk](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](http://ruby-sequel.googlecode.com/svn/trunk) sequel  
cd sequel  
rake install

---

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [May 25, 2007, 9:46pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-4-released-odbc-adapter-and-more/105098/2 "2007-05-25T21:46:40Z")

</div>

On 5/25/07, Sharon R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Sequel version 0.1.4 has just been released. This release adds an ODBC  
> adapter, handling of multi-line SQL statements and improvements to the  
> schema DSL.

Nice work Sharon! I’ll try wrapping this with a Ruport plugin soon. 🙂