Consider hair_trigger gem as way to use/implement db specific triggers
This hair_trigger
gem implements a nice DSL that allows defining triggers per database type, so we can specific triggers for mysql and specific ones for postgresql. The gem also hooks up into rake db:schema:dump
and adds create_schema
method to schema.rb
file, so we have full support for it.