--- title: "Let's get talking Postgres" publication: "Postgres Weekly" issue: 562 published_at: "2024-07-10" canonical_url: "https://postgresweekly.com/issues/562" --- Plus a new Discord server for budding Postgres contributors. | #​562 β€” July 10, 2024 [Web Version](https://postgresweekly.com/issues/562) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/yqiptwwohrd7ygfo38of.jpg)](https://pgpedia.info/) [pgPedia: A Postgres Encyclopedia of Sorts](https://pgpedia.info/) β€” 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](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/say-hello-to-the-talking-postgres-podcast/ba-p/4186111) β€” The _Path to Citus Con_ podcast was created to promote _Citus Con_ (now [POSETTE](https://www.citusdata.com/posette/2024/)) 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](https://www.crunchydata.com/blog/parallel-queries-in-postgres) β€” Support for running parts of a query in parallel (a.k.a. [parallel queries](https://www.postgresql.org/docs/current/parallel-query.html)) 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](https://notso.boringsql.com/posts/window-functions-introduction/) β€” 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](https://www.postgresql.org/message-id/CA%2BTgmob1A9F0vP%2B9716JMRoHrw%3Ds2eA%3D%3DLnw3hpP_qmoAGz8JQ%40mail.gmail.com) and he [has an update.](https://rhaas.blogspot.com/2024/07/mentoring-program-updates.html) 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](https://postgresql.life/post/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.](https://vyruss.org/blog/pgday-lowlands-dba-day-2024.html) It takes place in Amsterdam this September. [Crunchy Bridge Adds Iceberg to Postgres](https://www.crunchydata.com/blog/crunchy-bridge-adds-iceberg-to-postgres-and-powerful-analytics-features) β€” 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](https://iceberg.apache.org/) is a table format specifically for large analytic datasets.) Marco Slot (Crunchy Data) πŸ“„ [A Brief Guide to Auditing and Monitoring Access in Postgres](https://stormatics.tech/blogs/guide-to-auditing-and-monitoring-access-in-postgresql) Umair Shahid πŸ“„ [Automating Image Metadata Extraction with AWS Lambda, Go, and Postgres](https://docs.rapidapp.io/blog/automating-image-metadata-extraction-with-aws-lambda-go-and-postgresql) HΓΌseyin BABAL πŸ“„ [UUIDs as Primary Keys in Postgres](https://maciejwalkowiak.com/blog/postgres-uuid-primary-key/) Maciej Walkowiak πŸ“„ [Postgres Realtime Location Sharing with MapLibre](https://supabase.com/blog/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](https://github.com/BritishGeologicalSurvey/etlhelper) β€” One for the Pythonistas. Works with Postgres, SQLite, SQL Server and Oracle, and we love that it comes from the [British Geological Survey.](https://www.bgs.ac.uk/) British Geological Survey - [PostGIS 3.5.0.alpha2](https://postgis.net/2024/07/PostGIS-3.5.0alpha2/) – The powerful geospatial toolkit for Postgres. - [River 0.9](https://github.com/riverqueue/river) – Fast and reliable Postgres-powered background jobs for Go. - [ParadeDB 0.8.3](https://github.com/paradedb/paradedb) – Postgres for search and analytics. - [pg-promise 11.9](https://github.com/vitaly-t/pg-promise) – Postgres interface for Node.js. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).