In focus
02
PostgreSQL and ClickHouse
OLTP, analytics and NAV reporting on one data layer.
- OLTP schema design — ready for Számlázz.hu, Billingo, and custom ERP integration.
- ClickHouse warehouse: NAV Online Számla export, BI reports, real-time webshop analytics.
- Streaming replication and a tested recovery plan (RPO 5 min, RTO 1 hour).
- Indexing and query tuning for ÁFA-return / month-end close peaks.
- Partitioning along Hungarian year-end reporting cycles (Jan / Jun / Dec).

