Episodes
-
Bharath Rupireddy has carved a niche for himself in the Postgres community since he began using the database system back in 2020. From his start at EnterpriseDB to making strides at Microsoft, and now contributing to the AWS open-source project, Bharath is entrenched in the inner workings of Postgres development. He has worked in many areas of Postgres such as WAL, Replication, pg_walinspect extension, bug fixes, performance improvements, new SQL functions etc.
In this episode we explore:
Starting with Postgres in 2020 and learning the basics while contributing to Parallel COPY featurePostgres recent features such as pg_walinspect extension, WAL source switch from archive to streaming, WAL insertion lock improvements, WAL read from buffers, more replication slot invalidation mechanisms like XID age based and inactive_timeout based ones, new table access methods for multi inserts.The future of native active-active replicationThe complexities of conflict resolutionUsing PostgreSQL 16 in production scenarios for active-active replicationThe role of databases evolving within different industriesLinks mentioned:
¡Databases! – A Database Seminar Series
Hacking Postgres, Ep. 9: Bertrand Drouvot
PGConf India
Hyderabad PostgreSQL User Group
PGConf.dev
Bharath on LinkedIn
Bharath on X (@BRupireddy)
Bharath on Github
-
As the podcast host of The Builders, member of Postgres Women, and Staff Engineer at EDB, Gülçin Yıldırım Jelínek is passionate to see where this space will take us. We kick off Season 2 with Gülçin as she shares her journey in the tech industry, CloudNativePG, the impact of AI on Postgres, and the representation of women in the Postgres community.
In this episode we explore:
CloudNativePG in Gülçin’s products and the new SPGVector releaseWelcoming new developers to the PostgreSQL communityTembo Cloud, PG vector, and the challenges and rewards of contributing to such innovative projectsImproving inclusivity and support for women in the tech industryThe use of Postgres in AI workloadsLinks mentioned:
The Builders: A Postgres Podcast
Gülçin Yıldırım Jelínek on X
EDB
Postgres Women on X
-
Missing episodes?
-
Alongside his peers studying Systems Network Engineering, Jelte Fennema-Nio unearthed a security vulnerability within the framework of Postgres. Since then, Jelte joined the world of cybersecurity and network engineering. He is currently Principal Software Engineer at Microsoft working on Citus/ Postgres/ PgBouncer.
In this episode we explore:
Forking and the impact of commercial entities on the core project The challenges of connection poolingThe suitability of Citus for scalabilityThe intricacies of configuring PgBouncerPaying attention to community needs and modernizing contribution methodsLinks mentioned:
Jelte on X
Jelte on LinkedIn
-
Amit Kapila is a PostgreSQL Committer and a Senior Director at Fujitsu India. Amit joins the show to share his contributions to logical replication enhancements (achieving highly available systems), his involvement in the PostgreSQL community, and his perspective on contributions from tech giants in advancing PostgreSQL features.
In this episode we explore:
Amit’s early work with PostgreSQL and OracleThe future of active-active topologyThe dependence on managed services for database managementThe importance of conflict resolution in replicationOvercoming the lack of an open-source development environment in IndiaLinks mentioned:
pgsql-hackers
Amit Kapila on LinkedIn
Amit Kapila on X (@kapila_amit)
Amit’s Blog
-
As Principal Architect at Tembo and the creator of PGXN, David Wheeler is a seminal figure in the Postgres world. Join us as we discuss David's tenure at The New York Times, his influential projects like Bricolage and pgTAP, and the game-changing database change management system, Sqitch.
In this episode we explore:
David Wheeler's transition from archaeology to databasesDatabase management and learning with SqitchWorking with PGXN and TemboCreating a central registry for Postgres extensionsThe state of Postgres and its versatilityLinks mentioned:
pgTAP
PGXN
CITEXT 2
Sqitch
Better Call Saul Insider Podcast
Scriptnotes
Just a Theory
-
Denis Magda is the mastermind behind the innovative extension PgCompute and a pivotal figure in the world of Postgres development. With over a decade and a half of experience, Denis cut his teeth on Postgres during its use in high-traffic social networking projects in Eastern Europe and has continued to push the envelope at Yugabyte as the head of Developer Relations.
In this episode we explore:
The role of Yugabyte in the Postgres ecosystemThe need for local development experiencesA more 'magical' and testing-friendly approach to handling stored proceduresThe intersection of DevRel with sales engineering and marketingThe future of Postgres in educational institutionsLinks mentioned:
Business Wars podcast
Postgres FM
Founders podcast
Denis on X
Denis on LinkedIn
Yugabyte
-
Andrew Atkinson is a Software Engineer who specializes in building high-performance web applications using PostgreSQL and Ruby on Rails. He wrote the book ‘High-Performance PostgreSQL for Rails’, published by Pragmatic Programmers in 2024.
Our discussion with Andrew spans the technical challenges of sharding and the concurrent evolution of Rails and Postgres. We'll pay homage to influential resources like Railscast, debate Rails' database tooling limitations, and discover tips from Andrew's new book.
In this episode we explore:
Why newer developers favor Postgres over MySQLHow Postgres might become a multi-primary database in the futureThe complexities of database decisions in a Rails environmentPostgres innovations, such as composite primary keys and common table expressions, being supported from Active Record – the ORM for Ruby on RailsKey insights from writing ‘High Performance PostgreSQL for Rails’Links mentioned:
Andrew Atkinson on LinkedIn
Andrew’s Blog
Newsletter
PGCasts
RailsCasts
‘High Performance PostgreSQL for Rails’ by Andrew Atkinson
Github rideshare
Postgres FM
Andrew Aktkinson’s interview on Postgres FM
Andrew Atkinson’s interview on Remote Ruby
Remote Ruby Podcast
GitHub doc: clarify logical decoding's deadlock of system tables
GitHub doc: Doc: fix grammatical errors for enable_partitionwise_aggregate
GitHub Convert README to Markdown
-
Just describing something truly novel is challenging, let alone building it. That’s the story of our final episode from Season 1, where Ry sits down with Tim Sehn from Dolthub to talk about the journey of building Dolt, the new release of Doltgres, and the challenges of adapting to the changing ways users engage with your product.
-
Build the thing you wish you had right now. That’s the story behind Hacking Postgres, Ep 9, where Ry sits down with Bertrand Drouvot of AWS Cloud. Today they talked about the struggles of trying to build from scratch vs having a template, what should be core vs an extension, and being able to see what’s really happening inside your database.
-
Search is simple in theory. In practice? Anything but. Join Ry for Episode 8 of Hacking Postgres, where he sits down with Philippe Noël of ParadeDB to talk about how search is evolving, the influence of AI, and the lessons you'd tell your younger self.
-
Postgres for everything? How about building a new cloud provider? Join us for Ep 7 of Hacking Postgres where Ry talks with Burak Yucesoy of Ubicloud about new clouds, getting attached to extensions, and the future potential of Postgres.
-
Ever wonder what it's like to build a geospatial extension for PostgreSQL? Join us for Episode 6 of Hacking Postgres, where Ry sits down with Regina Obe and Paul Ramsey, two of the key creators of PostGIS.
-
In this episode, Ry and Alexander talk about OrioleDB (and the challenge of fighting bloat), fuzzy and vector search, and the challenges behind database management.
-
Pavlo Golub is the Co-Founder of PostgreSQL Ukraine and a PostgreSQL expert at Cybertec. Pavlo created pg_timetable, an advanced standalone job scheduler for Postgres.
-
Eric Ridge is the primary developer of ZomboDB, “Making Postgres and Elasticsearch work together like it's 2023.” He’s also an active part of the pgrx and plrust teams.
-
Adam Hendel started his career in Military Intelligence before transitioning into the private sector as a Machine Learning Engineer for companies like UnitedHealth, C.H. Robinson, and Shipt. Now, as a Founding Engineer at Tembo, Adam spends his time creating extensions and figuring out how to make “Postgres for Everything” a reality.
-
Marco Slot spent nearly five years as lead engineer on Citus, an extension that turns Postgres into a distributed database. Citus Data was acquired by Microsoft in 2019, so these days Marco spends his time developing the Citus database engine which powers Azure Cosmos DB for PostgreSQL.