My favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan Booz
Everyone learns differently. Grant Fritchey and Ryan Booz, database advocates at Redgate focusing on PostgreSQL, talk with co-hosts Claire Giordano and Pino de Candia to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one approach to build their knowledge.
Some of the (many) links shared in the order they were mentioned:
- Talk: Ryan’s talk Point-in-time query tuning and observability with pg_stat_statements at Citus Con: An Event for Postgres 2022
- Blog: Learning PostgreSQL with Grant, a series for SQL Server devs learning about Postgres
- Podcast: postgres.fm, a weekly podcast about all things Postgres
- Podcast: Path To Citus Con Episode 01: Working in public on open source
- Blog aggregator: Planet PostgreSQL
- Email Newsletters: Cooperpress, including the Postgres Weekly email
- Podcast: Scaling PostgreSQL with Creston Jamison
- User Groups: PostgreSQL Community User Groups
- Videos: pganalyze "5 minutes of Postgres," by Lukas Fittl
- Book: The Art of PostgreSQL, by Dimitri Fontaine
- Book: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya
- Book: SQL Performance Explained, by Markus Winand
- Blog: Modern SQL, by Markus Winand
- Blog: Use The Index, Luke, by Markus Winand
- Book: Database Administration, by Craig Mullins
- Book: A Curious Moon, by Rob Conery
- Book: The Little SQL Book, by Rob Conery, “Learn SQL While Watching Football This Weekend - Free!”
- Event: PGDay Chicago
- Blog: Redgate – Simple Talk
- Videos: CMU Database Group’s Talks on YouTube: Quarantine (2020), First Dose (2021), Second Dose (2021), Booster (2022)
- Crunchy Data’s Postgres Playground
- Blog: CYBERTEC
- Blog: Citus Open Source Blog
- Talk: How To Make Your Postgres Blog Posts Reach A Ton More People, by Claire Giordano
- Conference: PGCon 2023, super useful to watch recorded talks after the fact
- Conference: PGConf.EU, 2022, good example of an in-person event with lots of opportunities for learning
- Conference: Citus Con: An Event for Postgres 2023
- Conference: PGConf NYC 2023
- Blog Series: PGSQL Phriday, created by Ryan Booz
- Blog Series: PostgreSQL Person of the Week, by Andreas Scherbaum
- Blog: Robert Haas' blog
- Blog: select * from depesz;
- Book: PostgreSQL 14 internals, by Egor Rogov
Creators and Guests
Host
Claire Giordano
Claire Giordano is head of the Postgres & Citus open source community initiatives at Microsoft. Claire has served in leadership roles in engineering, product management, and product marketing at Sun Microsystems, Amazon/A9, and Citus Data. At Sun, Claire managed the engineering team that created Solaris Zones, and led the effort to open source Solaris.
Host
Pino de Candia
Pino de Candia is a software dev manager at Microsoft since 2020 and is currently working on the Citus open source project. Pino previously worked on the managed PostgreSQL database service in Azure Cosmos DB for PostgreSQL, which includes Citus on Azure support for distributed PostgreSQL. Pino has lived in New Orleans since 2017.
Producer
Aaron Wislang
Open Source Engineering + Developer Relations at @Microsoft + @Azure ☁️ | @golang k8s 🐧 🐍 🦀 ☕ 🍷📷 🎹🇨🇦 | 😷 💉++ (inc. bivalent) | @aaronw.dev (on 🟦sky)
Producer
Carol Smith
Senior Program Manager at Microsoft in the Citus Community team. Previously at GitHub and Google. Horseback rider, cook, and armchair movie critic.
