OSS Program: Get Tinybird credits for your open source project.
Apply now
.
Apply now
Product
[
]
Pricing
Docs
Resources
[
]
Data Platform
Managed ClickHouse
Production-ready with Tinybird's DX
Streaming ingestion
High-throughput streaming ingest
Schema iteration
Safe migrations with zero downtime
Connectors
Plug and play Kafka, S3, and GCS
Developer Experience
Instant SQL APIs
Turn SQL into an endpoint
BI & Tool Connections
Connect your BI tools and ORMs
Tinybird Code
Ingest and query from your terminal
Enterprise
Tinybird AI
AI resources for LLMs and agents
High availability
Fault-tolerance and auto failovers
Security and compliance
Certified SOC 2 Type II for enterprise
Sign in
Sign up
Sign up
Product
[
]
Data Platform
Managed ClickHouse
Production-ready with Tinybird's DX
Streaming ingestion
High-throughput streaming ingest
Schema iteration
Safe migrations with zero downtime
Connectors
Plug and play Kafka, S3, and GCS
Developer Experience
Instant SQL APIs
Turn SQL into an endpoint
BI & Tool Connections
Connect your BI tools and ORMs
Tinybird Code
Ingest and query from your terminal
Enterprise
Tinybird AI
AI resources for LLMs and agents
High availability
Fault-tolerance and auto failovers
Security and compliance
Certified SOC 2 Type II for enterprise
Pricing
Docs
Resources
[
]
Changelog
The latest updates to Tinybird
Blog
Musings on transformations, tables and everything in between
Customer Stories
We help software teams ship features with massive data sets
Templates
Explore our collection of templates
Tinybird Builds
We build stuff live with Tinybird and our partners
Videos
Learn how to use Tinybird with our videos
Slack Community
Join our Slack community to get help and share your ideas
Open Source Program
Get help adding Tinybird to your open source project
Schema > Evolution
Join the most read technical biweekly engineering newsletter
Our Columns:
Skip the infra work. Deploy your first ClickHouse
project now
Get started for free
Read the docs
Some outages detected
Copyright © 2025 Tinybird. All rights reserved
|
Terms & conditions
Cookies
Cookie Settings
Trust Center
Compliance Helpline
OSS Program: Get Tinybird credits for your open source project.
Apply now
.
Apply now
Product
[
]
Pricing
Docs
Resources
[
]
Data Platform
Managed ClickHouse
Production-ready with Tinybird's DX
Streaming ingestion
High-throughput streaming ingest
Schema iteration
Safe migrations with zero downtime
Connectors
Plug and play Kafka, S3, and GCS
Developer Experience
Instant SQL APIs
Turn SQL into an endpoint
BI & Tool Connections
Connect your BI tools and ORMs
Tinybird Code
Ingest and query from your terminal
Enterprise
Tinybird AI
AI resources for LLMs and agents
High availability
Fault-tolerance and auto failovers
Security and compliance
Certified SOC 2 Type II for enterprise
Sign in
Sign up
Sign up
Product
[
]
Data Platform
Managed ClickHouse
Production-ready with Tinybird's DX
Streaming ingestion
High-throughput streaming ingest
Schema iteration
Safe migrations with zero downtime
Connectors
Plug and play Kafka, S3, and GCS
Developer Experience
Instant SQL APIs
Turn SQL into an endpoint
BI & Tool Connections
Connect your BI tools and ORMs
Tinybird Code
Ingest and query from your terminal
Enterprise
Tinybird AI
AI resources for LLMs and agents
High availability
Fault-tolerance and auto failovers
Security and compliance
Certified SOC 2 Type II for enterprise
Pricing
Docs
Resources
[
]
Changelog
The latest updates to Tinybird
Blog
Musings on transformations, tables and everything in between
Customer Stories
We help software teams ship features with massive data sets
Templates
Explore our collection of templates
Tinybird Builds
We build stuff live with Tinybird and our partners
Videos
Learn how to use Tinybird with our videos
Slack Community
Join our Slack community to get help and share your ideas
Open Source Program
Get help adding Tinybird to your open source project
Schema > Evolution
Join the most read technical biweekly engineering newsletter
Back to columns
Posts by
Xoel López
Founder at TheirStack
The Data Base
Jul 26, 2022
Text search at scale with ClickHouse
Searching for thousands of regex patterns on millions of documents in seconds like it’s no big deal.
Xoel López
Founder at TheirStack
1Text search at scale with ClickHouse
The Data Base
Jul 08, 2021
ClickHouse tips #9: Filling gaps in time-series on ClickHouse
This simple trick will teach you how to fill date and datetime gaps in time-series on ClickHouse. Part 9.
Xoel López
Founder at TheirStack
1ClickHouse tips #9: Filling gaps in time-series on ClickHouse
Jun 21, 2021
Adapt Postgres queries to Tinybird
The Data Base
Xoel López
Founder at TheirStack
1Adapt Postgres queries to Tinybird
Jun 01, 2021
ClickHouse tips #8: Generating time-series on ClickHouse
The Data Base
Xoel López
Founder at TheirStack
1ClickHouse tips #8: Generating time-series on ClickHouse
May 02, 2021
Analyzing our own Nginx logs with ClickHouse on Tinybird
I Built This!
Xoel López
Founder at TheirStack
1Analyzing our own Nginx logs with ClickHouse on Tinybird
Apr 23, 2021
ClickHouse tips #6: Filtering data in subqueries to avoid joins
The Data Base
Xoel López
Founder at TheirStack
1ClickHouse tips #6: Filtering data in subqueries to avoid joins
Subscribe to SCHEMA > Evolution
We are Tinybird and we manage data for companies like Vercel and Canva. Plus, write a newsletter covering Data, AI and everything that matters in between. Join us.
Subscribe
Apr 16, 2021
Advanced endpoint functions and more
Product updates
Xoel López
Founder at TheirStack
1Advanced endpoint functions and more
Apr 05, 2021
Changelog: autocomplete uses the full ClickHouse documentation. CLI on MacOS and more
Product updates
Xoel López
Founder at TheirStack
1Changelog: autocomplete uses the full ClickHouse documentation. CLI on MacOS and more
Mar 16, 2021
Coming soon on ClickHouse: Window functions
The Data Base
Xoel López
Founder at TheirStack
1Coming soon on ClickHouse: Window functions
Jan 19, 2021
Querying large CSVs online with SQL
I Built This!
Xoel López
Founder at TheirStack
1Querying large CSVs online with SQL
Dec 15, 2020
Investigating Performance Bottlenecks With SQL & Statistics
Scalable Analytics Architecture
Xoel López
Founder at TheirStack
1Investigating Performance Bottlenecks With SQL & Statistics
Skip the infra work. Deploy your first ClickHouse
project now
Get started for free
Read the docs
Some outages detected
Copyright © 2025 Tinybird. All rights reserved
|
Terms & conditions
Cookies
Cookie Settings
Trust Center
Compliance Helpline