Tinybird blog

Scalable Analytics Architecture

dbt in real-time

Tinybird is kind of like dbt, but for real-time use cases. Here's how and why you might migrate real-time API use cases from dbt to Tinybird.

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?

AI x Data

Using LLMs to generate user-defined real-time data visualizations

UIs are changing. Here's how to use LLMs and real-time analytics APIs to build allow your users to generate their own data visualizations.

The Data Base

Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

This is the second part of the series. Here's more of what I've learned from operating petabyte-scale ClickHouse clusters for the last 5+ years.

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

AI x Data

Build natural language filters for real-time analytics dashboards

Click-to-filter is out. Prompt-to-filter is in. Learn how to ditch the filter sidebars and dropdowns and replace them with a single user text input and an LLM.

Scalable Analytics Architecture

Best practices for downsampling billions of rows of data

Data downsampling can be an effective way to reduce compute resources, but it comes with tradeoffs.

Engineering Excellence

How to safely cancel a database query

Cancelling a query from a UI client is more nuanced than it might seem. Here's how we implemented safe KILL QUERY operations in Tinybird.

I Built This!

How Inbox Zero uses Tinybird for real-time analytics

Here's how we use Tinybird at Inbox Zero to power both our own internal product analytics and user-facing, real-time dashboards.

I Built This!

We made an open source LLM Performance Tracker

You can't just build AI features, you have to operate them in production, which means observability. Here's an open source tool to watch your LLMs in real-time.

AI x Data

Hype v. Reality: 5 AI features that actually work in production

It's hard to sift through all the AI hype. Here are 5 AI features you can build that add immediate value to your app.

The Data Base

I've operated petabyte-scale ClickHouse® clusters for 5 years

I've been operating large ClickHouse clusters for years. Here's what I've learned about architecture, storage, upgrades, config, testing, costs, and ingestion.

I Built This!

Real-time inventory management with lambda architecture

Learn how to use Tinybird to build a lambda architecture for real-time inventory, unifying batch and real-time workflows in a single platform.

AI x Data

Instrument your LLM calls to analyze AI costs and usage

If you're building AI features, make sure to instrument your LLM calls so you can analyze costs, usage, and adoption. Here are a few examples in Python and TypeScript.

I Built This!

Vibe code tools, not toys.

How I vibe coded an internal anomaly detection system that had previously taken me months to build and deploy.

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.

Product updates

Run Tinybird on your own infrastructure

You can now run Tinybird on your own infrastructure, for free, with Tinybird Self-Managed.

Product updates

Less ceremony, more shipping

Deployments in data finally get their due. With tb deploy, live schema migrations happen painlessly and automatically.

Product updates

Writing tests sucks. Use LLMs so it sucks less.

Testing is a fundamental software practice. But people don't do it in data because it's hard. We're making it less hard (and more fun).

Product updates

Build fast software with big data requirements

Somehow we got stuck on the idea that big data systems should be slow. We're making it fast.

Product updates

Vibe data engineering

You're probably sick of hearing people talk about "vibe coding", but what about "vibe data engineering?" ;)

Product updates

Local first.

Run Tinybird on your machine. Deploy your data project locally or to the cloud in the exact same way, as it should be.

Product updates

Forward: Evolving Tinybird for the AI-native developer

Announcing Tinybird Forward, a new evolution of the Tinybird user experience designed to make building real-time data applications faster and more intuitive than ever before.

Scalable Analytics Architecture

How to run load tests in real-time data systems

We have run hundreds of load tests for customers processing petabytes of data in real-time. Here's everything you need to know to plan, execute, and analyze a load test in a real-time data system.

The Data Base

We added the Backup Database engine to ClickHouse

We added a new ClickHouse engine: Backup. Here's why we did it, how it's implemented, and example usage.