Get the latest tech news
Hacking the Postgres wire protocol
wire protocol Apr 14th, 2025 Lev Kokotov PgDog is a network proxy and it can see every byte sent between Postgres and the clients. It understands SQL and can infer where queries should go, without requiring changes to application code.
Either you don’t want to touch production (yet) or you just need to move some things around ad-hoc, you want engineers to be able to pre-process data in advance and have multiple ways to talk to your system. To make this work, PgDog handles partial CSV records and streaming binary data by buffering one complete row at a time. Since PgDog does all this at the network layer, it can run anywhere including managed clouds like AWS RDS, and works with Postgres clones like Aurora, AlloyDB and Cockroach.
Or read this on Hacker News