Keep the discussion on topic, will you? If you want to bash about how Rails sucks for not using foreign keys then open a new thread for that.
On Mon, Feb 18, 2013 at 10:32 AM, Rodrigo Rosenfeld Rosas < rr.ro...@gmail.com> wrote: > 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 rubyonrails-core+unsubscr...@googlegroups.com. > To post to this group, send email to rubyonrails-core@googlegroups.com. > Visit this group at http://groups.google.com/group/rubyonrails-core?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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 rubyonrails-core+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-core@googlegroups.com. Visit this group at http://groups.google.com/group/rubyonrails-core?hl=en. For more options, visit https://groups.google.com/groups/opt_out.