As I started to do some development in Ruby here is a quick cheat sheet with some handy DB stuff.

One of the things that annoys most RoR users is that depending on how many Ruby environments you have on your comp you sometime can run ‘rake db:migrate’ but if you have multiple ruby’s you need to prefix that with bundle exec; e.g. bundle exec rake db:migrate. To be on the save side I prepend it in all the following examples.

After a migration:

Migrate your DB to the last version as indicated in the src.

On heroku:

When one wants to repopulate DB and make the test environment ready:

Tips

You can stack items: