Multi-tenant SaaS Apps Made Simple on Azure Cosmos DB for PostgreSQL

Explore how to simplify multi-tenant SaaS application development using Azure Cosmos DB for PostgreSQL in this 44-minute conference talk from SQLBits. Learn about different multi-tenancy approaches, including row-based, schema-based, and database sharding. Discover unique features of Azure Cosmos DB for PostgreSQL that enable easy scaling and tenant management. Understand key concepts such as distribution keys, table types (distributed, reference, and local), and application modifications. Gain insights into upcoming monitoring capabilities in Citus 11.3, tenant isolation techniques, and data rebalancing strategies. Presented by Alicja Kucharczyk and Adam Wolk, this session provides valuable knowledge for developers looking to optimize infrastructure costs while ensuring isolation and performance in cloud-based SaaS applications.

Intro
Multi-tenant SaaS
Row based vs Schema Based vs Database Sharding
Azure Cosmos DB for PostgreSQL
Terminology
Pick a distribution key
Identify types of tables
Distributed Tables
Reference Tables
Local tables
Modify your application
Monitor - upcoming in Citus 11.3
Isolate tenant
Rebalance