Tinybird blog

The Data Base

Query Booster: How Tinybird optimizes table schemas for you

Query Booster is an intelligent feature that automatically monitors your database usage patterns and optimizes performance by fine-tuning data source schemas.

Product updates

Get to know your data's data - EDA in Tinybird

Exploratory Data Analysis (EDA) helps you understand the shape of your data. Here's how to get metadata on your data using Tinybird's new Explorations feature.

AI x Data

Which LLM writes the best analytical SQL?

Can natural language replace SQL? We benchmarked the SQL-writing ability of the top 19 LLMs to find out.

Tinybird news

Explorations: a chat UI for real-time analytics

Introducing Explorations, a conversational UI to chat with your real-time data in Tinybird.

Engineering Excellence

Building a conversational AI tool for real-time analytics

We just launched a conversational AI feature. Here's how we built the feature that lets you chat with your data.

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.