You're probably already using Postgres with Chelsea Dole & Floor Drees | Path To Citus Con Ep06
Drop the fear, not the tables. Chelsea Dole and Floor Drees join Claire and Pino to explore the app developer perspective on Path To Citus Con, the podcast for developers who love Postgres. If you’re an app developer, you’re probably already using Postgres. Now what? What do you need to know? Are databases your best friend or your worst enemy? They talk about the steps to becoming more Postgres-savvy. Should you go depth-first or breadth-first in learning more about the underlying database? What are Postgres extensions and how do you go about adopting them? Find out more about the strength of what Floor calls “boring technology.” Finally, both guests tell stories of their non-traditional entries into Postgres that led to their deep work with databases today.
Guests Chelsea Dole and Floor Drees:
Chelsea Dole is a Staff Software Engineer and Postgres DBA at Brex, a B2B fintech company. As the tech lead for the Data Storage team, she builds Postgres infrastructure, optimizes query performance, and seeks to up-level institutional database knowledge. Beyond work, she is involved in the Postgres open source community as a speaker, a volunteer for PgUS, and an always-curious learner.
Floor Drees is a Staff Community Program Manager at aiven.io. Previously at Grafana Labs and Microsoft, Floor is the champion supporter of (people in) open source software. She is a Devopsdays Core organizer, and runs several meetups.
Co-hosted by Claire Giordano and Pino de Candia:
Claire Giordano is head of the Postgres and Citus open source community initiatives at Microsoft. Prior to the Microsoft acquisition of Citus Data, Claire 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.
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.
Chapters:
⏩ 00:00 Intro to Path To Citus Con Ep06!
⏩ 01:51 How could knowing more about Postgres help you?
⏩ 05:29 Non-traditional paths to Postgres
⏩ 20:00 Key things for app developers learning more about Postgres
⏩ 34:16 Adopting new Postgres extensions
⏩ 51:15 Databases can be your best friend or your worst enemy
⏩ 58:00 Just ONE step to becoming more Postgres-savvy
⏩ 1:04:20 Questions that didn’t get asked
✅ Listen to more episodes of Path To Citus Con:
https://aka.ms/PathToCitusCon
📅 Subscribe to the monthly Path To Citus Con calendar:
https://aka.ms/PathToCitusCon-cal
Links from this episode:
🔹 Fintech startup where Chelsea works, Brex: https://www.brex.com/
🔹 Open source data platform where Floor works, Aiven: https://aiven.io/
🔹 “Mission-Critical PostgreSQL Databases on Kubernetes” by Karen Jex at KubeCon Europe 2023: https://www.youtube.com/watch?v=_NBQ9JmOMko
🔹 The Imposters Handbook by Rob Conery: https://bigmachine.io/products/the-imposters-handbook/
🔹 Designing Data-Intensive Applications by Martin Kleppmann: https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/
🔹 Devopsdays Amsterdam: https://devopsdays.org/events/2023-amsterdam/welcome/
🔹 Building Community in Open Source with Floor Drees on the Last Week in AWS podcast: https://www.lastweekinaws.com/podcast/screaming-in-the-cloud/building-community-in-open-source-with-floor-drees/
🔹 pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.html
🔹 PostGIS: https://postgis.net/
🔹 “Postgres tips for optimizing Django & Python performance, from my PyCon workshop” by Louise Grandjonc: https://www.citusdata.com/blog/2020/05/20/postgres-tips-for-django-and-python/
🔹 Video of Louise’s PyCon talk, Optimize Django & Python performance with Postgres superpowers: https://youtu.be/dyBLGjCQJHs
🔹 Grafana: https://grafana.com/
🔹 pganalyze: https://pganalyze.com/
🔹 auto_explain: https://www.postgresql.org/docs/current/auto-explain.html
🔹 EXPLAIN ANALYZE in PostgreSQL: https://www.postgresql.org/docs/current/sql-explain.html
🔹 psql: https://www.postgresguide.com/utilities/psql/
🔹 Path To Citus Con Episode 05: My favorite ways to learn more about PostgreSQL with Grant Fritchey and Ryan Booz: https://pathtocituscon.transistor.fm/episodes/my-favorite-ways-to-learn-more-about-postgresql-with-grant-fritchey-and-ryan-booz
🔹 Coffee Meets Bagel (dating app): https://coffeemeetsbagel.com/
#PathToCitusCon #CitusCon #PostgreSQL