On Fri, 13 Aug 2004, Noah Sematimba wrote:
> Searching freshmeat projects section for mysql brings up so many
> apps that use it that it naturally makes it the better choice for
> me. Of course I don't put it up there with RDBMS like oracle however
> given a choice between MySQL,PostgreSQL and MSSQL I would chose
> MySQL but YMMV :-)
Actually I do see this similar to the classic FreeBSD - Linux clash.
FreeBSD was built to be rock solid from the start (all kinds of controls
on the developers, making sure the quality of code was just the right,
having a *very high* level of organization including clear documentation
etc...) as a result its quite a reliable choice (I had over 340 days
straight uptime until someone where we're co-locating the box rebooted it
by mistake).
Whereas, Linux didn't quite start like that though with the latest 2.6
Kernel the two OSs seem to be converging (in security, scalability and
stability). MySQL was built to be lightening fast from the start and the
developers were very arrogant about features (they were reknown for saying
"transactions should be handled in the application code"), it surely was
quite fast but as it becomes a "corporate solution", there is increased
pressure for it to conform thus increasing "standard" features that an
RDBMS should have -- transactional support, prepared statements,
subqueries etc...
In my opinion, the two RDBMS seem to be converging (PostgreSQL becoming
faster, MySQL getting more features).
My 500/-. (2c is abit on the 'lesser' side these days).
Gerald.
---------------------------------------------
This service is hosted on the Infocom network
http://www.infocom.co.ug
