Why we built yet another Postgres connection pooler

PgDog is a new Postgres connection pooler designed to avoid the "leaky abstractions" of existing solutions like PgBouncer and RDS Proxy, which require developers to abandon certain Postgres features when scaling. Unlike traditional poolers, PgDog includes a built-in SQL parser that manages connection state, allowing developers to continue using SET commands, LISTEN/NOTIFY, and Row Level Security without modifying application code or sacrificing functionality.