3 DBIx::Class::Manual::FAQ - Frequently asked questions
7 =head2 What is the point of this module? Is it a fork of Class::DBI?
9 This is an alternative to L<Class::DBI>, intended to provide greater
10 functionality and simplicity.
12 It is inspired by the L<Class::DBI> framework, and meant to support
13 compability with it, while restructuring the internals and making it
14 possible to support some new features like self-joins, C<DISTINCT>,
15 C<GROUP BY>s and more.
17 =head2 What databases does it support?
19 At least MSSQL, MySQL, Oracle, PostgreSQL and SQLite.
21 =head2 What's the current status of this module?
23 This project is still at an early stage, so the maintainers don't make
24 any absolute promise that full backwards-compatibility will be
25 supported; however, if we can without compromising the improvements
26 we're trying to make, we will, and any non-compatible changes will
27 merit a full justification on the mailing list and a CPAN developer
28 release for people to test against.
30 =head2 Where can I go for support?
32 Mailing list: http://lists.rawmode.org/mailman/listinfo/dbix-class/
34 SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
36 Wiki: http://dbix-class.shadowcatsystems.co.uk/
38 IRC: irc.perl.org#dbix-class
40 =head2 Inflating your date/time columns
42 You can use L<DBIx::Class::InflateColumn> to automatically create
43 L<DateTime> objects from your date/time columns. For more information,
44 see L<DBIx::Class::InflateColumn>.
46 =head1 POSTGRESQL-SPECIFIC PROBLEMS
48 =head2 Can't get last insert ID; inserts with serial primary keys fail
50 Older L<DBI> and L<DBD::Pg> versions do not handle C<last_insert_id>
51 correctly, causing code that uses auto-incrementing primary key
52 columns to fail with a message such as:
54 Can't get last insert id at /.../DBIx/Class/Row.pm line 95
56 In particular the RHEL 4 and FC3 Linux distributions both ship with
57 combinations of L<DBI> and L<DBD::Pg> modules that do not work
60 L<DBI> version 1.50 and L<DBD::Pg> 1.43 are known to work.
66 =item L<DBIx::Class::Manual::Intro>