Re: FN-FORUM: What's the best development platform for creating Web 2.0 business applications?

date posted 22nd November 2007 11:03

Quoting Ben Moxon [EMAIL REMOVED]

> [EMAIL REMOVED] wrote:
>> Quoting Anthony Cartmell [EMAIL REMOVED]
>>
>>> Note to self: must investigate using new MySQL foreign key handling, if
>>> that's the correct term...
>>
>> Works pretty well. MySQL 5 is almost looking like a real database. Of
>> course, you need to put it into strict mode.
>>
> By the time you've put in real database features do you lose the speed
> advantage that made MySQL so successful in the first place?

Well, precisely.

Earlier this year I was doing some work for a large broadcasting =20
organisation in west London. Whilst I was there they called in a MySQL =20
expert to have a look at their database design and suggest =20
improvements. He was astonished that we had turned on strict mode and =20
couldn't understand why we wanted a database that acted like a =20
database :-)

> At which point I guess Postgres could finally start getting some of the
> attention it deserves.

You'd certainly hope so. I've never understood why MySQL is so =20
popular. If you want sloppy and fast then there's SQLite =20
(http://www.sqlite.org/) and if you want something that is slower but =20
looks like a database there's Postgres.

Dave...