PostgREST Tutorial: APIs made easy(notso.boringsql.com)

20 points by radimm 2 years ago | 4 comments

Good CTE, Bad CTE(boringsql.com)

149 points by radimm 7 months ago | 34 comments

PostgreSQL's MVCC is bad. So is everyone else's(boringsql.com)

22 points by masklinn 2 months ago | 9 comments

How to check if two SQL tables are the same(github.com)

243 points by remywang 3 years ago | 108 comments

SQL Join Flavors(antonz.org)

65 points by nalgeon 3 years ago | 21 comments

How Do I Profile eBPF Code?(naveensrinivasan.com)

111 points by snaveen 3 months ago | 6 comments

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.

Instant database clones with PostgreSQL 18(boringsql.com)

386 points by radimm 10 months ago | 148 comments

A boringSQL blog post by Radim Marek explaining how to create instant database clones in PostgreSQL 18 for testing, migrations, and reproducible snapshots.

Making Postgres slower(byteofdev.com)

320 points by AsyncBanana 1 year ago | 35 comments

A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.

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.

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.