As part of my DBIx::SQLEngine distribution, I've put together a brief document that lists some of the other DBI wrapper modules and highlights a few broad categories of features. I was aiming for something broader and more shallow than the Poop Group comparison, reviewing more modules but going into less depth.
I've tried to populate this list with modules I've seen others discuss, as well as some I just found on CPAN, but for the many modules I haven't used, I've simply based my evaluation on a few minutes reading the documentation.
Could those of my fellow monks who use one of these modules take a moment to check whether I've classified it appropriately, or let me know if I've omitted something useful in this DBI wrapper/assistant arena?
I examined each module to see if it had the following features:
| DBI Wrapper: || Does the module maintain a connection to DBI handle?
| One Call Query: || Does it provide combined prepare/fetch/finish methods?
|Data-driven SQL: || Does it generate SQL queries from DWIM-ish data structures?
| Schema Access: || Does it detect or create tables and other structures?
| Named Configs: || Does it handle a library of named queries or connection parameters?
| Portability: || Does it provide a consistent interface that hides idiomatic DBMS implementations?
| Object Mapping: || Does it provide classes to treat rows of data as objects?
I know that just counting tick marks doesn't tell you which module is better, but I found it helpful to see which modules had related functionality; for example, I think I had previously overlooked DBIx::SearchProfiles because I didn't realize what it did.
I typically didn't evaluate whether or not the implementation looked like it was high-kwalitee or not, but I would be interested in feedback on this aspect as well.