October 2022 Summaries

Session Rewind is a cost-effective session replay tool developed to challenge the high prices set by market leaders in the industry by leveraging modern cloud technologies. The process involves using Tinybird's real-time analytics platform built on ClickHouse®, along with Kafka for data streaming, to efficiently handle high data throughput and storage needs while minimizing operational costs. By employing AWS services and Tinybird, Session Rewind reduces its DevOps surface area and enhances performance, enabling it to deliver accurate session replays at a steep discount. The tool addresses technical challenges such as high data storage requirements and fast queries on user-defined properties, and it supports a high iteration speed for developing new data transformation prototypes. As the product gains traction, with over 50 companies already using it, the team plans to further reduce costs and introduce new features like heatmaps and funnel analysis, all while maintaining a lean operational approach.

Tinybird has launched an open-source ClickHouse® Knowledge Base, inviting contributions to its public repository. Built on ClickHouse® and backed by over 40 years of combined experience from its developers, Tinybird has been enhancing this fast, column-oriented OLAP database, which is well-suited for operationalizing complex analytical queries. The knowledge base aims to support teams in deciding how to balance performance, cost, and operational overhead through resources like an overview of managed ClickHouse® options, covering self-hosting, cloud-managed services, and serverless platforms. This initiative celebrates Tinybird's ongoing commitment to the ClickHouse® open-source project and seeks to empower users by adding new insights regularly while encouraging community contributions.

Time series data, which often includes timestamps, is prevalent in various fields such as weather forecasting, stock market analysis, and infrastructure monitoring, necessitating tools for exploration and pattern recognition. Tinybird has introduced a new feature called Time Series UI, designed to help users visually explore and analyze time series data using SQL for filtering, grouping, and aggregating. This tool enables real-time updates and visualization of data, allowing users to answer questions about web traffic changes, infrastructure usage surges, and data anomalies through intuitive graphical interfaces like line or bar charts. The Time Series UI is available to all Tinybird users, and it allows for sharing within teams or publicly via generated URLs, fostering collaboration and data-driven insights in real-time application development.