BrentDax has asked for the wisdom of the Perl Monks concerning the following question:

I'm currently working on a DBIx module. I'm trying to write a decent test suite for it, but running into a fundamental problem: it's hard to find a good DBD that'll exist everywhere and support enough to test my module.

For testing, my module needs to be able to SELECT, INSERT, and DELETE in a three-column table. DBD::DBM only supports two columns, and DBD::Sponge would (as far as I can tell) require me to change my module's code, so neither is workable; DBI doesn't ship with any other DBDs built-in.

How should a DBI-related module be tested?

--Brent Dax
There is no sig.