Technical Specifications
Technical Architecture
Modern architecture and infrastructure for Analytics Bi
99.9%
Uptime SLA
5,000+
Concurrent Users
<200ms
API Response
3
Platform Modules
Architecture Overview
Civic Insight is a self-hosted, microservices-based analytics platform purpose-built for municipal government. The architecture centers on a star/snowflake schema data warehouse fed by configurable ETL pipelines from all Civic platform modules. Eleven focused services handle data ingestion, warehousing, query execution, dashboard rendering, predictive analytics, KPI management, geospatial processing, open data publication, report generation, data governance, and API gateway routing. Each service scales independently — query engine scales for concurrent dashboard users while ETL services scale for data volume. Full source code ownership means your IT team inspects, modifies, and deploys every component.
Platform Modules
Core Services
Eleven focused microservices handling data ingestion through API gateway routing, each independently deployable and scalable.
Total Modules
3
Protocol
REST / gRPC
Bus
Async Events
Container
Kubernetes
Database
PostgreSQL 16
Specifications
Technical Details
Browse specifications by category. All values reflect current production configuration.
Schema Design
Star / Snowflake
Storage Model
Columnar + Row
Partitioning
Range (date) + List
Retention Tiers
Hot / Warm / Cold
Min Retention
10 years (regulatory)
Compression
LZ4 / ZSTD columnar
Uptime
99.9% uptime for dashboard and query services during business hours Availability SLA
Active-passive failover with automated health checks. Canadian-hosted DR site with 1-hour RPO replication. ETL pipelines auto-resume from last successful checkpoint. Dashboard configurations replicated in real-time.
99.953%
30-Day Avg
1
Incidents
3× DC
Redundancy
< 15min
Recovery
30-Day Uptime History
All Systems Operational
Deployment
Self-Hosted Deployment
Deployed on municipal infrastructure or Canadian-hosted private cloud. Docker containers orchestrated with Kubernetes. Full source code provided under perpetual licence.
Linux server (Ubuntu 22.04 LTS or RHEL 9)
Municipal infrastructure deployment
Canadian-hosted private cloud
Kubernetes orchestration with Helm charts