About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 6 years ago
  • Total downloads: 88
  • Price: Free |
  • Operating system: Linux, Mac OS X, Win All, BSD, Solaris
  • Publisher: Jeremy Evans (5 other programs)
See full specifications

scripts default iconSequel Publisher's description

This is a lightweight database access toolkit for Ruby

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:

В· Add Dataset #set_defaults and #set_overrides, used for scoping the values used in insert/update statements
В· Allow Models to use the RETURNING clause when inserting records on PostgreSQL
В· Raise Sequel::DatabaseError instead of generic Sequel::Error for database errors, don't swallow tracebacks
В· Use INSERT ... RETURNING ... with PostgreSQL 8.2 and higher
В· Make insert_sql, delete_sql, and update_sql respect the :sql option
В· Default to converting 2 digit years, use Sequel.convert_two_digit_years = false to get back the old behavior
В· Make the PostgreSQL adapter with the pg driver use async_exec, so it doesn't block the entire interpreter
В· Make the schema generators support composite primary and foreign keys and unique constraints
В· Work with the 2008.08.17 version of the pg gem
В· Disallow abuse of SQL function syntax for types (use :type=>:varchar, :size=>255 instead of :type=>:varchar[255])
В· Quote index names when creating or dropping indexes
В· Don't have column accessor methods override plugin instance methods
В· Allow validation of multiple attributes at once, with built in support for uniqueness checking of multiple columns
В· In PostgreSQL adapter, fix inserting a row with a primary key value inside a transaction
В· Allow before_save and before_update to affect the columns saved by save_changes
В· Make Dataset#single_value work when graphing, which fixes count and paginate on graphed datasets

System Requirements:

Program Release Status:
Program Install Support: Install Only

Is Sequel your software?

Manage your software

Most Popular

scripts default icon Facebook comments counter (Scripts) 1.0
This This plugin is addon plugin to the plugin "Facebook Comments for WordPress".
scripts default icon Net::Flickr (Scripts) 0.0.1
Net::Flickr provides an elegant, Ruby-fied implementation of Flickr's REST API.
scripts default icon Lipsiadmin (Scripts) REL 5.1.2
Lipsiadmin is a new revolutionary admin for your projects.
scripts default icon QuNet::NNTP Client Library (Scripts) 0.0.2
Retrieve and post Usenet news articles via NNTP, the Network News Transfer Protocol
scripts default icon LED Sign Manager (Scripts) Angie
A Ruby On Rails web application for the management of Betabrite and Alpha LED signs.