Remote Ruby cover image

Remote Ruby

Decoding Postgres: A Journey Through User-Friendly Database Experiences with Craig Kerstiens

Dec 22, 2023
Join the podcast as guest Craig Kerstiens, a 12-year veteran of working with Postgres, discusses user-friendly database experiences, the challenges in marketing the platform to developers, and the importance of multi-tenancy. They also touch on the acquisition of Heroku and their transition to Crunchy, the benefits of visualization tools, using Postgres as a backend for Action Cable, and the concept of tracking changes in a database. Plus, they share a wild drink experience and recommend resources for learning more about Postgres.
51:21

Episode guests

Podcast summary created with Snipd AI

Quick takeaways

  • Schema-based sharding improves performance and data isolation for multi-tenant apps.
  • PG Bouncer enhances database performance and connection management in Rails apps.

Deep dives

The Value of Schema-based Sharding in Multi-Tenancy

Schema-based sharding provides a middle ground for multi-tenancy where you can query across schemas while maintaining data isolation. It helps with performance and improves the database query planner. Combining site is and apartment can be a great approach for building scalable multi-tenant apps. This approach is efficient and offers better data isolation compared to other methods.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode