Apr 14th, 2025Lev 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. In this article, we discuss how we handle the Postgres wire protocol and manipulate it to serve queries to multiple databases at the same time. Protocol basics Postgres has two ways to send queries over the network: Simple protocol Extended protocol The simple protocol is called...