in reply to Considering future support for different databases.

First off, use DBIx::Class (or Rose::DB). An ORM solves most of the issues because the maintainers work really really hard to make sure it's DB-independent. While there are dozens of ORMs on CPAN, DBIC and Rose are the best two, imho. Jifty, Alzabo, and Tangram are written by good devs, but they don't have the team support that DBIC does or the single-minded insanity that the author of Rose has.

Second, use a phrasebook for the stuff you absolutely have to hand-write SQL for. There's several on CPAN and one of the better ones was recommended already.

My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
  • Comment on Re: Considering future support for different databases.

Replies are listed 'Best First'.
Re^2: Considering future support for different databases.
by Cap'n Steve (Friar) on Aug 15, 2008 at 20:37 UTC
    Thanks for the suggestions. I'd actually never heard of ORM or a phrasebook before, but it sounds like a good thing to learn about.
[reply]
      I also recommend using DBIx::Class - it is the most modern, robust Perl ORM available and was designed with this in mind.
[reply]

In Section Seekers of Perl Wisdom