akvorado/akvorado
Akvorado is a flow collector, enricher, and visualizer that processes network flow data, enriches it with interface and geolocation information, and stores it in ClickHouse for real-time analysis and visualization.
Awesome ClickHouse › Data Visualization and Analysis
ClickHouse/clickpy
ClickPy is an open-source Python package analytics service powered by ClickHouse, designed to provide real-time analytics on PyPI package downloads. It offers users insights into package adoption, download frequency, geographic popularity, and trending packages. The service is available for local deployment and as an online platform at clickpy.clickhouse.com. ClickPy processes hundreds of billions of rows of data generated from every Python package download worldwide, leveraging ClickHouse's high-performance database capabilities to deliver fast, cost-efficient analytics compared to traditional solutions like BigQuery. The project features extensive analytics dashboards that display top packages, recent releases, emerging repositories, packages needing updates, and hot packages with significant download changes. Users can explore detailed download statistics over time, segmented by Python version, operating system, country, installer type, and package version. This granular data enables developers and analysts to understand package usage patterns and trends comprehensively. ClickPy addresses the challenges of handling massive datasets with billions of rows and the need for low-latency, high-concurrency queries essential for real-time analytics applications. It demonstrates the effective use of ClickHouse's materialized views and dictionaries to optimize query performance by shifting computation from query time to insert time. This approach significantly reduces query latency, enabling interactive data exploration even on datasets approaching a trillion rows. The project also serves as a practical example for developers building real-time analytics applications, showcasing best practices for using ClickHouse to achieve high performance and scalability. By importing PyPI download data from BigQuery into ClickHouse, ClickPy overcomes the limitations of BigQuery in speed and concurrency, providing a superior user experience for package analytics. In summary, ClickPy is a powerful, scalable analytics platform that leverages ClickHouse to deliver fast, detailed insights into Python package downloads, supporting the Python community and developers interested in real-time data analytics.
https://github.com/ClickHouse/clickpy
Also in Data Visualization and Analysis
clickvisual/clickvisual
ClickVisual is a lightweight log analytics and data visualization platform built on ClickHouse, designed for efficient log querying, analysis, and monitoring.
mr-karan/logchef
Logchef is a lightweight, high-performance log analytics platform built on ClickHouse, offering schema-agnostic querying, team-based access control, and easy deployment as a single binary.
Altinity/clickhouse-grafana
Altinity/clickhouse-grafana is a Grafana datasource plugin that enables seamless integration and visualization of ClickHouse data within Grafana dashboards.
serenedb/serenedb
SereneDB is a distributed real-time search analytics database that unifies Elasticsearch-like search and ClickHouse-like analytics in a single, Postgres-compatible platform for high performance and ease of use.
iamtelescope/telescope
Telescope is a web-based log viewer UI that enables intuitive exploration and analysis of log data stored primarily in ClickHouse, with support for Docker logs and advanced querying features.
ClickHouse/metabase-clickhouse-driver
A ClickHouse database driver enabling integration with the Metabase business intelligence front-end for data visualization and querying.
ClickHouse/adsb.exposed
An interactive platform for visualizing and analyzing massive ADS-B air traffic data using ClickHouse with real-time querying and detailed visualizations.