What is the best way to design database for Ruby on Rails?

Question

I know there are many database design tool, database modeling tool. Example, ER-win , db desginer and etc.

But, they are not supported for Ruby on Rails.

What is the best way or tool to design database for Ruby on Rails?

Appended:

I know the rails development phases are growing step by step. But, When starting of project, I think database modeling has to be first. Which database modeling tool can I use?

Answer 1

You're working at it backwards. Don't figure out the table structure you need, then build your application around it. The Rails Way is to start building your application's functionality, piece by piece, and add migrations to build up your database as you need it.

You'll end up with a simpler data model, nothing you don't need, and your data structure will reflect the interactions people have with your site instead of the other way around.

Answer 2

With Rails, you don't. You design the object model, the database model is generated. All database handling is done in the model.

Answer 3

With Rails you use migrations to design your database. Give migrations a shot - I thought I would miss the diagrams in SQL Server when I started working with Rails but I don't.

You can see your schema in a very readable text form at db/schema.rb