[Dbix-class] Q: Foreign keys

[Peter Rabbitson]

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 :)