[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] MySQL vs PostgreSQL
****** 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
