> I would say that if one is looking for complexity and scalability of RDBMS > in the open source world, Postgres is a good choice. Though I am not too > confortable with the pace of it's development. ~~~~~~~~~~~~~~~~~ Exactly ! I am sure when enough experiments are done on PostGRE as are done with MySQL.You start liking MySQL. ;o)
Probably, PostGRE is considered better and secure than MySQL only because that many bugs havent been discovered in Post GRE. But looking at the amount of development and work being done in MySQL, I am sure Post GRE will have as many problems. So why not push MySQL to scalability rather than picking up a "less" tested SQL. One thing I am unsure of... is it good to have complexity in a DB ? isnt simpler the better ? What you will find in oracle, MSSQL, etc, in the "best practices/secret wisedumb tips" section. MySQL will not permit anything apart from those things. So in otherwords, your MySQL leaves less scope for mistakes. I am in love with a statement in MySQL manual(which is about why they didnt support Foregin keys) "If a db programmer deletes a row in a table and forgets to delete a related row in another table, he shouldnt really be doing programming.". ;o) It was not exactly this, but something on similar lines. ================================================ To subscribe, send email to [EMAIL PROTECTED] with subscribe in subject header To unsubscribe, send email to [EMAIL PROTECTED] with unsubscribe in subject header Archives are available at http://www.mail-archive.com/ilugd%40wpaa.org =================================================