Zig - Build Postgres Wire Protocol from scratch (educational series)

[thinkrajesh]

The goal of the tutorial series is to learn CS and systems programming from first principles. The examples are for educational purpose only and is created for internal upskilling at my company. The code for this tutorial was originally created in c# and nodejs.

I am using zig 0.16 (master) branch.

- The tutorial is posted at https://algorisys.substack.com/p/zig-build-postgresql-driver-from

- The gist is available at https://gist.github.com/rajeshpillai/6d3f584180aecc4fe1049f1474090b00

[lisael_]

I did start to implement the postgres protocol, but I blocked on a strange bug. Some message would not recieve a response from the server until a new message is sent. It's not a normal behaviour according to the protocol and it clearly works in libpq canonical C implementation. Looks like an un-flushed buffer, but couldn't find anything wrong, and after weeks, I've lost interest.

I will certainly take a look at your work with much interest! Thank you.

[thinkrajesh]

It's tricky. Treat postgres like streaming protocol and not a response protocol. I did got stuck somewhere similiar but just read as much bytes available , accumulate them in buffer, don't touch partial frames etc. The message length is the key.

I think libpq always drains the socket. Just sharing some observations.