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 ]
· Don't fail for missing conversion proc in pg_typecast_on_load plugin
· Rename PGRangeOp #starts_before and #ends_after to #ends_before and #starts_after
· Add Database#supports_schema_parsing? for checking for schema parsing support
· Handle hstore types on PostgreSQL if using pg_array and pg_hstore extensions
· Don't reset conversion procs when loading pg_* extensions
· Handle domain types when parsing the schema on PostgreSQL
· Handle domain types in composite types in the pg_row extension