Re: [TCLUG:15201] Linux DBMS

["Carl Wilhelm Soderstrom" <carls@agritech.com>]

Chewie wrote:
>PostgreSQL is known for its stability and a particularly important
>selling point is it's support for transactions; something that MySQL does not
>have and may not have in the future.
        actually, I belive there was an article in Linux Journal a few
months ago, about MySQL, which stated that there *is* a patch to give MySQL
transaction capability.
        however, it's not popular, and hasn't been merged into the main
source tree. if you really want transactions, go for a different dbase.
MySQL's strength is speed and simplicty; let others do the fancy stuff. :)
        my understanding is that transactions (as opposed to table locking,
which MySQL does), are more valuable in situations where many users are
writing to the same table simultaneously. this is probably not that
important in small websites; nor in small offices (M$ Access uses table
locking, AFAIK).

of course, I could be wrong.
Carl Soderstrom
System Administrator    307 Brighton Ave. 
Minnesota DHIA	        Buffalo, MN	
carls@agritech.com      (612) 682-1091