Company
Date Published
Author
Andi Pangeran
Word count
1227
Language
English
Hacker News points
None

Summary

Electrum, Indonesia's leading electric motorcycle company, is shifting towards low-carbon, sustainable transport. The company's rapid expansion has triggered a massive data surge from IoT sensors and transactional data. To address this challenge, Electrum adopted ClickHouse, a columnar storage database that enables lightning-fast queries, processing only relevant data. This solution provides flexibility, efficiency, and scalability, allowing business users to query raw and aggregated data independently. With materialized views, Electrum can quickly summarize and analyze IoT data points in real-time, reducing processing time by up to 90%. The company has seen significant improvements in cost efficiency, with costs under $500 per month, and plans to scale its implementation to a multi-server setup. Electrum's journey showcases the power of the right database in solving complex challenges at scale, supporting their growing fleet, optimizing performance, and delivering real-time business insights.