While deploying an initial version of Crapper Keeper, I ran into a problem with Heroku.  Deploying to Heroku is super easy, since you just have to deploy a Github branch and the site is live a few moments later.  My app, which was running well locally, suddenly was having database problems.

Crapper Keeper is a Ruby on Rails app.  Rails comes with SQLite out of the box, but Heroku doesn’t support SQLite.  So after a lot of searching, I was able to find a way to change the database from SQLite to PostgreSQL.  One guide I found handy was on Stack Overflow and here.

One tip, that I forgot, was that you have to make the database but then also remember to migrate the database, using rake db:migrate