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