ClickHouse + Laravel POC

Demographic Analytics

Real-time household & income insights aggregated from millions of records.

Admin MySQL Listing ClickHouse Listing

MySQL Operations DB

1,500,000 rows

Primary transactional database

ClickHouse Analytics DB

1,500,000 rows

Optimized for heavy analytical reads

Filtered Rows

214,615

Total Children

536,846

Max Children / Household

5

Income & Inequality Trends

How are key household income indicators trending over time?

2025

Mean Income

RM 80,017/yr

Median Income

RM 80,230/yr

Gini Coefficient

0.291

Aggregated by Salary Range

2025
Salary Range Total Households Avg Children Distribution
> RM 100k
76,931 2.50
RM 50k - RM 100k
76,216 2.50
RM 20k - RM 50k
46,139 2.51
< RM 20k
15,329 2.50