There's no need to create a new connection per role. Simply use `SET ROLE`/`RESE... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		paulddraper on April 16, 2023 \| parent \| context \| favorite \| on: PostgreSQL Row Level Security There's no need to create a new connection per role. Simply use `SET ROLE`/`RESET ROLE`. https://www.postgresql.org/docs/15/sql-set-role.html

yencabulator on April 18, 2023 [–]

It does seem like that adds two round trips (SET ROLE, RESET ROLE) to each database interaction, though.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact