Re: [PHP] database abstraction layer

[email protected] (Lester Caine)
Newsgroups php.general
Message-ID <[email protected]>
Lars Nielsen wrote:
> Hi List
> 
> I am trying to make a Database Abstraction Layer so I can which the DB
> of my application between MySQL and Postgresql. I have been looking at
> the way phpBB does it, and it seems that it is only then php-functions
> which are different. The SQL seems to be the same.
> 
> Is it save to assume that I can use the same SQL, or should i make some
> exceptions?

Simple SQL is almost identical. But there are many of the more advanced 
functions that have major differences. Check out ADOdb for an existing 
abstraction layer that handles a lot of them.
http://adodb.sourceforge.net/

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.