Proposal: improved database support about encore HOT 3 CLOSED

I like this idea a lot. It would be super helpful to be able to use third-party go SQL ORMs & mappers - honestly one of the biggest pain points with encore right now.

Thanks for the proposal @eandre!

from encore.

@eandre
hi is there any example of how to you encore with gorm.
sorry, i am new to golang I am comming from nodejs .just learn go a bit.
I need a way to get connect string from encore then I can use gorm.
Thank

from encore.

Hey @windwp, we should add some documentation on how to do this, but I suspect something like this should work:

import (
    "gorm.io/driver/postgres"
    "gorm.io/gorm"
    "encore.dev/storage/sqldb"
)

dialect := postgres.New(postgres.Config{
    Conn: sqldb.Named("mydb").Stdlib(),
})
db, err := gorm.Open(dialect, &gorm.Config{})

Let me know if you run into any issues!

from encore.