GitTrends: A Google Trends style view of the GitHub ecosystem

GitTrends is an open-source demo application designed to function like Google Trends for the tech industry, allowing users to search and compare trends across over 10 billion GitHub events in real time. Built to demonstrate the full-text search capabilities of ClickHouse, GitTrends enables users to track the popularity of technologies and topics by analyzing mentions in issues, pull requests, and comments on GitHub. It offers insights into tech adoption by allowing comparisons of keyword trends, identification of key repositories and ecosystems, and exploration of the specific conversations driving these trends. The application showcases the power of ClickHouse's new full-text search feature, providing instant search results by indexing raw text and enabling aggregation within the same engine. GitTrends, which is fully open-source and available for exploration, also includes features like live query performance comparisons and opportunities for users to inspect and run the SQL queries behind each chart.