From: Sharon Rosner Date: 2007-05-26T02:17:59+09:00 Subject: ANN: Sequel 0.1.4 Released - ODBC adapter and more 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: Join the Sequel-talk group: 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