Can anyone recommend a database modelling tool for the Mac? I''m building a new Rails app and want an interface to draw out the database''s entity relationship diagram, setup foreign keys and then output DDL at the end to MySQL. I''ve previously used DBDesigner, CASE Studio and some pricier enterprise software on Windows, but can''t find anything suitable for my Mac. The MySQL Workbench project seems to have stalled and I can''t find anything suitable. Any recommendations? Thanks Barry Frost --~--~---------~--~----~------------~-------~--~----~ 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 21 Apr 2007, at 17:33, Barry Frost wrote:> Can anyone recommend a database modelling tool for the Mac? I''m > building a new Rails app and want an interface to draw out the > database''s entity relationship diagram, setup foreign keys and then > output DDL at the end to MySQL. > > I''ve previously used DBDesigner, CASE Studio and some pricier > enterprise software on Windows, but can''t find anything suitable for > my Mac. The MySQL Workbench project seems to have stalled and I can''t > find anything suitable. > > Any recommendations?If you are happy with just creating diagrams and then using Rails migrations to create your database scheme (from my point of view the best thing to do anyway), you could use Omnigraffle. There''s also DBVisualiser at http://www.minq.se/products/dbvis/info.html Best regards Peter De Berdt --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Using ActiveRecord with extra database level stuff like foreign key constraints, multiple-column primary keys, etc. is the Wrong Thing to do. I got burned by this and had to re-write my database schema in Rails 1.1.6. ActiveRecord will enforce most of that stuff for you if you tell it to. Most of these tools will probably generate schemas that have that extra cruft. They''ll also probably not be compatible with migrations. Just a word of warning... On Apr 21, 11:33 pm, Barry Frost <barry.fr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Can anyone recommend a database modelling tool for the Mac? I''m > building a new Rails app and want an interface to draw out the > database''s entity relationship diagram, setup foreign keys and then > output DDL at the end to MySQL. > > I''ve previously used DBDesigner, CASE Studio and some pricier > enterprise software on Windows, but can''t find anything suitable for > my Mac. The MySQL Workbench project seems to have stalled and I can''t > find anything suitable. > > Any recommendations? > > Thanks > > Barry Frost--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Multiple-column primary keys does not seem compatible with ActiveRecord as you say. However, I disagree about not using foreign key constraints. These are wonderful, useful aids to maintain the referential integrity of the DB. When your code violates one, you get a SQL error immediately. It''s much easier to fix one of these than it is to try to debug an application that fails intermitently due to data error. Personally, I have been doing relational database work since the 80''s, so I perfer to use dbms tools over rails migrations. Take what works and leave the rest when it comes to frameworks and development tools. On Apr 22, 8:23 am, eden li <eden...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Using ActiveRecord with extra database level stuff like foreign key > constraints, multiple-column primary keys, etc. is the Wrong Thing to > do. I got burned by this and had to re-write my database schema in > Rails 1.1.6. ActiveRecord will enforce most of that stuff for you if > you tell it to. > > Most of these tools will probably generate schemas that have that > extra cruft. They''ll also probably not be compatible with migrations. > > Just a word of warning... > > On Apr 21, 11:33 pm, Barry Frost <barry.fr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Can anyone recommend a database modelling tool for the Mac? I''m > > building a new Rails app and want an interface to draw out the > > database''s entity relationship diagram, setup foreign keys and then > > output DDL at the end to MySQL. > > > I''ve previously used DBDesigner, CASE Studio and some pricier > > enterprise software on Windows, but can''t find anything suitable for > > my Mac. The MySQL Workbench project seems to have stalled and I can''t > > find anything suitable. > > > Any recommendations? > > > Thanks > > > Barry Frost--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
[SQLEditor](http://www.malcolmhardie.com/sqleditor/) is not free, but it does nice ERDs and does Rails migrations. # Damian --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
njmacinnes-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2007-Apr-22 16:26 UTC
Re: Database Modeller (Mac)
Whatever happened to that AJAX one which was specifically designed for rails? ie, it would generate rails migrations and stuff. Someone posted a link to it here a while ago (although searching my mail archives, I can''t find it). That looked promising, even though it was in some kind of pre-alpha stage. On 21/04/07, Barry Frost <barry.frost-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > Can anyone recommend a database modelling tool for the Mac? I''m > building a new Rails app and want an interface to draw out the > database''s entity relationship diagram, setup foreign keys and then > output DDL at the end to MySQL. > > I''ve previously used DBDesigner, CASE Studio and some pricier > enterprise software on Windows, but can''t find anything suitable for > my Mac. The MySQL Workbench project seems to have stalled and I can''t > find anything suitable. > > Any recommendations? > > Thanks > > Barry Frost > > > > >--~--~---------~--~----~------------~-------~--~----~ 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 Apr 22, 2007, at 5:33 PM, dagny wrote:> However, I disagree about not using foreign key constraints. These are > wonderful, useful aids to maintain the referential integrity of the > DB. When your code violates one, you get a SQL error immediately. It''s > much easier to fix one of these than it is to try to debug an > application that fails intermitently due to data error.I agree, they are a great help to get a chain of has_many :dependent right. You get an index for that column automatically as well at least in MySQL and a few more, so we use the plugin from RedHill Consulting in all our applications. -- fxn --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
http://railroad.rubyforge.org/ may be what you are looking for. Bill -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---