Re: [mv] MySQL vs PostgreSQL

[Viktors Rotanovs <viktors@riga.nu>]

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

Hi Brian,

surely referential integrity will not be very fast, but, I suppose,
if you would emulate it with MySQL+perl, it will not be fast too.

What is ResiserFS? Is it better than linux alpha-version of Irix's
filesystem?

I tried to put shipping to SQL with no luck. But take a look at
shipping daemon for Minivend, it's URL is:
	http://www.morpheux.org/minivend/shipd/shipd.html

I don't know if Minimate supports SQL, I use ShopAdmin 
(http://www.shopadmin.de), but it doesn't support SQL by
default, too.

On Wed, 12 Jul 2000, Brian Wright wrote:
> 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
> _________________________________________________________________________

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