On Sat, 2006-02-11 at 16:19 +1000, Joal Heagney wrote:
> > I'm curious. Why?
> > Is there some advantage to Postgres over MySql?
>
> Yes and no. Postgresql offers more features and is IMO more flexible
> than most SQL servers out there.
A friend described MySQL as the RDBMS for people who do not really need
an RDBMS. This is a little unfair, but has just enough truth to bear
repeating. MyISAM tables offer good performance at the cost of
transactions, views, row locking, etc. The MySQL documentation suggests
some work-arounds.
I use MySQL for these benefits:
replication - (off-site near real time backups; simple distributed
processing)
enum and set datatypes - easy to use integer to text mapping fields.
enums == radio buttons (single-select), sets == check boxes (multi-
select)
very easy administration
good performance
Obviously, the lack of transactions is a nuisance. If you are
converting software from another RDBMS, the MySQL limitations will be
especially painful. When replication and/or easy administration trump
other concerns, MySQL can be a good choice.
--
Lloyd Kvam
Venix Corp
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
