[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,
>
> 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.
No doubt about that. My client's shop is getting more traffic, and the gdbm is
showing it's limitations. For one thing, it doesn't sort very well, especially
when I sort the results of a search engine.
>
> What is ResiserFS? Is it better than linux alpha-version of Irix's
> filesystem?
ResierFS is a journaling file system, but I understand it only journals the
meta-data not the data itself.
>
> 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
Thahks, I'll take a look at that! I hope it can handle the UPS system OK.
> I don't know if Minimate supports SQL, I use ShopAdmin
> (http://www.shopadmin.de), but it doesn't support SQL by
> default, too.
Can it support SQL with some tweaking?
>
> 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
_________________________________________________________________________
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
