Em 18-02-2013 09:27, Godfrey Chan escreveu:
...
2. You are correct that schema_format = :ruby does not support
vendor-specific features like HStores or other "advanced" SQL features
like foreign key constraints.
Foreign key is a basic concept in RDBMS for several years and
implemented in all major RDBMS vendors, such as Oracle, PostgreSQL,
Firebird, MS SQL Server and MySQL (it is also supported by default
nowadays since InnoDB is now the default engine) among many others used
in production systems. I can't really recall any RDBMS vendor that
doesn't support foreign keys (no one should be really using MyISAM as
MySQL engine).
It is part of the ANSI SQL specs:
http://en.wikipedia.org/wiki/Foreign_key
"Foreign keys are defined in the ANSI SQL Standard, through a FOREIGN
KEY constraint. The syntax to add such a constraint to an existing table
is defined in SQL:2003 as shown below..."
While I agree that HStores, PG schemas and other similar features can be
considered advanced ones, foreign keys by no means could be confused as
an advanced SQL feature. It's simply essential for any serious
application relying on RDBMS, just like transactions support, unique
constraints and so forth.
--
You received this message because you are subscribed to the Google Groups "Ruby on
Rails: Core" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
