Hasty Briefsbeta

Bilingual

Ten years of ClickHouse in open source

4 days ago
  • #open source
  • #analytical database
  • #database development
  • ClickHouse was open-sourced on June 15, 2016, and has since become a leading open-source analytical database with over 2000 contributors.
  • The author advocates for Level 3 open-source development, emphasizing transparent processes, contribution guidelines, and comprehensive documentation.
  • ClickHouse serves as an exemplary codebase for learning database construction, modern C++ development, and experimenting with data structures and performance optimizations.
  • The project's history traces back to prototypes from 2008-2009, evolving from custom data structures for web analytics to a full-fledged column-oriented database.
  • Key development milestones include the introduction of in-memory columns, aggregate functions, table engines, compression, and the MergeTree engine for real-time data handling.
  • ClickHouse was bootstrapped without relying on existing databases, with early production deployment in 2012 and replication via ZooKeeper implemented by 2014.
  • Open-sourcing was motivated by observed industry needs and potential to fill a niche, leading to its release after internal approval and preparation.
  • The author encourages engineers to open-source their projects, highlighting ClickHouse's journey from internal tool to globally adopted database.