Hello,
I'm working on a database package right now that will support
multiple backend drivers (currently just DBD::Pg and DBD::mysql, possibly
more in the future). With MySQL, you can only support transactions and
foreign keys if you have enabled the InnoDB database backend. This would
undoubtedly mean that you would want to use a different database schema
depending on whether InnoDB is available.
Is there a clean way to detect whether InnoDB support is available
on the MySQL server? The best I've been able to come up with so far, is
attempting to create a temporary table with the "TYPE=InnoDB" argument and
testing to see if it fails, but if there is just some flag I can query the
database with I would much rather use that.
Thanks in advance,
Tyler
