[ILUG] MySQL vs PostgreSQL

[Donncha O Caoimh]

kevin lyda wrote:
> 
> On Mon, Nov 13, 2000 at 11:20:24AM +0000, Donncha O Caoimh wrote:
> > http://www.phpbuilder.com/columns/tim20001112.php3
> >
> > He comes down in favour of PostgreSQL in a big way. Although not
> > conclusive (he didn't list the queries he performed, what size each
> > table was, or the size of machines used in the test) it might be worth
> > throwing a PostgreSQL RPM on a machine to test..
> 
> i'm looking at postgresql as well because of mysql's table size
> limitations.  the biggest issue i see: php3 w/o phplib has differend db
> access api's for each db and you are limited to a single db connection
> per script.  (yes?)

No, just create a new instance of another database class.. To paraphrase
something I wrote on phpbuilder.com
(http://www.phpbuilder.com/annotate/message.php3?id=1001589)
"..extend the DB_sql class (which prepend.php3 sets up to use MySQL) and
just change the database/user/password to point at a completely
different database, which might reside on a different machine! 
Then all I have to do is: 

$w1 = new DB_www1; 
$w2 = new DB_www2; 
$ds = new DataServer; 

and access the data stored in those databases. 
If I'm writing new classes, I just extend from the source database I
want and that class gets a connection to that database. "

Donncha.