Scalable Analytics Architecture How to count 100B events: Comparing architectures Reddit built a powerful architecture in 2017 to count views and unique viewers on posts. How does it compare to our simpler Tinybird approach?
Scalable Analytics Architecture The simplest way to count 100B unique IDs: Part 2 How to make a simple counter scale to trillions by using the right count functions paired with pre-aggregations
I Built This! The simplest way to count 100 billion unique IDs: Part 1 How to build a simpler, real-time version of Reddit's complex system for counting unique IDs, involving Kafka, Redis, and Cassandra.
The Data Base Outgrowing Postgres: How to optimize and integrate an OLTP + OLAP stack Navigate the complexities of OLTP and OLAP integration by choosing simple, scalable data movement patterns that reduce infrastructure overhead and keep your focus on building great products for users.
The Data Base Outgrowing Postgres: How to evaluate the right OLAP solution for analytics Moving analytical workloads off Postgres? Learn how to evaluate real-time OLAP solutions based on what actually matters: performance, SQL compatibility, and developer experience.
The Data Base Outgrowing Postgres: When to move OLAP workloads off Postgres Learn when to move analytics off Postgres by watching for technical and team health warning signs before crisis hits.
The Data Base Outgrowing Postgres: How to run OLAP workloads on Postgres A deep dive into running analytics on Postgres, from basic optimizations to advanced techniques and knowing when to quit.
The Data Base Outgrowing Postgres: Handling increased user concurrency When your application grows, so too do your database connections. Learn how to handle increased user concurrency on Postgres.
The Data Base Outgrowing Postgres: Handling growing data volumes Managing terabyte-scale data in Postgres? From basic maintenance to advanced techniques like partitioning and materialized views, learn how to scale your database effectively. Get practical advice on optimizing performance and knowing when it's time to explore other options.
The Data Base Outgrowing Postgres: How to identify scale problems Discover early warning signs that you’ve outgrown PostgreSQL and learn how to keep performance high. This introductory article offers diagnostic techniques and proactive strategies to help you scale and plan the future of your analytics without losing momentum.
Scalable Analytics Architecture Building Real-Time Live Sports Viewer Analytics with Tinybird and AWS Ever tried to show millions of viewers real-time stats about how many other people like them are watching the same event? It's a bit like trying to count grains of sand while they're being poured into your bucket. Fun times! Let's look at how
The Data Base Featured Tinybird vs. ClickHouse®️: What's the difference? Tinybird is a real-time data platform for user-facing analytics, built using ClickHouse. Here are the differences between Tinybird and other ClickHouse solutions, including self-hosted and managed.
