Sign in

Tinybird

@tinybird.co
77 followers 3 following 198 posts

The analytics backend for your app. Ship software with big data requirements faster and more intuitively than you ever thought possible.

PostsRepliesMedia
Tinybird @tinybird.co · 16/05/2025
Two weeks ago, we published v1 of our LLM SQL Generation Benchmark. Your feedback was generous, thoughtful, and sometimes brutally honest. Here's what we got wrong, what we got right (but didn’t explain), and how we’re improving the benchmark for round two. tbrd.co/llm-sql-rd2
tbrd.co
We graded 19 LLMs on SQL. You graded us.
We benchmarked 19 LLMs on analytical SQL and the internet had thoughts. Here's a breakdown of your feedback, what we got wrong, what we got right (but didn’t explain), and how we’re improving the…
000
Tinybird @tinybird.co · 12/05/2025
Read the full case study here: tbrd.co/phantom
tbrd.co
Phantom gives crypto traders faster buy/sell decisions with Tinybird
Learn how the most popular Solana wallet processes 2.5B+ daily events for 15M+ users while maintaining sub-50ms query latency.
000
Tinybird @tinybird.co · 12/05/2025
One of the most popular crypto wallets in the world, Phantom, builds features with Tinybird to increase revenue and swaps by displaying trending tokens to end-users in milliseconds. Top quote from their Sr. Data Engineer ↓
100
Tinybird @tinybird.co · 09/05/2025
Get to know your data's data. Exploratory Data Analysis in Tinybird -> tbrd.co/eda
tbrd.co
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.
021
Reposted by Tinybird
Thibault Le Ouay Ducasse @thibaultleouay.dev · 24/04/2025
How could I have missed it @tinybird.co just solved the biggest pain point to self host @openstatus.dev with their local container 🥰 www.tinybird.co/docs/forward...
tinybird.co
Tinybird Local container (Forward) · Tinybird Docs
Use the Tinybird Local container to run Tinybird locally and in CI workflows.
051
Reposted by Tinybird
Maximilian Kaske @mxkaske.dev · 04/05/2025
Having fun with @shadcn.com sidebar. Inspired by @tinybird.co.
A clean shadcn sidebar project including a 'filter' and 'create' button next to the menu label
061
Tinybird @tinybird.co · 06/05/2025
Despite the proliferation of AI chat apps, Explorations wasn't a simple build. Read the engineering post with our experience on LLM orchestration, prompt chaining, tools definition, system prompts, and handling unexpected LLM outputs -> tbrd.co/explorations_tech
tbrd.co
Building Explorations A Conversational Analytics Ai
Visit www.tinybird.co/blog-posts/building-explorations-a-conversational-analytics-ai
012
Tinybird @tinybird.co · 06/05/2025
You can read more about Explorations in our announcement post -> tbrd.co/explorations
100
Tinybird @tinybird.co · 06/05/2025
Here's what you can do with Explorations: - Query data in your natural language - Build notebook-style analysis - Customize output with rules - Visualize results as timeseries charts - Fix errors automatically
100
Tinybird @tinybird.co · 06/05/2025
Before you write your first pipe, you must understand your data. This takes time. It starts with SELECT * … LIMIT 1 and ends with many open SQL docs tabs. Explorations reduces time-to-first-API by turning natural language queries into optimized & contextualized SQL.
100
Tinybird @tinybird.co · 06/05/2025
Introducing Explorations, a chat UI for real-time analytics. youtu.be/pLI1xLxpUTw
youtu.be
Introducing Explorations, a conversational AI for real-time analytics
Explorations is an AI chat UI for Tinybird users to query and analyze up to billions of rows of real-time data using natural language. Here's a quick demo of...
123
Tinybird @tinybird.co · 24/04/2025
dbt shook up the data world in 2016. We like dbt. But it's not suited for real-time workloads (because data warehouses aren't suited for real-time workloads). Tinybird is a lot like dbt. But it's also different... 👀 tbrd.co/dbt-real-time
tbrd.co
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.
000
Tinybird @tinybird.co · 21/04/2025
In post 3, we compared Reddit's original architecture to the optimized Tinybird approach in terms of cost, performance, and complexity -> tbrd.co/100bpt3
000
Tinybird @tinybird.co · 21/04/2025
In post 2, we considered how to effectively scale the counter -> tbrd.co/100bpt2
100
Tinybird @tinybird.co · 21/04/2025
In post 1, we offered a very simple approach to count 100B rows in Tinybird -> tbrd.co/100bpt1
100
Tinybird @tinybird.co · 21/04/2025
We just wrapped a blog series on counting 100 billion rows efficiently. The takeaway? Tinybird is fast and cost-effective when it comes to real-time aggregation at scale. Duh. Links to all 3 below ↓
100
Tinybird @tinybird.co · 21/04/2025
Quick update on this ↓ Spots are filling up. We're ~75% full with a week to go. If you want to meet other #NewYorkCity devs building real-time data applications and learn from someone who has actually built and scaled the thing in prod, register now. Register: lu.ma/9wazu8zx
010
Tinybird @tinybird.co · 16/04/2025
Where my Copenhagen devs at? Next Wednesday we're running a Tinybird Hackathon at the @BlastTV offices in Copenhagen 🇩🇰. Learn how Blast built their stats leaderboard for the game Deadlock, and get hands-on experience building real-time analytics APIs. Register here: lu.ma/wafkvnza
010
Tinybird @tinybird.co · 11/04/2025
There are 6 functions to get a unique count in Tinybird: 1. uniq 2. uniqExact 3. uniqCombined 4. uniqCombined64 5. uniqHLL2 6. uniqTheta Each one has tradeoffs. Read how to combine them to efficiently count billions of unique IDs. ↓
tbrd.co
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
000
Tinybird @tinybird.co · 10/04/2025
Curious how this works? We walk through it step-by-step in our latest blog post. ↓ tbrd.co/askai
000
Tinybird @tinybird.co · 10/04/2025
The basic process: 1. Create an API to pass input to an LLM 2. Pass user input + sys prompt to the LLM 3. Have the LLM return structured filters 4. Fetch your data API using the LLM filters The key is a good (dynamic!) system prompt & a fast analytics backend (👋 Tinybird).
100
Tinybird @tinybird.co · 10/04/2025
You can reclaim some UI space by distilling filter UIs into a clean free-text prompt and use an LLM to parse the result. @dubdotco has a good example. With 20 high-cardinality filter dimensions, Dub simplifies the filter UI by prioritizing free-text AI input ↓
100
Tinybird @tinybird.co · 10/04/2025
Filters are important for any dashboard. But when the number of filter dimensions grows, UI components for filtering can get clunky and eat up a lot of space. 👇 See how much real estate this sidebar takes?
100
Tinybird @tinybird.co · 10/04/2025
💡 Quick win to improve the UX of your real-time analytics dashboards: Add an "Ask AI" feature. ↓ More info on how to do it in the 🧵
100
Tinybird @tinybird.co · 07/04/2025
Just announced: Real-time Data Meetup with Tinybird, Estuary, and PlayOn! Sports. 3 talks. A room full of devs and data people. Free food and imbibements. April 29th at 6 PM ET FirstMark Capital - NYC Register here: lu.ma/9wazu8zx
010
Tinybird @tinybird.co · 07/04/2025
Things that should be simple, but aren't: Canceling a database query from a web app client. Here's how we do it ⤑ tbrd.co/cancel-query
000
Reposted by Tinybird
Maximilian Kaske @mxkaske.dev · 30/03/2025
Own your data. Build your dashboard. A few months ago, we released a @vercel.com edge pinger to monitor your endpoints and store the responses in @tinybird.co: a lightweight OpenStatus version for you to self-host. Today, the UI is here. → logs.run/light
2103
Tinybird @tinybird.co · 28/03/2025
Tinybird can help here. Use Tinybird to build a lambda architecture that combines: 🔹 Pre-aggregated snapshots (batch) 🔹 Transaction event streams (real-time) 🔹 Serving layer to merge both at query time Practical example below 👇 tbrd.co/inventory
000
Tinybird @tinybird.co · 28/03/2025
Traditional lambda architecture combines batch and real-time data modalities. Usually these need to be implemented in different systems, which can lead to brittle pipelines that are hard to maintain and scale.
100
Tinybird @tinybird.co · 28/03/2025
Analytical databases are great for fast queries and high throughput, but their append-only nature makes updates and deletes computationally expensive. Not ideal when inventory state constantly changes. Lambda architecture can solve this, but there's a catch.
100
Tinybird @tinybird.co · 28/03/2025
Transactional databases struggle with high-volume inventory systems. Lock contentions can cause out-of-date inventory data, which leads to a bad shopper experience. Columnar OLAP databases can solve the write throughput issue, but of course there are tradeoffs.
100
Tinybird @tinybird.co · 28/03/2025
Building a real-time inventory system that actually works is harder than it looks. A thread on why 👇
100
Tinybird @tinybird.co · 27/03/2025
You should instrument your application's LLM calls so you can analyze cost, usage, and adoption over time. Here are some example implementations in Python and TypeScript: tbrd.co/inst-llm
tbrd.co
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.
010
Tinybird @tinybird.co · 26/03/2025
Vibe code tools, not toys.
tbrd.co
Vibe code tools, not toys.
How I vibe coded an internal anomaly detection system that had previously taken me months to build and deploy.
000
Tinybird @tinybird.co · 26/03/2025
The Vibeathon is on!!! Check out the prompt -> tbrd.co/vibeathon Commit your code by 12:48 PM ET. Win $3k! Va va va!!!!
tbrd.co
You have 48 minutes to build something incredible.
Build something with Tinybird Forward in 48 minutes and win over $3000 in credits from your favorite dev tools.
000
Tinybird @tinybird.co · 26/03/2025
The Tinybird Forward Vibeathon begins in 1 hr. Build something in 48 minutes, win $3k. A few tips to prepare: 💡 Install the latest Tinybird CLI 💡 Start tb local 10 min. before 💡 Clone the repo (link below) 💡 Start prepping your prompts! Here's the repo -> tbrd.co/vibeathon Good luck!
tbrd.co
You have 48 minutes to build something incredible.
Build something with Tinybird Forward in 48 minutes and win over $3000 in credits from your favorite dev tools.
010
Tinybird @tinybird.co · 25/03/2025
How to count 100,000,000,000 unique IDs in <100ms 👇 tbrd.co/100b-pt1
tbrd.co
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.
000
Tinybird @tinybird.co · 24/03/2025
Tinybird Self-Managed gives you complete control over your analytical backend while keeping everything you love about Tinybird—speed, scalability, and ease of use. Check out the blog post 👇 tbrd.co/tb-infra
000
Tinybird @tinybird.co · 24/03/2025
Introducing Tinybird Self-Managed. Run Tinybird on your own infra (for free). youtu.be/kBsSoaElRCo
youtu.be
Run Tinybird anywhere with tb infra
You can now deploy Tinybird on your own self-managed cloud infrastructure. Learn how to configure your deployments to run Tinybird anywhere.More info: https:...
100
Tinybird @tinybird.co · 21/03/2025
Ask us anything about Tinybird Forward, starting in 15 minutes. gcal invite -> tbrd.co/fwd-ama youtube -> youtube.com/live/NIdIarNwm7U
000
Tinybird @tinybird.co · 21/03/2025
Have questions about tb deploy? Join our Office Hours in 1 hour. We'll demo zero-downtime schema migrations and answer your questions about our deployment architecture. tbrd.co/fwd-ama
tbrd.co
Tinybird Forward Office Hours - Ask us anything!
Tinybird Forward is the new UX that makes shipping software with big data requirements faster and more intuitive than ever. Join our office hours to ask us anything about Tinybird Forward.
000
Tinybird @tinybird.co · 21/03/2025
Our latest post dives into how tb deploy works to eliminate all the usual "fuss" data deployments: ⬥ Parallel ingestion ⬥ FORWARD_QUERY ⬥ Staging vs. Production ⬥ Atomic promotion ⬥ Instant metadata changes Read more 👇 tbrd.co/tb-deploy
tbrd.co
Less ceremony, more shipping
Deployments in data finally get their due. With tb deploy, live schema migrations happen painlessly and automatically.
100
Tinybird @tinybird.co · 21/03/2025
You had me at "automatic schema migrations." Data deployments are no longer a mess of manual steps, risky schema changes & crossed fingers. With tb deploy, you get true CI/CD for your data - validation, migrations, backfills, and zero-downtime promotion in a SINGLE command. youtu.be/P3ZAgSlFJuQ
youtu.be
Automatic schema migrations with tb deploy
Migrating schemas in production used to be painful. Now, it's basically automatic. Learn how to use tb deploy and Tinybird's datafiles to automatic your live...
100
Tinybird @tinybird.co · 20/03/2025
Block off your calendar for the Tinybird Forward Vibeathon. Up for grabs: Over $3,000 in credits from Tinybird, Vercel, Resend, Dub, Plain, and more. Wednesday, March 26th from 12:00 - 12:48 PM ET. Add it to your google cal👇
cal.link
Google Calendar - Tinybird Forward Vibeathon
Block your calendar for the Tinybird Forward Vibeathon. March 26th, 2025 from 12:00 PM ET to 12:48 PM ET.
010
Tinybird @tinybird.co · 20/03/2025
Writing tests sucks. Use LLMs to make it suck less.
tbrd.co
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).
000
Tinybird @tinybird.co · 20/03/2025
Use tb mock && tb test to generate production-like mock data and a suite of unit tests for your APIs.
youtu.be
Generate mock data and tests using LLMs
Nobody likes writing unit tests. Nobody likes building scripts to generate production-like mock data.With Tinybird Forward, let the LLMs handle the mundane. ...
000
Tinybird @tinybird.co · 19/03/2025
Follow our launch week for more on Tinybird Forward -> tbrd.co/fwd-launch
000
Tinybird @tinybird.co · 19/03/2025
Big Data has a big problem. They think everything should be slow. We think everything should be fast. Your queries AND your development. `tb dev` let's you build fast software with big data requirements, faster. tbrd.co/tb-dev
100
Tinybird @tinybird.co · 19/03/2025
`tb dev` is the instant feedback loop for building your analytics backend. It's like `next dev`, but for data. Change your queries or change your data, and TInybird hot reloads your build in milliseconds. youtu.be/DCzYj9VKdHE
youtu.be
Hot reloads on your data project with tb dev
The software development workflow shouldn't change whether you're shipping a web app or a real-time data pipeline. Use tb dev to build your Tinybird data pro...
121
Tinybird @tinybird.co · 19/03/2025
YouTube link if you prefer to add it to your calendar manually (or you don't use Google Calendar): youtube.com/live/NIdIarN...
youtube.com
Tinybird Forward Office Hours
Ask us anything about Forward, the new Tinybird UX that makes shipping software with big data requirements faster and more intuitive than ever before.
000