if account balance for Joe Schmoe is greater than X, then deduct X from it, else print an error
You better have transaction support. Otherwise nasty things happen if this code is executed concurrently by two separate processes. Now in the old days MySQL used to allow you to lock the table where the data is from. Very ugly, very inneficient.
But I need to stop before Wire calls me a PostgreSQL Tabliq (am worse than that actually). And before I start ranting about the one that often goes with MySQL: PHP (Ugh!)
P.
On May 21, 2004, at 12:25, Hari Kurup wrote:
True, the question "Which is better" may get you subjective/biased answers.
However, I think the question is "Why is MySQL more popular than
PostgreSQL?". (Like you may ask why Windows is more popular than Linux).
Someone told me that transaction support is an "advanced feature" not required by default since it has a general impact on speed. Is it true Paul?
K.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lunghabo
James
Sent: Friday, May 21, 2004 10:15 AM
To: [EMAIL PROTECTED]
Subject: Re: lug_: MySQL 4.0.20 Released
Bagye
Some wars simply never end eg.
Which is better; Gnome or KDE ? vi or emacs ? slackware or suse ?
W
At risk of starting another set of religous wars, I have had the need,
for a long time, to understand why so many opt for an open source
database which has transaction support only as an option? And that,
even when they need it. Any ideas?
On May 21, 2004, at 08:15, Kiggundu Mukasa wrote:
http://lists.mysql.com/announce/191
MySQL 4.0.20, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download
pages at http://www.mysql.com/downloads/ and mirror sites...
**************** *****************************
Kiggundu Mukasa # Computer Network Consultancy###
KYM-NET LTD. # Intranets & Internet Solutions# Plot
80 Kanjokya Street
P.O. Box 24284 Kampala, Uganda
Tel: +256 77 972255
+256 71 221141
Fax: +256 31 262122
*****************************************************************
--------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
----------------------------- P. A. Bagyenda Digital Solutions P.O.Box 23833 58 Bukoto Str. Kampala, UGANDA
Tel: +256-41-540143 Mob: +256-77-507743 Web: http://www.dsmagic.com -----------------------------
This email and any files transmitted with it are confidential, and may
also
be legally privileged. If you are not the intended recipient, you may
not
review, use, copy, or distribute this message. If you receive this
email in
error, please notify the sender immediately by reply email and then
delete
this email.
--------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
--------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
--------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
----------------------------- P. A. Bagyenda Digital Solutions P.O.Box 23833 58 Bukoto Str. Kampala, UGANDA
Tel: +256-41-540143 Mob: +256-77-507743 Web: http://www.dsmagic.com -----------------------------
This email and any files transmitted with it are confidential, and may also
be legally privileged. If you are not the intended recipient, you may not
review, use, copy, or distribute this message. If you receive this email in
error, please notify the sender immediately by reply email and then delete
this email.
--------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
