In rails the database is mostly a storage space for freeze-dried model objects. Your typical enterprise RDBMS woes don't apply.
Migrations just make sure that the database scheme is consistent with your actual model. As far as writing Rails applications is concerned the actual technology used to persist objects is (mostly) abstracted away from the task of application design and development.