On 09/24/2002 11:15 AM, Joshua E Minnie wrote:
> I was reading an article at PHPBuilder.com (not very recent, 01/15/2001)
> about PEAR DB, and was wondering if anyone had any experience using PEAR
> rather than the functions dedicated specifically to each type of DB (i.e.
> mysql_, mssql_, pg_, msql_, etc.). Also, if anyone has any reasons why to
> go with one or the other.
> The reason I ask, is because I recently downloaded QuerySim so I could
> simulate my db info while the db is still in development and not have to
> slow down the process. QuerySim uses PEAR DB functions, and after the db
> development is finished it is an easy conversion. Simply change the line
> that tells which db is being accessed.
> [code snippet]
> $db = DB::connect( "mssql://$dbuser:$dbpass@$dbhost/$dbname" ); // for MSSQL
> $db = DB::connect( "mysql://$dbuser:$dbpass@$dbhost/$dbname" ); // for MySQL
> //instead of
> $conn = DB::connect('querysim');
> [/code snippet]
> And my querys would still remain relatively the same. I hope you can shed
> some light on this because I am not really sure which one to use.
No PEAR-DB does not guarantee true database portability. Among other
things, think about for instance date and time fields that are formatted
differently between databases. PEAR-DB does not assure that you only
deal with a single format, so you would always have to handle eventual
differences in format representation in your application which is what
you want to avoid.
If you are looking for true database portability, you may want to look
at Metabase which is a much more mature database abstraction package
that not only deals with data type representation format differences to
make your database applications really portable, but it also manages
your database schemas so you don't have to write database specific SQL
scripts to create tables and other database objects.
All you need to do is to specify a schema in a database independent
format based on XML and Metabase creates any tables, fields, indexes,
sequences for you.
Metabase is Open Source and you may find it here:
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php