Re: [mv] MySQL vs PostgreSQL

[Viktors Rotanovs <viktors@riga.nu>]

******    message to minivend-users from Viktors Rotanovs <viktors@riga.nu>     ******

Hi Robert,

it does guarantee. Check that your postgres version is 7.x.
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