Want more GoRails?

GoRails is packed full with 691 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

April 11, 2022

Track your progress

Sign in to track your progress and access subscription-only lessons.

Log In

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 83,038+ developers who get early access to new tutorials, screencasts, articles, and more.

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