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 ]
· Correctly handle parsing schema for tables in other databases on MySQL.
· Added DSL support for the modulus operator (%), similar to the bitwise operators.
· Fixed possible thread-safety issues on non-GVL ruby implementations.
· Allow truncation of multiple tables at the same time on PostgreSQL.
· Allow truncate to take a :cascade, :only, and :restart options on PostgreSQL.
· Allow json and xml serializers to support :array option in class to_json method to serialize existing array of model instances.
· Added dirty plugin, which saves the initial value of the column when the value is changed.
Find us on Google+
