Bernhard Graf wrote: > Hiya list, > > if I want to develop an application in a way, that it runs on the three > major open source databases (MySQL, Postgres, SQLite), what is the ideal > way to handle relational integrity? SQLite doesn't handle foreign keys, > but from the docs I see DBIC has something called "cascade triggers" ... > can I enable this feature exlusively for the SQLite storage engine? >
DBD::SQLite has complete support for foreign keys starting from 1.27. SQL::Translator does not currently produce constraint DDL, so DBIC's deploy() will not work as intended but patches are always welcome :) _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
