|Pathologically Eclectic Rubbish Lister|
Re^3: Differences in SQL syntax when using DBI (are there any)? And help on publishing module on CPAN.by simonm (Vicar)
|on Jul 15, 2005 at 21:45 UTC||Need Help??|
There are a significant number of database-specific ideosyncracies both in SQL syntax and in driver functionality. A basic select-one-row-by-primary-key should be pretty close to universal, but as your application gets more complicated, more and more of these cases crop up. (For example, limits, joins, unions, sub-queries, blob fields, transactions, schema detection, triggers, procedures, and a dozen other things.)
A number of CPAN modules already address this issue. You could start with the items marked "Y" for Portability in my brief feature matrix of DBI wrappers.
Given how open-ended a task this is, I would encourage you to pool your efforts with other developers rather than building another mousetrap from scratch.
For example, if you think your interface is particularly nice, consider setting it up as an adaptor that drives an underlying layer like DBIx::SQLEngine. Or if there's some feature you need that the other engines lack, think about adding it as a patch.
Update: If you do decide to continue building your own solution, do at least take advantage of DBIx::AnyDBD, which handles automatically loading the necessary subclasses based on which DBI driver you're using.
If you think you'd like to press ahead, perhaps you could clarify why you think your module's strength or focus is going to be... What might some example code look like for the types of queries you support?
As a point of comparison, here's the DBIx::SQLEngine interface for the query types you've described -- in what ways is your module different?