Re: [mv] MySQL vs PostgreSQL

[Robert Fournerat <robert@netin.com>]

******    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