I've been slowly converting ESP over to us the ADODB[1] library
targeting mysql, postgres and sqlite as supported DB's.
I had hoped that adodb would provide enough DB abstraction that it would
be possible to do the port just by replacing the native php mysql
functions and SQL bits, with adodb equivalents. I have approximately
99% working in mysql, 70% sqlite, 10% postgres and it appears that to
get all the DB's working I will need to replace all/most SQL calls with
a function that implements a switch based on the current DB and returns
SQL appropriate for it. So my question is.. does this sound like the
path I should take? Other suggestions?
[1] http://php.weblogs.com/ADODB
--
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|
