My favorite ways to learn more about PostgreSQL with Grant Fritchey and Ryan Booz
Description
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
Did you know that sometimes the fastest way of doing something is not having to do it at all? In this episode of Path To Citus Con, the podcast for developers who love Postgres, Michael Christofides joins Claire Giordano to chat about his journey to explaining explain (or should we say EXPLAIN!?)...
Published 05/03/24
You have to find what works for you and Chris Ellis has never been the kind of person that could go and sit in a library—for Chris, the most productive Postgres place is in a coffee shop. In this episode of the Path To Citus Con podcast for developers who love Postgres, Chris Ellis joined Claire...
Published 04/05/24