Re: [mv] MySQL vs PostgreSQL

[Robert Fournerat <robert@netin.com>]

******    message to minivend-users from Robert Fournerat <robert@netin.com>     ******

Viktors Rotanovs wrote:
> 
> ******    message to minivend-users from Viktors Rotanovs <viktors@riga.nu>     ******
> 
> Hi Robert,
> 
> it does guarantee. Check that your postgres version is 7.x.

I am using 6.5.3.  I didn't know there was a 7.0 release  (7.0.2
is the latest).  I'll update and test - but this is low priority
for me...

thanks,
Robert


> Also check how you created tables.
> 
> On Thu, 13 Jul 2000, you wrote:
> > ******    message to minivend-users from Robert Fournerat
> > <robert@netin.com>     ******
> >
> > For the record, I prefer Postgresql over MySQL.  However, I
> > believe that postgresql does not guarantee referential integrity.
> > ie:
> >
> > table1.row.field -> table2.row.key   // some record in table 1
> >                                      // has a reference to some
> >                                      // record in table 2
> >
> > If I deleted table2.row.key (and nothing else), we have a
> > referential problem in table1.  Postgresql does not prevent
> > this type of problem from happening...
> >
> > -- Robert
> >
> > Brian Wright wrote:
> > > ******    message to minivend-users from Brian Wright <bdw@aturna.com>
> > >  ******
> > >
> > > On 12-Jul-2000 Viktors Rotanovs wrote:
> > > > ******    message to minivend-users from Viktors Rotanovs
> > > > <viktors@riga.nu> ******
> > > >
> > > > Hi Brian,
> > > >
> > > > PostgreSQL is much better, because it has referential integrity,
> > > > which is essential in e-commerce. That means, there will be
> > > > no products that do not belong to some category, no orders
> > > > belonging to non-existent users, etc.
> > >
> > > That's why I was leaning towards PostgreSQL, because it supports the
> > > referential integrity.
> > >
> > > > It is 2-3 times slower than MySQL, but is closer to SQL92,
> > > > so you will not have to re-learn SQL to use it.
> > >
> > > Hehehe, I'm quite willing to sacrifice performance for the referential
> > > integrity.
> > >
> > > > Anyway, make backups often, because any database contains
> > > > bugs, even best one. Also, linux ext2 filesystem is not very good
> > > > for holding important data, because it corrupts often on hardware
> > > > failures. *BSD's UFS is much better from that point of view.
> > >
> > > That's true, unless ResiserFS or some journaling file system is included
> > > in the 2.4 Linux kernel.  I don't know how many times e2fsck would toss
> > > stuff into lost+found if the HD was not umounted cleanly. :)
> > >
> > > But, I need to know if the shipping tables can be used in SQL format, or
> > > would they stay in GDBM, and does MiniMate support SQL so my clients can
> > > update their inventory.
> > >
> > > Many thanks,
> > > Brian
> > > _________________________________________________________________________
> > > Brian Wright                                   Aturna Communications Inc.
> > > bdw@aturna.com                                          Internet Services
> > > AIM: BigBY2K ICQ: 21221328                      WWW http://www.aturna.net
> > > _________________________________________________________________________
> > > -
> > > To unsubscribe from the list, DO NOT REPLY to this message.  Instead,
> > > send email with 'UNSUBSCRIBE minivend-users' in the body to
> > > Majordomo@minivend.com. Archive of past messages:
> > > http://www.minivend.com/minivend/minivend-list
> >
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to
> > Majordomo@minivend.com. Archive of past messages:
> > http://www.minivend.com/minivend/minivend-list
> 
> --
> Best Wishes,
> Viktors Rotanovs
> < Dations SIA / Riga LV +371 / phone 7339.622 / gsm 9173.000 / fax 7377.472 >
> < http://riga.nu/  /  Electronic shops and portals / Minivend, PHP and Perl >
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list