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

date posted 22nd November 2007 10:23

Quoting Anthony Cartmell [EMAIL REMOVED]

>
>> No, it can't. It simply can't support a properly normalised database:
>> all the relationships that should be modelled in the database through
>> the primary/foreign key mechanism have instead to be modelled in Ruby
>> using Active Record.
>
> I blame the popularity of MySQL for this, with its previous lack of
> foreign key mechanisms.

As I understand it, that's _exactly_ why ActiveRecord is so broken. It
was built around MySQL 3.23.

> 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.

Dave...