Db_tasks or How to Easily Manage Your Db

Josh knowles and Matt Heidemann from Integrum and I released few weeks a go a cool plugin called rake_tasks

The thing is that the plugin was getting too big when I started hacking the MySQL adapter and adding utf-8 support we figured out it was smarter to split the plugin and create db_tasks and svn_tasks

I temporarily hosted db_tasks there:

http://svn.aimonetti.net/public/plugins/db_tasks/

<code>ruby script/plugin install http://svn.aimonetti.net/public/plugins/db_tasks/
</code>

check your Rake tasks:

  • rake db:create Creates the databases defined in your config/database.yml (unless they already exist) You can also specify the charset and collation you want your dbs to use: rake db:create CHARSET=’latin1’ COLLATION=’latin1_bin’)

  • rake db:drop Drops the database for your currenet RAILS_ENV as defined in config/database.yml

  • rake db:reset Drops, creates and then migrates the database for your current RAILS_ENV

  • rake db:shell Launches the database shell using the values defined in config/database.yml

  • rake db:charset Returns the charset of your current RAILS_ENV database

  • rake db:collation Returns the collation of your current RAILS_ENV database

  • rake db:update_connection_settings add the encoding format to each environment in the database.yml file

By default, your new databases will be utf8, you can automatically create your databases by typing:

rake db:create

or reset your databases (drop, create, migrate)

rake db:reset

Another simple plugin for lazy developers.

By Matt Aimonetti