Gulcin Yildirim Jelinek: Maintaining Postgres for Modern Workloads

EP-191 | November 19, 2024 | 38:18

In this episode of Maintainable, Robby speaks with Gulcin Yildirim Jelinek, a Staff Database Engineer at Xata. Joining from Prague, Czech Republic, Gulcin discusses her experiences working with legacy databases, the evolution of Postgres, and her passion for building accessible tech communities.

Gulcin shares practical insights into modern database management, including the rise of automation tools like YAML and Pgroll, as well as how extensions like pgvector are unlocking new possibilities for Postgres users. Her work with the Prague PostgreSQL Meetup and Diva Conference highlights her dedication to fostering inclusive and welcoming tech communities.

Episode Highlights

  • [00:05:32] What Makes Databases Maintainable? Gulcin reflects on documentation, onboarding, and usability.
  • [00:15:10] From Legacy to Modern: Challenges with legacy systems in hospitals and banks and the transition to Postgres.
  • [00:22:18] Pgvector and Vector Search: Introducing Postgres extensions to enable vector-based queries.
  • [00:28:12] Scaling Automation with YAML: How YAML transformed database management and DevOps workflows.
  • [00:33:00] Fostering Community and Accessibility: Gulcin’s work with Postgres Europe and Diva Conference.
  • [00:36:15] Mythology with a Twist: Book recommendations featuring Circe and Elektra.

Key Takeaways

  • Documentation Matters: A well-documented system ensures effective onboarding for both developers and end-users.
  • Automation is Key: Tools like YAML and Pgroll streamline database operations, minimizing downtime and manual intervention.
  • Inclusivity in Tech: Conferences and communities should prioritize accessibility, from catering to translation services.
  • Vector Databases in Postgres: Pgvector is making Postgres a viable option for AI-driven workloads, eliminating the need for separate systems.

Resources Mentioned

Connect with Gulcin

Book Recommendations:

Links:

Thanks to Our Sponsor!

Turn hours of debugging into just minutes! AppSignal is a performance monitoring and error-tracking tool designed for Ruby, Elixir, Python, Node.js, Javascript, and other frameworks.

It offers six powerful features with one simple interface, providing developers with real-time insights into the performance and health of web applications.

Keep your coding cool and error-free, one line at a time! 

Use the code maintainable to get a 10% discount for your first year. Check them out!

🎧 Listen from Anywhere 🪐

You can find the Maintainable Software Podcast on all the usual places you can find tech podcasts.

Subscribe to the Maintainable Podcast Newsletter

Elevate your coding journey with insider insights from Robby and the pros. Discover the secrets to tackling technical debt and revitalizing legacy code, all in one place. Because who says you can't teach an old code new tricks?