Search⌘ K
AI Features
Home
Courses
Docker for Rails Developers

Creating Our App Databases

Explore how to properly configure your Rails app to use Postgres instead of sqlite by editing database.yml and docker-compose.yml. Understand setting environment variables for secure database connections and integrating your database service within Docker containers.

We'll cover the following...

When we created our Rails project, we did so with the default settings, which assumed that we were using sqlite for our database. Now that we are setting up Postgres instead, the generated database.yml file is not correct. We need to change it to something more suitable.

File database.yml

File in config/database.yml looks like this:

YAML
# SQLite. Versions 3.8.0 and up are supported.
#   gem install sqlite3
#
#   Ensure the SQLite 3 gem is defined in your Gemfile
#   gem 'sqlite3'
#
default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000
development:
  <<: *default
  database: db/development.sqlite3
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *default
  database: db/test.sqlite3
production:
  <<: *default
  database: db/production.sqlite3

Modification

Let’s edit this file and replace its contents with the following ...