[cad-linux] Re: database cad system

On Tue, 2003-06-24 at 12:08, Thomas Schmidt wrote:
[snip]
> The most popular open source database servers are mysql and postgresql.
> mysql is fast as hell, but it does not have support for transactions and =
> reasonable locking.
> Unless you want a single use/single process system, mysql is a bad choice=
>  for your project.=20

Hope you don't mind me just posting the other side of this (I'm not a
MySQL expert but I've used it a bit):

For one, I thought the latest versions of MySQL (4.0+) did transactions.
Admittedly I've not used transactions but I quick through their latest
docs seems to say they do, the older versions having a workaround which
they discuss:
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Transactions

Also what they have to say about locking
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL-PostgreSQL_features

--copied 'n pasted---
Table locking, as used by the non-transactional MyISAM tables, is in
many cases faster than page locks, row locks, or versioning. The
drawback, however, is that if one doesn't take into account how table
locks work, a single long-running query can block a table for updates
for a long time. This can usually be avoided when designing the
application. If not, one can always switch the trouble table to use one
of the transactional table types. See section 5.3.2 Table Locking
Issues. 
----

I'd argue that as long as you think your app through then MySQL could be
a great choice. 

Guy

Other related posts: