Video of a conference talk about building multi-tenant SaaS applications on Postgres by leveraging unique features in Azure Cosmos DB for PostgreSQL, a managed service powered by the open source Citus database extension. This talk was presented at Citus Con: An Event for Postgres 2023 by Alicja Kucharczyk and Adam Wołk. Cloud computing has given rise to a massive new market of SaaS applications built by ISVs and enterprises, however architecting these multi-tenant SaaS apps to optimize for underlying infrastructure cost-whilst still providing guarantees of isolation and performance-is hard.
The Azure Cosmos DB for PostgreSQL features explained in this talk will enable you to build and scale multi-tenant SaaS apps easily with a variety of tenant management features built natively into the database.
Alicja Kucharczyk works at Microsoft as Program Manager in Azure Database for PostgreSQL team, and is a PostgreSQL expert. She is both an experienced developer as well as administrator and PostgreSQL coach with strong practical knowledge of Linux and their mutual interactions. Alicja is particularly interested in performance optimization at different levels. Alicja has consulted with a lot of companies, supporting them in architecting, deploying, and maintaining PostgreSQL.
Adam Wolk is an OpenBSD developer who cares about database engineering, distributed systems, information security, and networking, with over a decade of experience with large and complex systems ranging from the corporate financial sector to the start-up landscape. Adam is an experienced team leader developed systems from the ground up from C on ARM devices, through back-end systems in Go, Python and Rails to web front ends in modern JavaScript frameworks-all continuously integrated, deployed, and monitored.
► Video bookmarks:
⏩ 00:00 Introduction
⏩ 00:53 Multi-tenant SaaS
⏩ 03:35 Sharding models
⏩ 07:28 Azure Cosmos DB for PostgreSQL
⏩ 11:29 Data modeling & distribution keys
⏩ 15:35 Table types
⏩ 20:25 Modify your application
⏩ 21:20 Monitoring
⏩ 25:13 Scaling out
✅ Learn more:
Watch more Citus Con 2023 talks: aka.ms/cituscon-playlist
📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: aka.ms/cituscon
📌 Let’s connect:  
Twitter - @CitusCon, / cituscon
⭐ Stay connected with the Citus open source project on GitHub: github.com/citusdata/citus
🔔 Subscribe to the Citus monthly technical newsletter: aka.ms/citus-newsletter
#CitusCon #PostgreSQL #Citus