Maintainable

Gulcin Yildirim Jelinek: Maintaining Postgres for Modern Workloads


Listen Later

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
  • Xata Blog
  • Pgroll
  • Prague PostgreSQL Meetup
  • Diva: Dive into AI Conference
  • Kadin Yazilimci (Women Developers of Turkey)
  • Circe by Madeline Miller
  • Elektra by Jennifer Saint
Connect with Gulcin
  • LinkedIn
  • Prague PostgreSQL Meetup
  • Diva Conference
Book Recommendations:
  • Circe
  • Elektra
Links:
  • Kadin Yazilimci (Women Developers of Turkey)
  • Diva: Dive into AI Conference
  • Prague PostgreSQL Meetup
  • On X
  • Xata Blog
  • Pgroll
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!

Subscribe to Maintainable on:

  • Apple Podcasts
  • Spotify

Or search "Maintainable" wherever you stream your podcasts.

Keep up to date with the Maintainable Podcast by joining the newsletter.

...more
View all episodesView all episodes
Download on the App Store

MaintainableBy Robby Russell

  • 5
  • 5
  • 5
  • 5
  • 5

5

30 ratings


More shows like Maintainable

View all
Hanselminutes with Scott Hanselman by Scott Hanselman

Hanselminutes with Scott Hanselman

378 Listeners

Software Engineering Radio - the podcast for professional software developers by se-radio@computer.org

Software Engineering Radio - the podcast for professional software developers

265 Listeners

The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

285 Listeners

Thoughtworks Technology Podcast by Thoughtworks

Thoughtworks Technology Podcast

43 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

580 Listeners

Software Engineering Daily by Software Engineering Daily

Software Engineering Daily

624 Listeners

Soft Skills Engineering by Jamison Dance and Dave Smith

Soft Skills Engineering

271 Listeners

Go Time: Golang, Software Engineering by Changelog Media

Go Time: Golang, Software Engineering

128 Listeners

JS Party: JavaScript, CSS, Web Development by Changelog Media

JS Party: JavaScript, CSS, Web Development

94 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

987 Listeners

REWORK by 37signals

REWORK

212 Listeners

CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

CoRecursive: Coding Stories

185 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners

Oxide and Friends by Oxide Computer Company

Oxide and Friends

48 Listeners

The Pragmatic Engineer by Gergely Orosz

The Pragmatic Engineer

50 Listeners