Want more GoRails?

GoRails is packed full with over 350 lessons just like this one.

Sign up to get full access or log in to your account and sit back.

Testing Against Multiple Databases in Rails with The DATABASE_URL Env Var

#441 ยท April 11, 2022

Your Teacher

Hi, I'm Chris. I'm the creator of GoRails, Hatchbox.io and Jumpstart. I spend my time creating tutorials and tools to help Ruby on Rails developers build apps better and faster.

About This Episode

Rails apps and Rubygems might need to support multiple databases. We can use the DATABASE_URL environment variable to quickly swap out the database that Rails uses in CI, local testing, and more.


Postgres Rails Database URL example:

DATABASE_URL=postgres://username:password@localhost/mydb rails test

MySQL Rails Database URL example:

DATABASE_URL=mysql2://username:password@localhost/mydb rails test

SQLite Rails Database URL example:

DATABASE_URL=sqlite3:mydb rails test

Want to stay up-to-date with Ruby on Rails?

Join 74,071+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2023 GoRails, LLC. All rights reserved.