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!?) Michael shared his origin story as a mathematician and his first experience with Postgres before walking us through co-founding a Postgres company and now co-hosting a podcast. Like many in the...

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 and Pino to chat about his path to becoming more (and more) expert at using PostgreSQL. Curiosity may have killed the cat but it’s taken Chris places, beginning as a 5 year old playing with QBASIC....

Everywhere you look, people are talking about AI. From Copilot to ChatGPT to Postgres’s powerful AI capabilities (think: pgvector), AI is everywhere. In this episode of Path To Citus Con, for developers who love Postgres, Arda Aytekin joined Claire and Pino to chat about spinning up on Postgres and AI. Arda shared his origin story in mechanical engineering and data science before walking us through vector databases, pgvector, and azure_ai. Arda is one of the creators of the azure_ai...

The best days are when things don’t go as planned. Derk van Veen joined Claire Giordano and Pino de Candia on this podcast for developers who love Postgres—to discuss his journey from Java developer to PostgreSQL specialist and DBA. From his first days with DB2 and Oracle, to his work with Postgres, Derk shared how he learned about databases. And how a very smart colleague would break the database on purpose, to give Derk the tough job of fixing it. Another topic: what to do when you need to...

No one likes benchmarking. But it can be one of the highest impact things you do. Jelte Fennema-Nio and Marco Slot joined Claire Giordano and Pino de Candia on this podcast for developers who love Postgres—to discuss their journeys into performance benchmarking. And how it can change the course of your career. Do you need to find bottlenecks in your Postgres? Do you want to build skills with database benchmarks? There are many lovely benchmarking tools in the Postgres world: HammerDB,...

Do you monitor your Postgres error logs for gold? Lukas Fittl and Rob Treat join Claire Giordano and Pino de Candia on the Path To Citus Con podcast for developers who love Postgres—to discuss their respective journeys into Postgres monitoring. Have you ever asked yourself: “Why is my query so slow?” Or had to figure out which query is slowing things down? Or why your database server is at 90% CPU? There are so many ways to monitor Postgres: pganalyze, pgMustard, pgBadger, pgDash, your cloud...

Is being lazy a good reason to learn SQL? Dimitri Fontaine and Vik Fearing join Claire Giordano and Pino de Candia on the Path To Citus Con podcast for developers who love Postgres—to discuss whether every data problem can be (or should be) solved in SQL. Have you tried to solve all the Advent of Code puzzles with SQL? Or written a book for application developers about The Art of PostgreSQL? Or tried to solve a murder mystery by running SQL queries? Regardless of whether you pronounce SQL as...

Lots of stories of how folks got started as developers! Andres Freund and Heikki Linnakangas join Claire Giordano and Pino de Candia to explore more paths for getting into Postgres on Path To Citus Con, the podcast for developers who love Postgres. How do you do development: with a cup of coffee, with music in the background, maybe at 3am? How do you approach mentoring other developers? Why did you stick with Postgres and make it a career? Lots of lively discussion about building not only...

The geospatial world of Postgres is so much more than mapping. Paul Ramsey and Regina Obe join Claire Giordano and Pino de Candia to explore the "where" on Path To Citus Con, the podcast for developers who love Postgres. What are some of the unexpected use cases for PostGIS, one of the most popular extensions to Postgres? How have Large Language Models helped in the geospatial world? Can you really model almost anything with pgRouting? “Where” is the universal foreign key. They talk about...

Drop the fear, not the tables. Chelsea Dole and Floor Drees join Claire Giordano and Pino de Candia 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 order to learn more about...

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...

Melanie Plageman, a PostgreSQL hacker working at Microsoft, and Thomas Munro, PostgreSQL developer and committer also as Microsoft talk with co-hosts Claire Giordano and Pino de Candia. They talk through all the different ways they got started as developers. Does making your first patch to Postgres get you hooked for a lifetime? Do you have to be a tinkerer to be a good software engineer? What is the “toothbrush test”—and how do you make your avocation be your vocation? We hear stories about...

Álvaro Herrera, and Boriss Mejías, both longtime members of the Postgres developer community, explore the value of giving conference talks—as well as the work involved, the time it takes, and the many different types of conference talks, including presentations about about failure and things that have gone wrong.   Claire and Pino guide the conversation on questions like: Should you add humor to your talks? How does your personality—introvert or extrovert—affect your conference presentations?...

Join Claire and Pino as they talk with Citus and Postgres open source team members to explore how to get Postgres ready for the next 100 million users. What will future Postgres users look like? How will the Postgres development process evolve with more users? What are the common challenges faced by Postgres users?   Citus open source team members Abdullah Ustuner and Burak Yucesoy are joined by Postgres open source teammates Melanie Plageman and Samay Sharma—and co-hosts Claire Giordano and...

Simon Willison is the creator of Datasette and co-creator of Django. Marco Slot is the lead architect for the Citus database extension to Postgres. In this episode, Simon and Marco talk about working in public on open source. Simon shares many of his learnings in public—with weeknotes, tweets, blogs, and “today I learned” (TIL) posts. Marco has been developing Citus in public since it was first open sourced in 2016.    Hosted by Claire Giordano and Pino de Candia from the Postgres team at...