

From Apache Kafka to PostgreSQL, PostgreSQL maturity and extensions, and building on PostgreSQL with Gwen Shapira (CPO at Nile)
Oct 25, 2024
Gwen Shapira, co-founder and CPO of Nile, is a notable force in the PostgreSQL world after leading Kafka development at Confluent. She shares her journey from cloud-native technologies to the PostgreSQL community, highlighting its vibrant evolution. Interesting discussions include PostgreSQL 17's new features, the integration of vector embeddings for AI applications, and the importance of SSL for secure connections. Gwen also explores how PostgreSQL supports diverse SaaS applications, emphasizing its flexibility and scalability.
AI Snips
Chapters
Transcript
Episode notes
Gwen Reminisces O'Reilly Strata
- Gwen Shapira reminisces about O'Reilly Strata, valuing its vendor-neutral, practitioner-focused environment.
- She contrasts this with her new engagements in Postgres and JavaScript conferences, noting their unique vibes.
Postgres' Deep History & Reliability
- PostgreSQL has a rich 30+ year history with developers maintaining contributions over decades.
- Its releases are predictably scheduled, making it one of the most reliable open source projects.
Use Hypothetical Indexes for Optimization
- Use PostgreSQL extensions like HypoPG to create hypothetical indexes and test performance without affecting production.
- This helps optimize workloads by predicting indexing effects before committing resources.