Database setup for production in Ruby on Rails - Mini Project: Build & Apply

Database setup for production

📖 Scenario: You are preparing a Ruby on Rails application to run in a production environment. This means setting up the database configuration correctly so the app can connect to the production database server.

🎯 Goal: Build a Rails database configuration file config/database.yml with a production section that uses PostgreSQL with the correct settings.

📋 What You'll Learn

Create a production section in config/database.yml

Set the adapter to postgresql

Set the database name to myapp_production

Set the username to myapp_user

Set the password to securepass

Set the host to db.example.com

💡 Why This Matters

🌍 Real World

Rails apps need a production database config to connect to real databases when deployed.

💼 Career

Understanding how to configure production databases is essential for backend and full-stack developers working with Rails.

1

Create the production section in database.yml

In config/database.yml, create a production: section with indentation two spaces. Add the line adapter: postgresql under it.

Ruby on Rails

production:
  # Your code here

Need a hint?

Remember YAML uses indentation with spaces. Use two spaces before adapter.

2

Add database name and username

Under the production: section, add the lines database: myapp_production and username: myapp_user with two spaces indentation.

Ruby on Rails

production:
  adapter: postgresql
  # Your code here

Need a hint?

Keep the same indentation level for these keys as adapter.

3

Add password and host

Add the lines password: securepass and host: db.example.com under the production: section with two spaces indentation.

Ruby on Rails

production:
  adapter: postgresql
  database: myapp_production
  username: myapp_user
  # Your code here

Need a hint?

Make sure the indentation matches the other keys.

4

Complete the production database configuration

Ensure the production: section in config/database.yml includes all these lines exactly with correct indentation: adapter: postgresql, database: myapp_production, username: myapp_user, password: securepass, and host: db.example.com.

Ruby on Rails

production:
  adapter: postgresql
  database: myapp_production
  username: myapp_user
  password: securepass
  host: db.example.com
# Verify your configuration is complete

Need a hint?

Double-check all lines and indentation for correctness.