DEV Community

Tim Tran
Tim Tran

Posted on

Swapping Databases: SQLite to PostgreSQL for Deployment

I am officially graduated from Flatiron School coding bootcamp! But the work is never finished ;)

One of my goals was to upgrade my projects by deploying them and a couple of weeks ago I created a documentation on how to deploy your Rails & React app with Render for free! You can check out that article here. This will come in handy later.

I did some searching, but couldn't find exactly what I was looking for, so here is the compilation of deploying a Rails-React application that uses SQLite3.

We are going to dive into converting a SQLite3 database into PostgreSQL to deploy projects that you have created with SQLite3.

Step 1: Swapping out SQLite3 for PG

This first step is based on the assumption that you have postgres installed on your local machine.

First we need to locate our Gemfile, and make the update to the following:

gem "sqlite", "~> 1.4"
Enter fullscreen mode Exit fullscreen mode


gem "pg", "~> 1.1"
Enter fullscreen mode Exit fullscreen mode

then we are going to run the following in the terminal of the directory:

bundle install
Enter fullscreen mode Exit fullscreen mode

Step 2: Update database.yml file

This file will allow us to point to our database within our different levels of environment.

default: &default
  adapter: postgresql
  encoding: unicode
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

  <<: *default
  database: meal_time_app_development

  <<: *default
  database: meal_time_app_test

  <<: *default
  url: <%= ENV['DATABASE_URL'] %>
Enter fullscreen mode Exit fullscreen mode

(notice that database is name_of_your_app followed by the respective environment)

Step 3: Deleting SQLite3

We are going to look in the db folder and delete the following files development.sqlite3 and test.sqlite3

Step 4: Running Migration

We are now going to run the following in our directory:

rails db:create db:migrate db:reset
Enter fullscreen mode Exit fullscreen mode

Step 5: Follow the Guide to Deploying a React & Rails App.

You are all set! Now you can follow my previous post on deploying a Rails-React app using Render!


Now enjoy the luxury of deploying your projects on Render by converting your SQLite3 database to PostgreSQL.

Top comments (0)