About This Architecture
Production-grade Azure web application architecture featuring a React frontend hosted on Static Web Apps, Node.js API on App Service, and dual-database strategy. Users access the React frontend via Static Web Apps, which communicates with a Node.js API layer on App Service. The API integrates Azure Cache for Redis for session management and caching, connects to SQL Database for transactional platform data, and queries a ClickHouse reporting database on a Virtual Machine for analytics workloads. This architecture demonstrates separation of concerns between operational and analytical data stores, enabling high-performance reads while maintaining ACID compliance for transactions. Fork this diagram on Diagrams.so to customize caching policies, swap ClickHouse for Azure Synapse, or add Application Insights monitoring.