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

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.