Go Buffalo: Adding a 2nd database
Sep 4, 2020 - 1 minutesIf you need to connect to multiple databases in your buffalo app open up your
models/models.go
file:
Up at the top add a new var like:
1var YourDB *pop.Connection
then in the init()
func you can connect to it - the important part is to make
sure you call .Open
:
1 YourDB, err = pop.NewConnection(&pop.ConnectionDetails{
2 Dialect: "postgres",
3 URL: envy.Get("EXTRA_DB_URL", "default_url_here"),
4 })
5 if err != nil {
6 log.Fatal(err)
7 }
That’s it! You can now connect to a 2nd database from within your app.