Join us in this episode as we dive deep into the intricacies of NileDB, a groundbreaking database re-engineered for multi-tenant applications. Our special guest, Gwen Shapira, co-founder of NileDB and a notable figure in the database field, shares her insights and technical know-how on solving the common challenges faced by multitenant SaaS applications. From the benefits of using Postgres as the underlying database to the unique tenant isolation features of NileDB, we cover it all. Don't miss out on learning about AI native capabilities, handling schema migrations, and ensuring zero downtime data migrations.

Chapters:

00:00 Introduction

07:19 Challenges in Multi-Tenant Databases

11:09 Tenant Isolation and NILDB's Approach

34:16 Necessary Modifications for Tenant Data

37:47 Zero Downtime Data Migrations

44:32 Handling Schema Migrations

59:11 AI Use Cases and Vector Embedding Storage

59:51 Technical and Non-Technical Learnings from Building Nile

01:05:03 Future Plans and Upcoming Features

NileDB: https://www.thenile.dev/

Blog: https://www.thenile.dev/blog

Gwen's Linkedin: https://www.linkedin.com/in/gwenshapira

Gwen's Twitter: https://twitter.com/gwenshap

#postgres #sql #ai

Become a member of The GeekNarrator to get access to member only videos, notes and monthly 1:1 with me.

Like building stuff? Try out CodeCrafters and build amazing real world systems like Redis, Kafka, Sqlite. Use the link below to signup and get 40% off on paid subscription.

https://app.codecrafters.io/join?via=geeknarrator

If you like this episode, please hit the like button and share it with your network.

Also please subscribe if you haven't yet.

Database internals series: https://youtu.be/yV_Zp0Mi3xs

Popular playlists:

Realtime streaming systems: https://www.youtube.com/playlist?list=PLL7QpTxsA4se-mAKKoVOs3VcaP71X_LA-

Software Engineering: https://www.youtube.com/playlist?list=PLL7QpTxsA4sf6By03bot5BhKoMgxDUU17

Distributed systems and databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4sfLDUnjBJXJGFhhz94jDd_d

Modern databases: https://www.youtube.com/playlist?list=PLL7QpTxsA4scSeZAsCUXijtnfW5ARlrsN

Stay Curios! Keep Learning!