A quick script to export a database table to CSV is below. Drop into lib/tasks/export.rake (Rails), or directly into your Rakefile, then call at the command line:

Continue reading »

Migrations bother me.

On one hand, migrations are the best solution we have for the problem of versioning databases. The scope of that problem includes merging schema changes from different developers, applying schema changes to production data, and creating a DRY representation of the schema.

Continue reading »

DataMapper and Sequel both use urls for configuring database connections:

Continue reading »