EC

Effect Community•8mo ago

Kam

Help Needed with Config and SqlClient for Database Querying Using Drizzle ORM

Hey guys, I could use some help with how to work with Config and the SqlClient.
As you can see in the image, i'm trying to set up a way to query my db through Drizzle orm.
The thing is, the

url

url

param passed to

PgClient.layer

PgClient.layer

has to be a type

redacted<string>

redacted<string>

.
I don't quite get how to obtain it (assuming the

DATABASE

DATABASE

var is part of my environment).

Another thing: I guess I need to do something to connect the

PgDrizzle

PgDrizzle

thing to my db schema (which is defined in another file, not in the image). Where should it be put?