nowfound

Dev tools · April 22, 2023

UP

Understand Postgres wire protocol by writing a simple program

Link to the repo https://github.com/viggy28/pglite

Understand Postgres wire protocol by writing a simple program launched on April 22, 2023 with 11 votes, #1,684 of 4,853 launches that month and more than 75% of that year's launches. The site was still online in September 2026, 3 years on.

In plain words

This educational project helps developers understand the PostgreSQL wire protocol by building a simple program from scratch. It's designed for software engineers and database enthusiasts who want to learn how PostgreSQL client-server communication works at a fundamental level. The repository provides hands-on code examples that demonstrate protocol implementation concepts.

written from the facts on this page · September 2026

From the sources

A gentle introduction to postgres wire protocol in Go

I kept hearing about the term wire protocol especially Postgres wire protocol in the recent days (Looking at you cockroachdb, yugabytedb - in a good way) but never really quite understood it. Decided to implement something simple in Go to understand it better. As always, if you find anything wrong or I misunderstood please correct me. Refer https://www.postgresql.org/docs/current/protocol.html and https://www.postgresql.org/docs/current/protocol-flow.html . If you are like me who has seen those links multiple times but didn’t know how to implement something using that, then this is for you :) Also, if you just want to get to the code, it is here . The first step is…from viggy28.dev

Does a similar job

all alternatives →
  • PGlite – in-browser WASM Postgres with pgvector and live sync2024 · pglite.dev · ▲509

    Hey, Sam and the team from ElectricSQL here. PGlite is a WASM Postgres build packaged into a TypeScript/JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It's 3mb Gzipped, now has support for many Postgres extensions, including pgvector, and it has a reactive "live query" API. It's also fast, with CRUD style queries executing in under 0.3 ms, and larger, multi-row select queries occurring within a fraction of a single frame. PGlite started as an experimental project we shared on X, and the…

  • A simple demo of Postgres wire protocol and SQLite as storage engine2024 · github.com · ▲14

    postgres + sqlite = pglite. Contribute to viggy28/pglite development by creating an account on GitHub.

  • pgwire-replication - pure rust client for Postgres CDCJan 2026 · github.com · ▲46

    Lean tokio-based Postgres wire-protocol logical replication client (pgoutput) with TLS and SCRAM. - vnvo/pgwire-replication

  • Pg_replicate – Build Postgres replication applications in Rust2024 · github.com · ▲216

    A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl

  • Dbdot – Golang tool to help generate Postgres schema diagrams2019 · github.com · ▲119

    Generate DOT description for postgres db schema. Contribute to akarki15/dbdot development by creating an account on GitHub.

  • GraphQL for Postgres2015 · github.com · ▲195

    GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.

More dev tools this month

the category →
  • Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.

    Dev tools · 1d ago · github.com

  • /dev/null▲492

    a social network for devs

    Dev tools · 4d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 29d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 24d ago · openbot.run

  • Talanoa▲346

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 22d ago · talanoa.email

Source: Show HN post ↗

Launched alongside, April 2023

the whole month →
  • Guidde AI▲1,476

    Create video documentation instantly with the magic of AI

    AI · 2023 · guidde.com

  • G4

    Hi HN, Today we’re launching GPT-4 answers on Phind.com, a developer-focused search engine that uses generative AI to browse the web and answer technical questions, complete with code examples and detailed explanations. Unlike vanilla GPT-4, Phind feeds in relevant websites and technical documentation, reducing the model’s hallucination and keeping it up-to-date. To use it, simply enable the “Expert” toggle before doing a search. GPT-4 is making a night-and-day difference in terms of answer quality. For a question like “How can I RLHF a LLaMa model”, Phind in Expert mode delivers a…

    AI · 2023 · phind.com

  • Lago▲1,013

    Open-source alternative to Stripe Billing and Chargebee

    Dev tools · 2023 · getlago.com

  • Chatscout▲691

    Shopping assistant powered by ChatGPT for e-commerce brands

    AI · 2023

  • Fabric▲690

    Make notes, tasks, and search, directly from the terminal.

    AI · 2023 · fabric.so

  • Rask AI▲683

    Say it in any language, AI based, sounds as good as a human

    AI · 2023 · rask.ai