Using a hardcoded DB url in Phoenix

When configuring a database connection, we usually supply values to the various keyword list elements in our config file like so:

config :store_db, Store.Repo, 
database: "store_db", 
username: "postgres", 
password: "postgres", 
hostname: "localhost" 

These values are used to generate the url string we will use to authenticate and connect to the database. Alternatively if you want to explicitly set a hardcoded database url string you can do that as well. The example below uses the keywords to show which part of the url string maps to which keyword.


Using our example above this would evaluate to:


And we can use that string in our config file like this:

config :music_db, MusicDB.Repo,
url: "postgres://postgres:postgres@localhost/store_db"

If you enjoyed this post you may also enjoy Postgres: create and execute database view