DBIx::Class::Manual::FAQ - Frequently asked questions
This is an alternative to Class::DBI, intended to provide greater functionality and simplicity.
It is inspired by the Class::DBI framework, and provides a compat layer to ease porting, but with a resultset-oriented, MI-based design that makes extension easier and allows us to support more complex relational operations like self-joins, DISTINCT, GROUP BYs and more.
DISTINCT
GROUP BY
At least MSSQL, MySQL, Oracle, PostgreSQL, SQLite and DB2.
This project is still at an early stage, so the maintainers don't make any absolute promise that full backwards-compatibility will be supported; however, if we can without compromising the improvements we're trying to make, we will, and any non-compatible changes will merit a full justification on the mailing list and a CPAN developer release for people to test against.
Mailing list: http://lists.rawmode.org/mailman/listinfo/dbix-class/ SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class
You can use DBIx::Class::InflateColumn to automatically create DateTime objects from your date/time columns. For more information, see DBIx::Class::InflateColumn.
Older DBI and DBD::Pg versions do not handle last_insert_id correctly, causing code that uses auto-incrementing primary key columns to fail with a message such as:
last_insert_id
Can't get last insert id at /.../DBIx/Class/Row.pm line 95
In particular the RHEL 4 and FC3 Linux distributions both ship with combinations of DBI and DBD::Pg modules that do not work correctly.
DBI version 1.50 and DBD::Pg 1.43 are known to work.
To install DBIx::Class, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class
CPAN shell
perl -MCPAN -e shell install DBIx::Class
For more information on module installation, please visit the detailed CPAN module installation guide.