Re: [mv] MySQL vs PostgreSQL

[Viktors Rotanovs <viktors@riga.nu>]

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

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.

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.

On Tue, 11 Jul 2000, you wrote:
> ******    message to minivend-users from "Brian Wright" <bdw@Aturna.com>   
>  ******
>
> Hi, listees! :)
>
> I'm in the process of upgrading my Minivend customers to MV 4, and I will
> converting my shops from the GDBM format to SQL.  I'm researching which SQL
> package to use.  I'm a bit concerned about MySQL, since it doesn't support
> transactions and referential integrity, as I understand.  PostgreSQL does
> have referential integrity and transactions, but doesn't have as many admin
> applications.  Any advise on to which package to use would be very helpful.
> Will MiniMate allow my clients to update their products and inventory
> databases?
>
> Also, can the shipping tables be done in SQL?
>
> Thanks,
> Brian
>
> _________________________________________________________________________
> Brian Wright                                   Aturna Communications Inc.
> bdw@aturna.com                                          Internet Services
>                                                 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

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