Supports any database system running the SQL language.
Here are some key features of "SQL-DB":
· 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.
Limitations:
· SQL-DB is not an ORM system.
What's New in This Release: [ read full changelog ]
· 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.
Find us on Google+
