My quick rules of thumb:
1: If your data is fairly simple, use MySQL. If your data has complex
relationships or you need referential integrity, use PostgreSQL.
2: If you read mostly, use MySQL. If you write frequently, use PostgreSQL.
3: If your queries are simple:
select * from a table
use MysQL.
If you need the power of SQL expressiveness:
select * from a table where table.ID in (Select IDs from table2)
you need PostgreSQL.
All of the above is debatable as to the terms 'fairly simple',
'mostly', 'frequently', etc. YMMV.
At present, we use MySQL for close to 100% of our on-line databases.
We're starting a new project (customer/order/tech support tracking)
that will be PostgreSQL.
Ray
--
-----------------------------------------------------------------
Raymond Cote, President Appropriate Solutions, Inc.
www.AppropriateSolutions.com [EMAIL PROTECTED]
603.924.6079(v) POB 458, Peterborough, NH 03458 603.924.8668(f)
*****************************************************************
To unsubscribe from this list, send mail to [EMAIL PROTECTED]
with the text 'unsubscribe gnhlug' in the message body.
*****************************************************************
