postgres protocol comunication - ghdrako/doc_snipets GitHub Wiki

• https://kviklet.dev/blog/parsing-the-postgres-protocol/
• https://ivdl.co.za/2024/03/02/pretending-to-be-postgresql-part-one-1/
• https://internals-for-interns.com/posts/postgres-connections-and-communication/
• https://www.postgresql.org/docs/current/protocol.html
• https://github.com/mickamy/sql-tap

PostgreSQL’s messaging protocol say how long the data is in the data itself.

Each response can be made up of multiple message types, for example the result of a SELECT statement will be a RowDescription message which returns the field name and type of each column, then a DataRow message for each row in the result, followed by a CommandComplete message. Having a message for each row makes it easier for the client to start parsing and processing large results while they are still being received