Gonzalo's Avatar

Gonzalo

@gnzjgo

Regret was the ham in the back of the deli that caused people to switch from turkey to roast beef. Heavy user of tinybird.co

56
Followers
393
Following
27
Posts
09.09.2023
Joined
Posts Following

Latest posts by Gonzalo @gnzjgo

Post image

What am I fixing?

tip: today() the day the test was created is not the same today() as the day the test run πŸ˜…

21.05.2025 06:11 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
IoT monitoring with Kafka and Tinybird Learn how to build a real-time IoT analytics pipeline using Kafka and Tinybird. This hands-on guide shows you how to process thousands of device readings and expose instant insights through API endpoi...

www.tinybird.co/blog-posts/i...

20.05.2025 08:56 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Why Kafka and Tinybird?
Kafka is the world's most popular data streaming infrastructure; it excels at handling high-throughput event streaming from thousands of IoT devices, providing reliable message delivery with persistence. Tinybird complements this by transforming IoT data streams into real-time APIs with sub-second response times. Together, they form an end-to-end solution:

Kafka handles the ingestion and buffering of IoT sensor meter readings
Tinybird processes the data stream, stores the history, and exposes the results as API endpoints
Your application or service can present insights through standard REST API calls
What makes this combination powerful for product engineers is the ability to work with streaming data, persist it in the Tinybird database, and create APIs to consume it involving just two pieces of software. Depending on your approach to Kafka, you can do this in an entirely serverless fashion, without worrying about any complex infrastructure setup.

Why Kafka and Tinybird? Kafka is the world's most popular data streaming infrastructure; it excels at handling high-throughput event streaming from thousands of IoT devices, providing reliable message delivery with persistence. Tinybird complements this by transforming IoT data streams into real-time APIs with sub-second response times. Together, they form an end-to-end solution: Kafka handles the ingestion and buffering of IoT sensor meter readings Tinybird processes the data stream, stores the history, and exposes the results as API endpoints Your application or service can present insights through standard REST API calls What makes this combination powerful for product engineers is the ability to work with streaming data, persist it in the Tinybird database, and create APIs to consume it involving just two pieces of software. Depending on your approach to Kafka, you can do this in an entirely serverless fashion, without worrying about any complex infrastructure setup.

This year I won't be at #Current25 in London (have fun all of you that are there!), but here's my small contribution to the Kafka ecosystem. I wrote a blog post about how to combine Kafka and Tinybird for an IoT use case.

20.05.2025 08:56 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I only check it when I’m done with more focused stuff or have some idle time.

I feel the change especially with slack, it’s like tiktok / ig reels for my brain.

19.05.2025 11:14 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

some weeks ago I listened Cal Newport’s book Deep Work.

I keep thinking if he saw my workflow he’d have a heart attack (to me, email is kinda focused).

but I adapted and now have a noisy browser profile with slack, bluesky, linkedin, hacker news, reddit…

19.05.2025 11:14 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
Multi-tenant analytics with Tinybird and Clerk How to use Clerk's Tinybird JWT template to secure Tinybird APIs for fast, easy, and secure user-facing analytics in your multi-tenant application.

from @clerk.com blog clerk.com/blog/tinybir...

12.05.2025 21:41 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
src/app/providers/TinybirdProvider.tsx

src/app/providers/TinybirdProvider.tsx

A react context that syncs Clerk authentication tokens with Tinybird's API endpoints.

Manages token state and session changes automatically, exposing everything through a single useTinybirdToken hook so your components stay clean and decoupled.

12.05.2025 21:41 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
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.

Super nice feature to make your live (and my team’s) better

www.tinybird.co/blog-posts/q...

12.05.2025 17:55 πŸ‘ 0 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Post image Post image

One cool thing about having internal users is that you discover new usage patterns

`tb create --prompt` mentioning an existing endpoint and with the changes you want

12.05.2025 14:57 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
Building Explorations A Conversational Analytics Ai Visit www.tinybird.co/blog-posts/building-explorations-a-conversational-analytics-ai

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

06.05.2025 13:02 πŸ‘ 1 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Introducing Explorations, a conversational AI for real-time analytics
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...

Introducing Explorations, a chat UI for real-time analytics.

youtu.be/pLI1xLxpUTw

06.05.2025 13:02 πŸ‘ 2 πŸ” 3 πŸ’¬ 1 πŸ“Œ 0

people that use llms to generate SQL, which is your favorite? why?

maybe it’s because it tends to go for more oltp than olap mindset but I don’t love any model 100% yet

06.05.2025 09:19 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Issue is no matter if you’re right or not, it will validate, but that is what users and market are for.

