On Sunday 05 August 2001 1:02 pm, Martyn Drake wrote:
On 04 Aug 2001 23:44:52 +0100 Andrew John Savory wrote:
Gah! Sorry, but MySQL is probably the worst choice you could ever make if you want to use SQL or have a dynamic web site. For goodness sake, please use a PROPER database! Oracle, Postgres, even SQL Server is a better choice than MySQL.
Where I work, we're nowing using Postgres for all new clients. We will be converting the majority of clients that use MySQL over to Postgres over the course of many months.
Lets's just recap here... first, it was Darren that named MySQL, not me, so I have no idea why I'm getting all the flack. Secondly, for my application, MySQL works fine, and I have absolutely no interest in installing a commercial solution such as Oracle or SQL server when I have no call for it. Maybe I could have used Postgres, but MySQL was the option available on the servers I was using. The day may come when the site grows enough that transactions, subselects etc are of use to me, but the way that site's written it could do with the excuse for a rewrite; I started it days after I first picked up the PHP manual, and have been retro-fixing it since.
Alternatively, by that point, MySQL might have developped these features anyway.
But everbody agrees that Postgres is the way to go..
I don't think you'll find that "everybody agrees" on anything, be it which OS, editor, distro, or mouse to use. Among its many benefits, open source software allows choice, and if I happen to make a choice - on a system that in no way affects you - then that's my call. Personally, I'd far rather make the wrong choice of my own volition, than blindly follow what someone's told me is the "One True Way".
I supported this combination because it works for me... it lets me get things done quickly and simply, and if I couldn't do that, the site wouldn't exist. You chose to use other tools, and that's fine; likewise I use other tools on other projects. The beauty lies in having the choice.
Richard