Pipelined Relational Query Language, Pronounced "Prequel"(prql-lang.org)

53 points by dmit 8 months ago | 39 comments

PRQL: A simple, powerful, pipelined SQL replacement(prql-lang.org)

3 points by KolmogorovComp 2 years ago | 0 comments

Revolutionizing PostgreSQL Schema Changes with pg-osc(mydbops.com)

77 points by willowcreek1 2 years ago | 12 comments

Show HN: Pgit – A Git-like CLI backed by PostgreSQL(oseifert.ch)

95 points by ImGajeed76 7 months ago | 43 comments

Putting DuckDB in Postgres to Query Iceberg(blog.paradedb.com)

72 points by philippemnoel 2 years ago | 17 comments

Show HN: How SQL Parsers Work(nishchith.com)

11 points by inishchith 9 months ago | 1 comments

Choose Postgres queue technology(adriano.fyi)

680 points by bo0tzz 3 years ago | 321 comments

Blog post by Adriano Caloiaro arguing for using Postgres-based queue technology for background jobs instead of dedicated queue systems.

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.

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.

PostgreSQL for Everything(raphaelbauer.com)

412 points by karlmush 2 months ago | 238 comments

A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.

Postgres LISTEN/NOTIFY does not scale(recall.ai)

547 points by davidgu 1 year ago | 283 comments

A Recall.ai engineering blog deep dive explaining why Postgres LISTEN/NOTIFY caused scaling problems in their production system.

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.