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. But everbody agrees that Postgres is the way to go..
Regards,
Martyn
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
On 05 Aug 2001 16:16:15 +0100, Richard George wrote:
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.
For sure, sorry, attributions often get lost in a flame-fest!
But, you line yourself up nicely for a good healthy proportion of the flack:
Secondly, for my application, MySQL works fine
...
The day may come when the site grows enough that transactions,
subselects
etc are of use to me
What we're trying to do is save people the bother of extensive rewrites to support a new database. Yes, DBI gives you database abstraction, but MySQL takes it all away again by forcing you to write line after line of code that compensates for it's limitations.
Also, the "the day may come" argument is dangerously seductive. There are monster bugs in MySQL *today* that make it a nightmare choice. My personal favourite was asking it to perform: UPDATE foo SET bar=bar+1 WHERE id=?; ... this would regularly hang the MySQL thread. We're not talking rocket science here, and yet I was forced to move trivial SQL tasks into my perl code. Of course, YMMV - this was on a table of 1.5m records.
I don't think you'll find that "everybody agrees" on anything, be it which OS, editor, distro, or mouse to use.
I think it was a case of "everybody at Martyn's workplace agrees..."
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".
Fair comment. The other bonus of the Open Source ethos though is that many people have often done what you are trying to do before, and there's an opportunity to save time and effort by learning from their mistakes. I wouldn't be evangelising Postgres today if it wasn't for MJ Ray and Paul Russell beating me violently across the back of the head with a copy of it whenever I grumbled about MySQL crashing...
Andrew.
Hi,
My posting was never intended to cricitise anybody's choice of SQL server, so my apologises to anybody offended by it. I agree with you that choice is the greatest factor of all. If you don't need all the fancy gubbins or compliance of Postgres or SQL Server - that's fine. I still use PHP and MySQL for my web site heavily, because it's what I know and it was already installed for me (lazy bugger that I am!) :)
It's like email clients - not everybody uses Evolution, nor mutt, or Pine or whatever. You use whatever you need to get the job done. I prefer Evolution as it integrates really well into my company's mail system and I think it handles quoting and filtering extremely well for a Linux GUI mail client.
Regards,
Martyn
On 05 Aug 2001 16:16:15 +0100, Richard George wrote:
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
Technical Webmaster, http://www.cyclists.org.uk/
alug, the Anglian Linux User Group list Send list replies to alug@stu.uea.ac.uk http://www.anglian.lug.org.uk/ http://rabbit.stu.uea.ac.uk/cgi-bin/listinfo/alug See the website for instructions on digest or unsub!
-
Andrew John Savory -
Martyn Drake -
Richard George