Technology Insights

Rants About Rails Database Migrations

Migrations as version control for databases When I first learned about Rails migration, I immediately thought that dropping down a revision would be something you would do often. In actuality, Rails migrations is more like a version control for databases. Since databases changes require modifications to both code and data, you cannot simply use a…

Technology Insights

Making (and Verifying) the Migration to PostgreSQL in Rails

Install After installing PostgreSQL on Windows, I converted my Rails application from MySQL to PostgreSQL with the following steps: Create a new database in PostgreSQL Installed postgres-pr gem (Ruby driver) because the postgres gem (native driver) didn’t work. Will figure out why later on. Changed the appropriate Rails config stuff in database.yml development: adapter: postgresql…