SQL-DB

Supports any database system running the SQL language.

Features:

• connect() to the database
• deploy() the schema (CREATE TABLEs etc)
• Using one or more "abstract rows" obtained via arow() the developer can do() insert, update or delete queries.
• Using one or more "abstract rows" obtained via arow() he can fetch() (select) data to work with (and possibly modify).
• Repeat the above three steps as needed. Further queries (with a higher level of automation) are possible with the objects returned by fetch().
• disconnect() from the database.

What is new in this release:

• SQL::DB::Schema::Expr: New concat() method for SQL '||'.
• New introspection method: $db->table($table)->ref_by.
• Identify which tables have foreign keys pointing to another table.
• SQL::DB::Schema::ARow: New _join_columns method.
• SQL::DB::Schema::Table - First version of trigger support.

Limitations:

• SQL-DB is not an ORM system.