Reducing database costs to $1 with data modeling, Azure Web PubSub, and the Cosmos serverless plan

on YouTube ↗15m

" summary

A production digital checklist for factory batch changeovers replaces polling with Azure Web PubSub reliable pushes, sending the entire single-document checklist to clients so back-end writes stay to one Cosmos operation per change; concurrency uses etag retries. Migration from a Postgres setup costing about $280/month to Cosmos DB serverless uses ≈2.5M RUs/month (under $1/month), supports thousands of clients, multiplies savings across four environments, and cuts the Postgres CO2 footprint by ~22%.

AI-written summary · about

" chapters (7)

1. 0:00Introduction and background
2. 2:55Application evolution and challenges
3. 5:46Introducing Azure Web PubSub
4. 6:48Data modeling in Cosmos DB
5. 9:16Choosing Cosmos DB capacity mode
6. 11:50Cost comparison and savings
7. 13:59Key takeaways and conclusion

" related talks

• 33mDriver for Data-Driven Change - Azure Cosmos DB Performance, Security & Cost Optimization Done RightKristoffer Axelsson · Azure Cosmos DB Conf 2022
• 22mAzure Cosmos DB Serverless UnleashedMihail Mateev · SQLBits 2023
• 01h 00mCost cutting strategies for Azure Cosmos DBHasan Savran · NDC Porto 2022
• 02h 02mAzure Cosmos DB: LiftoffKirill Gavrylyuk, Estefani Arroyo, Iria Osara, Sai Krishna Srirampur, Claire Giordano · Azure Cosmos DB: Liftoff 2022
• 43mDatabase capabilities you need for your next awesome app Q&AAndrew Liu, Shawndell Elfring, Marc Shea, Ken Myers, Yoni Nijs, Nikisha Reyes-Grange, Michal Toiba · Microsoft Build 2023
• 01h 02mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Oslo 2018
• 45mGetting the Most from NoSQL in the Cloud with Azure Cosmos DBJosh Lane · Oredev 2017
• 27mAzure Cosmos DB Serverless UnleashedMihail Mateev · Azure Cosmos DB Conf 2022