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
"..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. "
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!