Commit Redux

A software development blog in commit-sized retrospectives

Day 4 and 5 Redux — Deploying a Sinatra App with a Postgresql Database

Sunday May 11 2025 • 07:22 AM

I thought I was going to use sqlite for my production database too, but after failing to get it working with dokku I opted for postgres.

To get Commit Redux online, I

  • installed the postgres db service in dokku
  • linked the service to the app
  • created a seeds.rb file with a custom rake task
  • ran migrations
  • set domain and enabled lets encrypt
  • reset the production db id sequence with a custom SQL query
  • added user authentication