Introducing pgzx: create PostgreSQL extensions using Zig(xata.io)

133 points by eatonphil 2 years ago | 36 comments

How TimescaleDB compresses time-series data(roszigit.com)

159 points by lkanwoqwp 4 months ago | 22 comments

Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync(pglite.dev)

441 points by samwillis 2 years ago | 99 comments

Homepage for PGlite, an embeddable WASM build of Postgres that runs in the browser, Node.js and Bun with reactive queries and server sync.

Understanding database indexes in PostgreSQL(blog.mastermind.dev)

230 points by mrpotato 3 years ago | 15 comments

PGlite – Embeddable Postgres(pglite.dev)

535 points by dsego 10 months ago | 105 comments

Homepage of PGlite, an embeddable Postgres build that runs a full database locally in WASM with reactivity and live sync.

Postgres Webhooks with Pgstream(xata.io)

145 points by mebcitto 2 years ago | 20 comments

PostgreSQL and UUID as Primary Key(maciejwalkowiak.com)

387 points by taubek 2 years ago | 296 comments

A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.

What I wish someone told me about Postgres(challahscript.com)

389 points by todsacerdoti 1 year ago | 161 comments

A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.

PostgreSQL reconsiders its process-based model(lwn.net)

761 points by todsacerdoti 3 years ago | 338 comments

LWN article by Jonathan Corbet on PostgreSQL developers discussing moving from a process-per-connection model to a threaded architecture.

Postgres SELECT DISTINCT Does Not Scale(dbos.dev)

83 points by KraftyOne 1 month ago | 26 comments

A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.

Go ahead, self-host Postgres(pierce.dev)

635 points by pavel_lishin 10 months ago | 373 comments

A blog post on pierce.dev arguing that self-hosting PostgreSQL is a reasonable alternative to managed database services.

The startup's Postgres survival guide(hatchet.run)

474 points by abelanger 3 months ago | 206 comments

A Hatchet blog post offering startups a guide to keeping their Postgres databases from falling over under load.