Thread: RE: [GENERAL] For data based web site, which RDBMS is better & wh y ?
The problem here is to find impartial comparisons.
The question between MySQL and PostgreSQL usually come down to
Do I care most about speed? - usually true for purely Web Apps.
or
Do I need transaction and the other features PostgreSQL offers? -
which tends to only be true if you plan on using the database for things
other than web development.
18 months ago when I went looking for a good RDBMS I chose PostgreSQL
because I knew even though all I was currently doing was Web Apps I'd need a
database that had fully functioning transactions, extensible types and
functions, ... and I could always handle speed issues through whatever
interface I choose to use (ie table caching).
> -----Original Message-----
> From: ralli@poboxes.com [SMTP:ralli@poboxes.com]
> Sent: Wednesday, May 19, 1999 1:38 PM
> To: Kevin Lo
> Cc: Dinesh Patil; pgsql-general@postgreSQL.org
> Subject: [GENERAL] For data based web site, which RDBMS is better &
> why ?
>
> Hi,
>
> I am new on this list.
>
> I am in a process of Outsourcing for Development of a data based
> web site for Real Estate.
>
> Some database experts have informed me that PostgreSQL is the best.
>
> My web developer says MySQL is ideal for my requirement,( may be he
> doesn't know
> PostgreSQL ).
>
> Here is a mail that says that for some advance features limitations,
> Dinesh wants to port PostgreSQL to NT.
>
> Can some experts , users or gurus provide me some insight or
> guide me to some pointers where impartial comparative analysis of
> RDBMS has been done.
>
> Thanks
>
>
> Rakesh Ralli
> http://welcome.to/ralli
>
>
> Kevin Lo wrote:
> >
>
> > Dinesh Patil wrote:
> >
> > > Hi,
> >
> > Hi, Dinesh,
> >
> > > I am working on Postgres currently but we will be replacing postgres
> with
> > > another database for advanced features and different platforms like
> Windows
> > > NT
> > > where postgres cannot be used.
> >
> > You can port PostgreSQL to NT :) please see my page:
> >
> > http://members.tripod.com/~kevlo/postgres/portNT.html
> >
> > Hope this helps,
> > Kevin.
>
>
On Wed, 19 May 1999, Jackson, DeJuan wrote: > The problem here is to find impartial comparisons. > The question between MySQL and PostgreSQL usually come down to > Do I care most about speed? - usually true for purely Web Apps. > or > Do I need transaction and the other features PostgreSQL offers? - > which tends to only be true if you plan on using the database for things > other than web development. Actually, I tend to use transactions "and the other features" quite extensively in my WWW apps...I like the fact that is an update to one table in a multi-table update dies, the transaction aborts and no updates happen... > > 18 months ago when I went looking for a good RDBMS I chose PostgreSQL > because I knew even though all I was currently doing was Web Apps I'd need a > database that had fully functioning transactions, extensible types and > functions, ... and I could always handle speed issues through whatever > interface I choose to use (ie table caching). > > > > -----Original Message----- > > From: ralli@poboxes.com [SMTP:ralli@poboxes.com] > > Sent: Wednesday, May 19, 1999 1:38 PM > > To: Kevin Lo > > Cc: Dinesh Patil; pgsql-general@postgreSQL.org > > Subject: [GENERAL] For data based web site, which RDBMS is better & > > why ? > > > > Hi, > > > > I am new on this list. > > > > I am in a process of Outsourcing for Development of a data based > > web site for Real Estate. > > > > Some database experts have informed me that PostgreSQL is the best. > > > > My web developer says MySQL is ideal for my requirement,( may be he > > doesn't know > > PostgreSQL ). > > > > Here is a mail that says that for some advance features limitations, > > Dinesh wants to port PostgreSQL to NT. > > > > Can some experts , users or gurus provide me some insight or > > guide me to some pointers where impartial comparative analysis of > > RDBMS has been done. > > > > Thanks > > > > > > Rakesh Ralli > > http://welcome.to/ralli > > > > > > Kevin Lo wrote: > > > > > > > > Dinesh Patil wrote: > > > > > > > Hi, > > > > > > Hi, Dinesh, > > > > > > > I am working on Postgres currently but we will be replacing postgres > > with > > > > another database for advanced features and different platforms like > > Windows > > > > NT > > > > where postgres cannot be used. > > > > > > You can port PostgreSQL to NT :) please see my page: > > > > > > http://members.tripod.com/~kevlo/postgres/portNT.html > > > > > > Hope this helps, > > > Kevin. > > > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
At 00:59 +0300 on 20/05/1999, Jackson, DeJuan wrote: > The problem here is to find impartial comparisons. > The question between MySQL and PostgreSQL usually come down to > Do I care most about speed? - usually true for purely Web Apps. > or > Do I need transaction and the other features PostgreSQL offers? - > which tends to only be true if you plan on using the database for things > other than web development. To be more exact, you have to ask yourself whether only one person will be performing updates at a time. The lack of transactions for MySQL implies lack of locks, and thus lack of support for concurrent updates. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma