ClickHouse: 10 Years of Open Source Stained Glass

Beyond Code: The Architecture of Open Source

The article's central metaphor of stained glass is powerful, effectively illustrating the multifaceted and layered nature of open-source development. The integration of real-time, queryable contributor data directly within the ClickHouse product itself is a truly innovative approach to acknowledging community contributions. This moves beyond traditional 'thank you' pages or scattered footnotes, embedding recognition as a tangible, queryable artifact. The cBioPortal example powerfully demonstrates the real-world impact of performance improvements driven by open-source contributions, highlighting how speed directly fuels scientific exploration. This serves as a compelling testament to the practical value generated by the community.

However, while the metaphor is rich, its practical application could be further elaborated. The article mentions 'seams' in the contributor data, implying that not all contributions are equally captured. A more detailed discussion on how these seams are addressed or mitigated, beyond acknowledging their existence, would strengthen the argument for complete transparency. Furthermore, while the 'Champions' program is a positive step, the article could delve deeper into the selection criteria and the impact on fostering broader community engagement, beyond just recognizing existing advocates. The technical implementation of querying internal project data like Git history and GitHub events within ClickHouse is a key takeaway, but the specifics of the ETL processes and schema design for these disparate data sources could be explored in more detail for greater technical depth.

Key Points

• ClickHouse uses the 'stained glass' metaphor to describe its ten-year open-source journey, emphasizing community as many pieces held together.
• Key elements of the metaphor are 'light' (value only realized when used), 'lead' (infrastructure holding it together), and 'repair' (survival through maintenance).
• Innovative feature: Contributor credit is embedded directly into the ClickHouse product via system.contributors, queryable with SQL, making recognition tangible.
• Real-world impact demonstrated by cBioPortal, where ClickHouse performance improvements significantly accelerated cancer research.
• Technical innovation: ClickHouse can query its own Git history and GitHub activity using the same engine, providing a unified view of community and product.
• High closure rates for issues and pull requests (83% and 99% respectively) indicate project health and responsiveness.
• The 'Champions' program recognizes and amplifies community leaders and educators, framing existing public work.
• Open source credit is presented as verifiable through querying internal product data and public logs.

---

📖 Source: Ten years of open source: a stained-glass view