I've been using Postgres for many years, and this is my effort to collect and curate some common patterns, best practices, and tricks I've learned -- narrated in the form of my conversations with LLMs.
Recursively querying hierarchical data in Postgres A pedagogical tutorial on using the `WITH RECURSIVE` clause to query hierarchical data in Postgres.