Thread

  1. RE: [GENERAL] For data based web site, which RDBMS is better & wh y ?

    Jackson, DeJuan <djackson@cpsgroup.com> — 1999-05-19T21:59:49Z

    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.
    > 
    > 
    
    
  2. RE: [GENERAL] For data based web site, which RDBMS is better & wh y ?

    Marc Fournier <scrappy@hub.org> — 1999-05-20T14:58:44Z

    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 
    
    
    
  3. RE: [GENERAL] For data based web site, which RDBMS is better & wh y ?

    Herouth Maoz <herouth@oumail.openu.ac.il> — 1999-05-23T10:01:34Z

    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