RE: [PHP-DB] 'Best' DB for Linux/Apache/PHP? From: Anthony Martin (Anthony <email protected>)
Date: 12/29/00

We use interbase on our sites. None of my projects have gone to production,
so I have no practical example to give. But I've been very happy with it's
implementation in PHP.

I used interbase in perl on one production site, and it was grand. The
great thing for us was the fact that our customer database didn't need to be
converted. We use the same database for our support reps as well as the
web.

Now, this production site is being re-written in PHP, and it's going to be
even better.

Speed? Don't really know. I never really pushed it. I only had about 300
different users access it so far, and they weren't all accessing it at once.
At the time, I think my first bottle neck was perl.exe because I was running
it as a CGI and not an apache module.

One of my development sites uses interbase to store *all* of the HTML. The
HTML contains {template} markers that makes my script look up even more
content in interbase. This will be a real test of PHP/interbase. Likely,
I'll have to add some sort of caching mechanism to reduce the database hits.

If you're interested, when it goes to production, it'll be
http://www.trams.com/. Right now, the site has no PHP or interbase, so
don't please don't judge it right away. Hey, what am I worried about? I
don't do content, just the delivery system. ;-)

There has been some confusion on the free status if interbase. If you
downloaded versions prior to 6.0, you needed a series of license id/key
pairs because these versions were built before the open status.

I'm going to go out on a limb and recommend Interbase (v6, anyway). It
supports foreign keys, outer joins, sub-queries, multiple drives (on the
same node), and more. It is going to gain some sort of replication support
in the near future.

Anthony

-----Original Message-----
From: Jason [mailto:jbeebe <email protected>]
Sent: Wednesday, December 27, 2000 6:05 PM
To: php-db <email protected>
Subject: Re: [PHP-DB] 'Best' DB for Linux/Apache/PHP?

Well, I think the volume of people discussing mySQL, whether it be for
support or whatever is a positive sign. The user base and community support
for this db is tremendous. personally, i've used mysql on a number of sites.
1 in particular is quite busy. i think that mysql can hold its own against
most db's. is it the best... probably not. it is very good though. it
depends on what you're using it for and how you'll use it. as far as mysql,
i've never had a problem with performance, stability, or anything else.
pgsql is very good also. but again, its all in what you'll use it for. if
you're coding in php, it has a tremendous number of built in functions for
mysql. it does support pgsql and other dbs very good as well also. mysql
lacks certain features that other sql dbs have. one of them is foreign key
support. there is a method to the madness tho. it really just depends on
what exactly you'll be using it for. i would recommend mysql or pgsql.
interbase is free and borland claims its an ass kicker, but i've never dealt
with it, nor heard much about. maybe worth looking into.

jason

> On Thu, Dec 28, 2000 at 12:08:56PM +1030, Tyson Lloyd Thwaites wrote:
> > I am looking for an enterprise strength db server for Linux. I have
> > looked at IBM DB2, Sybase ASE, and Oracle...as well as mysql and
> > pgsql.
>
> i haven't had any experience with the commercial dbs, except for one
> encounter with oracle that i'd rather forget. i, too, would like some
> opinions here.
>
> > What are people using for the big sites? Any general experiences that
> > people have had would be most appreciated!
>
> having read this list for a few months now, i've seen a lot of people
> (myself included) recommend pgsql. as i've commented previously on this
> list, lots of people want help with mysql and oracle. LOTS. even
> accounting for the different sized user bases, i think this is a bit
> worrying... quite rare is the poster needing pgsql help.
>
> pgsql has its odd quirks, but on the whole its a very easy to admin and
> SOLID db server. we've been using 7.0.3 on a few fairly busy sites, and
> it hasn't blinked yet. very fast, too. the data corruption bugs i saw
> in 6.5.x with INSERT/UPDATE longer than they were supposed to be, are
> long gone.
>
> slightly offtopic (*grin*): anyone looking for a unix admin/web
> developer? email me off-list if you are interested. my job here ends
> mid january.
>
> j.
>
> --
> .----------+------------------------------------.
> |John Slee `-----------. <john <email protected>>|
> |Chirp Web Design | http://www.chirp.com.au|
> |Phone: +61 2 62301871 `----. +61 2 62301515 Fax|
> `---------------------------+-------------------'
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>