What is the best choice of DBMS for Rails on Mac OS X. This is quite annoying that it was not shipped by default because they have a full rails development stack without mysql or postgresql. I hope they didnt feel that SQLite was the DBMS of choice. It doesnt even support foreign keys! -Ron --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Oct 27, 2007, at 3:10 PM, Ronald Valente wrote:> What is the best choice of DBMS for Rails on Mac OS X. This is quite > annoying that it was not shipped by default because they have a full > rails development stack without mysql or postgresql. > > I hope they didnt feel that SQLite was the DBMS of choice. It doesnt > even support foreign keys!SQLite is a great database to start developing a rails application with. ActiveRecord will enforce your foreign key integrity. Some Rails applications deviate from the basic "data in, data out" pattern, and eventually you can use the more advanced features of a database like MySQL or PostgreSQL, such as MySQL''s full text search, or Postgres'' indexed calculations. But the more you can rely on ActiveRecord, the easier things are to test and maintain. Alternatively, you can get MySQL from mysql.com, and it works great on Leopard, or at least it does for me so far. Do note that even though MySQL has support for foreign key constraints, many people still choose to leave that up to ActiveRecord. -- Jordi
How do I go about using ActiveRecord to enforce foreign key integrity compared to doing that traditionally on the DBMS? Thanks. -Ron On Oct 27, 2007, at 3:23 PM, Jordi Bunster wrote:> On Oct 27, 2007, at 3:10 PM, Ronald Valente wrote: > >> What is the best choice of DBMS for Rails on Mac OS X. This is quite >> annoying that it was not shipped by default because they have a full >> rails development stack without mysql or postgresql. >> >> I hope they didnt feel that SQLite was the DBMS of choice. It doesnt >> even support foreign keys! > > SQLite is a great database to start developing a rails application > with. ActiveRecord will enforce your foreign key integrity. > > Some Rails applications deviate from the basic "data in, data out" > pattern, and eventually you can use the more advanced features of a > database like MySQL or PostgreSQL, such as MySQL''s full text search, > or Postgres'' indexed calculations. But the more you can rely on > ActiveRecord, the easier things are to test and maintain. > > Alternatively, you can get MySQL from mysql.com, and it works great > on Leopard, or at least it does for me so far. Do note that even > though MySQL has support for foreign key constraints, many people > still choose to leave that up to ActiveRecord. > > -- > Jordi >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---