Re: Fw: Talking with other Dbases.

On Thu, Sep 28, 2000 at 11:00:20AM -0500, Daryl Chance wrote:
> > without knowing the hardware organization & availability of software,
> > it's seems strange that you're considering different database systems
> > for things that one is perfectly capable of performing.  it's a bit of a
> > fallacy that MySQL is better for read only database sites.  on the low
> > end (fewer connections), MySQL might be faster, but you'd have trouble
> > buying hardware that was slow enough that you'd notice the difference.
> > i've never used MySQL on a heavily loaded web site, but i've heard
> > enough about MySQL breaking down to be a bit concerned about that.  all
> > in all, i'm just not clear on why you're interested in the added
> > headache of multiple database systems & copying data between them.
>
> As I said in my first email, it just depends :).  I do plan on doing
> tests against MySQL and Postgrest to see which would be better for
> just serving out dynamic content (read only).  Whichever one wins
> out will be the one i'm going to use.  Personally, I've had no problems
> at all with MySQL...I'm looking into postgres because MySQL won't
> do the things I need to do on my next product version.  And, the
> data won't be copied between the 2, MySQL will be dumped to, and thats
> it. So there won't really be much headache on that part.  When the time
> comes, I'll choose.  Currently, I'm just planning ahead.

    We actually have a split shop here, because I set up the bug database
in postgres, and we later hired a web guy who was more familiar with MySQL.
He has since seen the light and converted much of his stuff to use Postgres,
but there are some semi-remote machines using MySQL.  With PHP, even though
there is almost no consistency between database interfaces, it isn't too
hard to use both systems.

    I still reccommend going with one database solution, though.  Much
easier to set up, maintain, etc.  I don't trust MySQL, so I'll let
you guess which one I reccommend...

--
Adam Haberlach            | A billion hours ago, human life appeared on
adam@newsnipple.com       | earth.  A billion minutes ago, Christianity
http://www.newsnipple.com | emerged.  A billion Coca-Colas ago was
'88 EX500                 | yesterday morning. -1996 Coca-Cola Ann. Rpt.