DT

Drizzle Team•3y ago•

6 replies

francis

Does calling `drizzle()` multiple times on the same db client instance consume more resources?

related to a question from: https://github.com/drizzle-team/drizzle-orm/issues/594

Would using the same

postgres(...)

postgres(...)

client instance and creating multiple Drizzle instances from it, e.g. one for each request in a middleware, consume additional database connection resources compared to creating one drizzle instance for the whole server process?

@Angelelz this is related to the question you asked in the github issue. I believe my current implementation doesn't have this problem since it uses proxies, but I was about to refactor to call

drizzle()

drizzle()

once per request and want to make sure I'm not about to blow up my database!

GitHub

[FEATURE]: Support PostgreSQL's Row Level Security (RLS) · Issue #5...

Describe want to want Supabase is really nicely using Row Level Secruity for granular authorization rules. Here's the link to their docs: https://supabase.com/docs/guides/auth/row-level-secur...