http://qs321.pair.com?node_id=621428


in reply to MySQL, MS SQL, PostgreSQL - Common interface

Well, I'd say if you're going to abstract from SQL up, abstract the whole way to an OO-View where you don't use SQL itself anymore - but if you are determined to write such a module - which could be very useful indeed - I suggest to take a look at the SQLFairy (SQL::Translator) - they have done such a thing already - you could use SQL::Translator on-the-fly, or at least prey upon it to reuse their effort.

regards,
tomte


An intellectual is someone whose mind watches itself.
-- Albert Camus

  • Comment on Re: MySQL, MS SQL, PostgreSQL - Common interface

Replies are listed 'Best First'.
Re^2: MySQL, MS SQL, PostgreSQL - Common interface
by Jenda (Abbot) on Jun 15, 2007 at 14:09 UTC
    I'd say if you're going to abstract from SQL up, abstract the whole way to an OO-View where you don't use SQL itself anymore ...

    I could never understand why would anyone want to do that, but that's just me.