PricingDocs
Bars

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 inSign 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
PricingDocs
Resources []

Learn

Blog
Musings on transformations, tables and everything in between
Customer Stories
We help software teams ship features with massive data sets
Videos
Learn how to use Tinybird with our videos
ClickHouse for Developers
Understand ClickHouse with our video series

Build

Templates
Explore our collection of templates
Tinybird Builds
We build stuff live with Tinybird and our partners
Changelog
The latest updates to Tinybird

Community

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 freeRead the docs
A geometric decoration with a matrix of rectangles.

Product /

ProductWatch the demoPricingSecurityRequest a demo

Company /

About UsPartnersShopCareers

Features /

Managed ClickHouseStreaming IngestionSchema IterationConnectorsInstant SQL APIsBI & Tool ConnectionsTinybird CodeTinybird AIHigh AvailabilitySecurity & Compliance

Support /

DocsSupportTroubleshootingCommunityChangelog

Resources /

ObservabilityBlogCustomer StoriesTemplatesTinybird BuildsTinybird for StartupsRSS FeedNewsletter

Integrations /

Apache KafkaConfluent CloudRedpandaGoogle BigQuerySnowflakePostgres Table FunctionAmazon DynamoDBAmazon S3

Use Cases /

User-facing dashboardsReal-time Change Data Capture (CDC)Gaming analyticsWeb analyticsReal-time personalizationUser-generated content (UGC) analyticsContent recommendation systemsVector search
All systems operational

Copyright © 2025 Tinybird. All rights reserved

|

Terms & conditionsCookiesTrust CenterCompliance Helpline
Tinybird wordmark
PricingDocs
Bars

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 inSign 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
PricingDocs
Resources []

Learn

Blog
Musings on transformations, tables and everything in between
Customer Stories
We help software teams ship features with massive data sets
Videos
Learn how to use Tinybird with our videos
ClickHouse for Developers
Understand ClickHouse with our video series

Build

Templates
Explore our collection of templates
Tinybird Builds
We build stuff live with Tinybird and our partners
Changelog
The latest updates to Tinybird

Community

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

Ariel Pérez
Ariel PérezHead of Product & Technology
Scalable Analytics Architecture
Apr 21, 2025
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?
Ariel Pérez
Ariel PérezHead of Product & Technology
1How to count 100B events: Comparing architectures
Scalable Analytics Architecture
Apr 11, 2025
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
Ariel Pérez
Ariel PérezHead of Product & Technology
1The simplest way to count 100B unique IDs: Part 2
Mar 25, 2025
The simplest way to count 100 billion unique IDs: Part 1
I Built This!
Ariel PérezAriel PérezHead of Product & Technology
1The simplest way to count 100 billion unique IDs: Part 1
Feb 27, 2025
Outgrowing Postgres: How to optimize and integrate an OLTP + OLAP stack
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: How to optimize and integrate an OLTP + OLAP stack
Feb 17, 2025
Outgrowing Postgres: How to evaluate the right OLAP solution for analytics
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: How to evaluate the right OLAP solution for analytics
Feb 07, 2025
Outgrowing Postgres: When to move OLAP workloads off Postgres
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: When to move OLAP workloads off Postgres
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.
Jan 31, 2025
Outgrowing Postgres: How to run OLAP workloads on Postgres
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: How to run OLAP workloads on Postgres
Jan 24, 2025
Outgrowing Postgres: Handling increased user concurrency
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: Handling increased user concurrency
Jan 17, 2025
Outgrowing Postgres: Handling growing data volumes
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: Handling growing data volumes
Jan 10, 2025
Outgrowing Postgres: How to identify scale problems
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Outgrowing Postgres: How to identify scale problems
Dec 03, 2024
Building Real-Time Live Sports Viewer Analytics with Tinybird and AWS
Scalable Analytics Architecture
Ariel PérezAriel PérezHead of Product & Technology
1Building Real-Time Live Sports Viewer Analytics with Tinybird and AWS
Aug 13, 2024
Tinybird vs. ClickHouse®: What's the difference?
The Data Base
Ariel PérezAriel PérezHead of Product & Technology
1Tinybird vs. ClickHouse®: What's the difference?

Skip the infra work. Deploy your first ClickHouse
project now

Get started for freeRead the docs
A geometric decoration with a matrix of rectangles.
Tinybird wordmark

Product /

ProductWatch the demoPricingSecurityRequest a demo

Company /

About UsPartnersShopCareers

Features /

Managed ClickHouseStreaming IngestionSchema IterationConnectorsInstant SQL APIsBI & Tool ConnectionsTinybird CodeTinybird AIHigh AvailabilitySecurity & Compliance

Support /

DocsSupportTroubleshootingCommunityChangelog

Resources /

ObservabilityBlogCustomer StoriesTemplatesTinybird BuildsTinybird for StartupsRSS FeedNewsletter

Integrations /

Apache KafkaConfluent CloudRedpandaGoogle BigQuerySnowflakePostgres Table FunctionAmazon DynamoDBAmazon S3

Use Cases /

User-facing dashboardsReal-time Change Data Capture (CDC)Gaming analyticsWeb analyticsReal-time personalizationUser-generated content (UGC) analyticsContent recommendation systemsVector search
All systems operational

Copyright © 2025 Tinybird. All rights reserved

|

Terms & conditionsCookiesTrust CenterCompliance Helpline