#​562 — July 10, 2024

Web Version

Postgres Weekly

pgPedia: A Postgres Encyclopedia of Sorts — An interesting, cleanly formatted wiki-esque reference guide to Postgres’ features and settings that complements the official documentation well. Well worth poking around a bit.

Postgrespedia

🎧 Say Hello to the Talking Postgres Podcast — The Path to Citus Con podcast was created to promote Citus Con (now POSETTE) by way of interviews with speakers and other Postgres luminaries, but has turned into a great Postgres podcast generally. To reflect this growth, it’s had a rebrand.

Claire Giordano (Microsoft)

Parallel Queries in Postgres — Support for running parts of a query in parallel (a.k.a. parallel queries) didn’t land in Postgres with a single big thump, so the feature is easily overlooked. Elizabeth gives us a quick primer.

Elizabeth Christensen

A Gentle Introduction to Window Functions — A good, tight introduction focused on the essentials.

Radim Marek

QUICK BITS:

  • We recently wrote about Robert Haas's proposed mentoring program for Postgres contributors and he has an update. 34 folks applied for the 14 spots, but Robert has created a Discord server for anyone interested in contributing to Postgres to hang out and get help.

  • Highgo's Grant Zhou is this week's PostgreSQL Person of the Week interviewee.

  • 🇳🇱 There's a new European Postgres event to add to the calendar! PGDay Lowlands. It takes place in Amsterdam this September.

Crunchy Bridge Adds Iceberg to Postgres — Crunchy Data has extended its Crunchy Bridge for Analytics platform with support for querying Iceberg tables, complete with full query pushdown and powerful write-through caching. (Iceberg is a table format specifically for large analytic datasets.)

Marco Slot (Crunchy Data)

📄 A Brief Guide to Auditing and Monitoring Access in Postgres Umair Shahid

📄 Automating Image Metadata Extraction with AWS Lambda, Go, and Postgres Hüseyin BABAL

📄 UUIDs as Primary Keys in Postgres Maciej Walkowiak

📄 Postgres Realtime Location Sharing with MapLibre – By way of Supabase Edge Functions. Thor Schaeff (Supabase)

🛠 Code and Tools

ETL Helper 1.0: Python Library for Database to Database Transfers — One for the Pythonistas. Works with Postgres, SQLite, SQL Server and Oracle, and we love that it comes from the British Geological Survey.

British Geological Survey