23.04.2025 07:18 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Sonnet 3.7 telling me β€œyou’re absolutely right”

Sonnet 3.7 telling me β€œyou’re absolutely right”

If you’re feeling down, just ask Sonnet3.7 to change something it just produced.

23.04.2025 07:18 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

back after a while. This still runs, right?

21.04.2025 10:05 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
Building an Insights page for your SaaS: from idea to production I've helped so many people add an Insights page or dashboard to their app. Here are the steps to take your user-facing analytics from idea to prod.

In the post linked I give some more details, but if you ever did a POC with me it should resonate a lot :)

www.tinybird.co/blog-posts/b...

PS: wonder how well LLMs with access to docs would solve this use case.

05.12.2024 11:46 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
A donought and a line chart

A donought and a line chart

My job these three years at @tinybirdco.bsky.social has been about helping teams use Tinybird and go to production.

The journey is:
- Start small, prototype and validate
- Optimize
- Connect to production ingest
- Enable the APIs for the end users
- Monitor that everything works according to plan

05.12.2024 11:46 πŸ‘ 4 πŸ” 1 πŸ’¬ 1 πŸ“Œ 0

wait, there's no Tinybird MCP and Tinybird Workspace refs in the MCP docs yet? πŸ˜”

29.11.2024 15:53 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
claude desktop telling me how to fix him

claude desktop telling me how to fix him

echo 'alias claude="open -a Claude"' >> ~/.zshrc
echo 'alias qclaude="echo \"πŸ‘‹ Goodbye from Claude\" && osascript -e '"'"'quit app \"Claude\"'"'"'"' >> ~/.zshrc

echo 'alias claude="open -a Claude"' >> ~/.zshrc echo 'alias qclaude="echo \"πŸ‘‹ Goodbye from Claude\" && osascript -e '"'"'quit app \"Claude\"'"'"'"' >> ~/.zshrc

Had issues with Claude Desktop's MCP server - turns out it wasn't reading PATH when launched from the dock. Fixed it with some terminal aliases to properly open/close the app.

And yes, Claude itself helped diagnose and fix the issue πŸ˜„

28.11.2024 23:03 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

Model Context Protocol from @anthropic.com allows connecting LLMs to *your* data and do crazy stuff

We built a Tinybird MCP server so you can now get insights from your Workspaces using Claude

Just used it to analyze our website metrics, crazy stuff 🀯

27.11.2024 19:14 πŸ‘ 3 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

I've been working on Bluebird github.com/sdairs/blueb... to send the BlueSky firehose to @tinybirdco.bsky.social. Yesterday @anthropic.com released MCP so here's the Tinybird MCP Server v0 github.com/tinybirdco/t... which means now I can use Claude to connect to Tinybird and chat with that data 🀯

27.11.2024 17:17 πŸ‘ 10 πŸ” 3 πŸ’¬ 0 πŸ“Œ 1

Here's the chat transcript & Claude artefact for the dashboard www.tinybird.co/blog-posts/c... - while mostly getting things right, its interesting that some of the queries failed but it still gave some analysis...these failures are easy to fix, but that behaviour will be interesting to work with

27.11.2024 18:46 πŸ‘ 3 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0

my bad, Cam is @tnbirdguy.bsky.social xD

27.11.2024 18:56 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

It's super cool to work in a company where it takes us 1-2 days to have something in production since @anthropic.com released it πŸš€

Basically saying "C; C; A; so cool, could you build a dashboard" you have it.
tinybird.co/blog-posts/cla…

Kudos to @alrocar.bsky.social @alasdairb.com and Cam! πŸ‘

27.11.2024 18:55 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Lo intento, aunque sigo tirando mΓ‘s de Twitter de momento

14.11.2024 21:50 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Post image Post image

AquΓ­ Alex y servidor muy concentrados* en el stand de la #TRG24

Ana y Santana no salen en la foto pero tambiΓ©n estaban y estarΓ‘n maΓ±ana.

Venid a vernos para participar en el sorteo del Delorean pequeΓ±o.

*literalmente: centrando un iframe xD

14.11.2024 20:14 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Working with DynamoDB Single-Table Design Β· Tinybird Docs In this guide, you'll learn how to work with data that follows DynamoDB Single-Table Design.

That’s why I was so into DynamoDB lately πŸ‘‡

tbrd.co/ddb-std

Let me know your thoughts πŸ“

07.11.2024 20:32 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

yup, I still open it before remembering this one is the one πŸ˜…

31.10.2024 17:59 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Calm won't hurt :)

28.10.2024 23:03 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0