[Tutor] Postgresql+Python -tutorial?
python at venix.com
Sat Feb 11 15:48:25 CET 2006
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
I use MySQL for these benefits:
replication - (off-site near real time backups; simple distributed
enum and set datatypes - easy to use integer to text mapping fields.
enums == radio buttons (single-select), sets == check boxes (multi-
very easy administration
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.
More information about the Tutor