My favorite ways to learn more about PostgreSQL w/Grant Fritchey & Ryan Booz |Path To Citus Con Ep05
▪️Everyone learns differently. Join guests Grant Fritchey and Ryan Booz with co-hosts Claire Giordano and Pino de Candia in this episode of Path To Citus Con, the podcast for developers who love Postgres. They 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? Most people need much more than one approach to build their knowledge.
Guests:
Grant Fritchey is a Microsoft Data Platform MVP and AWS Community Builder. He has more than 30 years of experience in IT technical support, development, and database administration. He currently works as Product Advocate at Red Gate Software.
Ryan Booz is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.
Co-hosted by:
Claire Giordano is head of the Postgres and Citus open source community initiatives at Microsoft.
Pino de Candia is a software dev manager at Microsoft since 2020 and is currently working on the Citus open source project.
Chapters:
⏩ 00:00 Intro to Path To Citus Con Ep05!
⏩ 01:42 Favorite types of resources for learning
⏩ 06:55 Need-driven learning vs. Curiosity
⏩ 10:48 Postgres places for getting started
⏩ 22:54 Books & resources for those who read
⏩ 33:39 What about online courses?
⏩ 41:23 Is attending conferences a good way to learn?
⏩ 56:54 Recordings: video, audio, conference talks
⏩ 1:04:10 Reading blogs, writing blogs, and blog resources
📅 Subscribe to the calendar: https://aka.ms/PathToCitusCon-cal
Links from this episode:
▪️ Ryan’s talk about pg_stat_statements from Citus Con: An Event for Postgres 2022: https://www.youtube.com/watch?v=wTmKGyiqoCk&list=PLlrxD0HtieHjSzUZYCMvqffEU5jykfPTd&index=34&pp=iAQB
▪️ Learning PostgreSQL with Grant, a series for SQL Server devs learning about Postgres: https://www.red-gate.com/simple-talk/databases/postgresql/manipulating-data-in-postgresql-learning-postgresql-with-grant/
▪️ postgres.fm, a weekly podcast about all things PostgreSQL: https://postgres.fm
▪️ Path To Citus Con Episode 01: Working in public on open source: https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-source
▪️ Planet PostgreSQL: https://planet.postgresql.org/
▪️ Cooperpress, including the Postgres Weekly email: https://cooperpress.com/publications/
▪️ Scaling PostgreSQL with Creston Jamison: https://www.scalingpostgres.com/
▪️ PostgreSQL Community User Groups: https://www.postgresql.org/community/user-groups/
▪️ Videos: pganalyze “5 minutes of Postgres,” by Lukas Fittl: https://www.youtube.com/playlist?list=PLhqxwIAgz78HZhWyu3UyKrCWNk7VWjVpj
▪️ The Art of PostgreSQL, by Dimitri Fontaine: https://theartofpostgresql.com/
▪️ PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya: https://www.amazon.com/PostgreSQL-Query-Optimization-Ultimate-Efficient/dp/1484268849
▪️ Modern SQL, by Markus Winand: https://modern-sql.com/
▪️ SQL Performance Explained, by Markus Winand: https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826
▪️ Use The Index, Luke, by Markus Winand: https://use-the-index-luke.com/
▪️ Database Administration, by Craig Mullins: https://www.amazon.com/Database-Administration-Complete-Practices-Procedures-ebook/dp/B009PM38TE
▪️ A Curious Moon, by Rob Conery: https://bigmachine.io/products/a-curious-moon/
▪️ The Little SQL Book, by Rob Conery: https://bigmachine.io/little-sql-book/
▪️ PGDay Chicago: https://2023.pgdaychicago.org/
▪️ Redgate – Simple Talk: https://www.red-gate.com/simple-talk/
▪️ CMU Database Group Talks on YouTube: https://www.youtube.com/c/cmudatabasegroup
▪️ CYBERTEC: https://www.cybertec-postgresql.com/en/blog/
▪️ Citus Open Source Blog: https://www.citusdata.com/blog/
▪️ How To Make Your Postgres Blog Posts Reach A Ton More People By Claire Giordano https://speakerdeck.com/clairegiordano/how-to-make-your-postgres-blog-posts-reach-a-ton-more-people-claire-giordano-pgconf-eu-2022
▪️ PGCon 2023: https://www.pgcon.org/2023/
▪️ PGConf.EU, 2022: https://2022.pgconf.eu/
▪️ Citus Con: An Event for Postgres 2023: https://aka.ms/cituscon-playlist
▪️ PGConf NYC 2023: https://2023.pgconf.nyc/
▪️ Ryan’s blog PGSQL Phriday: https://www.pgsqlphriday.com/
▪️ PostgreSQL Person of the Week, by Andres Scherbaum: https://postgresql.life/
▪️ Robert Haas’ blog: http://rhaas.blogspot.com/
▪️ select * from depesz; https://www.depesz.com/
▪️ PostgreSQL 14 internals, by Egor Rogov: https://edu.postgrespro.com/postgresql_internals-14_en.pdf
Comments are closed.