From SQL to Azure Cosmos DB

on YouTube ↗01h 01m

" summary

Shows moving a real ecommerce system from SQL → MongoDB → Azure Cosmos DB, swapping a connection string to use the MongoDB API and storing orders as single JSON documents so one query returns full order + line items. Documents carry copied immutable fields (price, name) to avoid cross-service joins. Uses outbox/inbox messaging for distributed transactions instead of multi-document ACID or stored procedures. Notes Gremlin and some Mongo features are missing, pricing and consistency choices (session/strong) affect design.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 2:49What is Azure Cosmos DB?
3. 15:32Transitioning from SQL
4. 33:21Transitioning from Transactioning in SQL

" related talks

• 01h 02mFrom SQL to Azure Cosmos DBJimmy Bogard · NDC Oslo 2018
• 18mNoSQL, YesCosmos: Build that Eventually Consistent Application using Azure Cosmos DBTeena Idnani · Azure Cosmos DB Conf 2024
• 03h 30mAmericas Live StreamGuillermo Rauch, Scott Hanselman, Kirill Gavrylyuk, Deborah Chen, Estefani Arroyo, Natasha Dias Over, Brandy Umdenstock · Azure Cosmos DB Conf 2022
• 14mUse EF Core to transition from SQL Server to Azure Cosmos DBArthur Vickers · Azure Cosmos DB Conf 2024
• 45mGetting the Most from NoSQL in the Cloud with Azure Cosmos DBJosh Lane · Oredev 2017
• 01h 01mServerless & Schemaless with Azure Functions and CosmosDBSantosh Hari · TechBash 2018
• 32mMigrating Graph from a (MariaDB & MongoDB) solution to Azure Cosmos DB's Gremlin APISubhasish Ghosh · Azure Cosmos DB Conf 2022
• 39mBuilding Event-Driven Systems at Scale with Cosmos DBShahab Ganji · Øredev 2024