Why Ruby on Rails Migrations Don’t Work

Ruby on Rails Migrations

Migrations in Ruby on Rails provide some nice faetures for manipulating database structure. It is used mainly for two reasons:

  • this is a nice way of keeping database structure changes
  • you don’t need to know SQL
  • the generated SQL code can be used for many database engines

The first point is OK (this is a must, you really should keep such a track of database changes). The second would be nice…. but that simply doesn’t work. I don’t think that not knowing SQL is such a huge advantage. Knowing SQL is really a need when you write some database software using relational databases.

Continue reading