Sequel 3.38.0

Developer: Website: License / Price: Platforms: Databases: Language: Last Updated: Category: Jeremy Evans | More scripts sequel.rubyforge.org MIT License  Windows / Linux / Mac OS / BSD / Solaris MySQL / PostgreSQL / Oracle Ruby August 6th, 2012, 17:58 GMT [view history] C: \ Database Tools

Sequel uses the concept of datasets to retrieve data.

A dataset object encapsulates an SQL query, letting the query fetch all the data by using a Ruby DSL.

Here are some key features of "Sequel":

· Sequel provides thread safety, connection pooling and a concise DSL for constructing database queries and table schemas.
· Sequel also includes a lightweight but comprehensive ORM layer for mapping records to Ruby objects and handling associated records.
· Sequel supports advanced database features such as prepared statements, bound variables, stored procedures, master/slave configurations, and database sharding.
· Sequel makes it easy to deal with multiple records.
· Sequel currently has adapters for ADO, Amalgalite, DataObjects, DB2, DBI, Firebird, Informix, JDBC, MySQL, ODBC, OpenBase, Oracle, PostgreSQL and SQLite3.

What's New in This Release: [ read full changelog ]

· Sequel now recognizes the double(x, y) and double(x, y) unsigned MySQL types.
· The swift subadapters now require swift-db-* instead of swift itself.
· Add :textsize option to tinytds adapter to override the default TEXTSIZE.
· Support an output identifier method in the swift adapter.
· Add Model#to_hash as an alias to Model#values.
· When loading multiple pg_* extensions via Database#extension, only reset the conversion procs once.
· Don't allow model typecasting from string to postgres array, hstore, or composite types.
· Add pg_typecast_on_load plugin for converting advanced PostgreSQL types on load the {jdbc,do,swift}/postgres adapters.
· Make all adapters that connect to PostgreSQL store type conversion procs.
· Add type oid to column schema on PostgreSQL.

Via: Sequel 3.38.0