Re: Database/DBD Bridging?

On Tue, Oct 04, 2011 at 02:20:10PM +0200, Reinier Post wrote:
> On Fri, Sep 23, 2011 at 11:19:32PM -0400, Brendan Byrd wrote:
> 
> For a start it would be nice to have a matrix up somewhere listing
> DBMSes against SQL constructs, so I can look up, for instance, against
> which types of DBD backends which SQL syntax will actually work

A quick google turned up http://www.grantondata.com/community/dbrosettastone.html
There may well be others/better/newer.

> For instance, I have a simple script that needs to count the number of
> distinct values in columns.  This seems like a pretty elementary thing
> to do, but after a lot of tweaking and tinkering I've found that
> 
>   - SELECT COUNT(DISTINCT) ... is invalid in Jet (Access MDB)
>   - SELECT COUNT(*) FROM (SELECT DISTINCT ...)) is invalid elsewhere
>   - SELECT DISTINCT ... is accepted but just does SELECT in DBD::CSV

A good ORM, like DBIx::Class, will handle most differences in SQL dialects
for you, and give you a way to include fragments of literal SQL if you
need to.

Tim.