# Tinybird LLM Agent Sitemap

## About Tinybird

Tinybird is a real-time data platform that helps developers build real-time data products and APIs. It provides a serverless platform for ingesting, transforming, and serving real-time data through APIs.

### Core Value Proposition
Tinybird provides infrastructure and tooling to build, deploy, and iterate real-time APIs over massive data sets. Get fastest-database-in-the-world performance with zero maintenance overhead, query billions of rows in milliseconds with 99.9% uptime.

### Core Features
- Real-time data ingestion and processing
- SQL-based data transformations
- Instant API generation
- Serverless architecture
- Built-in monitoring and observability
- Native integrations with popular data sources

### Key Capabilities
1. Hosted OLAP Database
  - Incremental Materialized Views for 100x query speed
  - Automatic view updates
  - Zero maintenance overhead
  - 99.9% uptime guarantee

2. Real-time APIs
  - Deploy any query as a scalable OpenAPI endpoint
  - Auto-generated Swagger docs
  - Built-in observability
  - Dynamic query parameters
  - Token-based auth and rate-limiting
  - Scale to 1k+ RPS at sub-second latency

3. Events API
  - Stream JSON at 1K+ RPS
  - Direct POST from apps or serverless functions
  - No complex streaming infrastructure needed

4. Developer Experience
  - Complete CLI for local development
  - Data defined as code
  - Git-based version control
  - Painless schema migrations
  - Built-in observability
  - AI-powered development with vibe code

## Tinybird Documentation
The documentation for the product is available at https://www.tinybird.co/docs and you can have more context about it there. Also, check the https://www.tinybird.co/docs/llms.txt and https://www.tinybird.co/docs/llms-full.txt for more context about the product.

## Static Pages

- [Tinybird · Ship faster with Managed ClickHouse®](https://www.tinybird.co/)
  - The data infrastructure and tooling to ship enterprise grade analytical features faster and at a fraction of the cost

- [Infra and tooling to build data-intensive software](https://www.tinybird.co/product)
  - Tinybird is the modern real-time data platform that ingests data at scale, supports SQL and Git, and publishes API endpoints for everyone on your team to consume.

- [AI Developer Experience - ClickHouse for Developers & Agents | Tinybird](https://www.tinybird.co/product/ai)
  - Build, test, and ship real-time analytics with local dev, branches, CI/CD, and AI agent skills. All the power of ClickHouse, none of the ops.

- [Pricing · Tinybird](https://www.tinybird.co/pricing)
  - Tinybird's pricing scales elastically based on compute, so you pay based on the value and insights delivered to your users.

- [Connectors · Tinybird](https://www.tinybird.co/product/connectors)
  - Ingest data from the platforms you already use. No code, no hassle.

- [Streaming Ingestion · Tinybird](https://www.tinybird.co/product/streaming-ingestion)
  - Send events over HTTP or from your favorite data source. Available for queries in seconds.

- [Instant SQL APIs · Tinybird](https://www.tinybird.co/product/instant-sql-apis)
  - Turn SQL into an endpoint or lambda. Deploy analytics APIs in seconds.

- [Managed ClickHouse for Developers · Tinybird](https://www.tinybird.co/product/managed-clickhouse)
  - Tinybird is a managed ClickHouse service for AI-native software teams. Get the performance of ClickHouse without the pain of managing it, and focus on shipping your use case, not scaling a new database.

- [High Availability · Tinybird](https://www.tinybird.co/product/high-availability)
  - Your analytics infrastructure should never go down. Tinybird is built so it doesn't — distributed, redundant, and self-healing from the ground up.

- [Schema Iteration · Tinybird](https://www.tinybird.co/product/schema-iteration)
  - Safe migrations with zero downtime. Evolve your data model in production.

- [Security and compliance · Tinybird](https://www.tinybird.co/product/security-and-compliance)
  - Enterprise-grade security and compliance. Trust and reliability built-in.

- [Separation of Compute · Tinybird](https://www.tinybird.co/product/separation-of-compute)
  - Scale with zero-copy replication. Keep workloads isolated for predictable performance.

- [BI & Tool Connections · Tinybird](https://www.tinybird.co/product/direct-db-connection)
  - Connect your BIs, ORMs, and favorite tools. Native connection to your analytics database.

- [Blog · Tinybird](https://www.tinybird.co/blog)
  - Musings on transformations, tables and everything in between.

- [Customer Stories · Tinybird](https://www.tinybird.co/customer-stories)
  - We help software teams ship features with massive data sets.

- [Templates · Tinybird](https://www.tinybird.co/templates)
  - Explore our collection of templates

- [About us · Tinybird](https://www.tinybird.co/about)
  - We build tools developers love, and data teams trust. Tinybird isn't just a fast database. Tinybird makes YOU faster.

- [Contact Sales · Tinybird](https://www.tinybird.co/contact-us)
  - Get in touch with our sales team.

- [ClickHouse® for Developers • Tinybird](https://www.tinybird.co/clickhouse-for-developers)
  - A video series for developers that simplifies ClickHouse and teaches how to build fast, efficient analytics products.

- [Tinybird Builds • Live coding with Tinybird and friends](https://www.tinybird.co/builds)
  - Subscribe to Tinybird Builds, featuring live builds of real-time analytics projects from end to end. Learn how to master ClickHouse live.

- [Observability · Tinybird](https://www.tinybird.co/observability)
  - The Simple, High‑Performance Observability Stack

- [Data Crash Course · Tinybird](https://www.tinybird.co/data-crash-course)
  - 


## Customer Stories

- [How Order Editing Replaced a Failing DynamoDB Pipeline with Tinybird](https://www.tinybird.co/customer-stories/orderediting)
  - From reconciliation failures to reliable analytics for 2,000+ Shopify merchants.
  - Customer: Order Editing
- [The Linux Foundation tracks 700M+ open source events in real-time with Tinybird](https://www.tinybird.co/customer-stories/linux-foundation)
  - Real-time open source project analytics with Tinybird.
  - Customer: The Linux Foundation
- [How Fever Made Real-Time Partner Reporting Reliable Under Load with Tinybird](https://www.tinybird.co/customer-stories/fever)
  - Real-Time partner reporting reliable under load with Tinybird.
  - Customer: Fever
- [Scrunch ships AI search analytics from decision to production in 48 hours with Tinybird](https://www.tinybird.co/customer-stories/scrunch)
  - Shipping real-time AI search features faster with Tinybird
  - Customer: Scrunch
- [Humblytics cuts infrastructure costs 10x by migrating from Timescale to Tinybird](https://www.tinybird.co/customer-stories/humblytics)
  - Cutting costs 10x and eliminating database sprints with Tinybird.
  - Customer: Humblytics
- [How Sync bills for real-time AI model usage with Tinybird](https://www.tinybird.co/customer-stories/sync)
  - Building real-time, usage-based billing for AI-powered lip syncing.
  - Customer: Sync
- [Marc Lou gets ClickHouse® performance without ClickHouse complexity using Tinybird](https://www.tinybird.co/customer-stories/marc-lou)
  - Getting ClickHouse performance without ClickHouse complexity.
  - Customer: Marc Lou
- [Framer upgrades user-facing analytics to real-time with Tinybird](https://www.tinybird.co/customer-stories/framer)
  - Upgraded user‑facing analytics to real‑time with Tinybird.
  - Customer: Framer
- [Phantom gives crypto traders faster buy/sell decisions with Tinybird](https://www.tinybird.co/customer-stories/phantom)
  - Giving crypto traders faster buy/sell decisions with Tinybird.
  - Customer: Phantom
- [How Raindrop became the Sentry of AI: Scaling to petabytes with Tinybird](https://www.tinybird.co/customer-stories/raindrop)
  - Becoming the Sentry of AI: Scaling to petabytes with Tinybird
  - Customer: Raindrop
- [Clearwater Dynamics uses Tinybird to power its maritime insurtech solution](https://www.tinybird.co/customer-stories/clearwater-dynamics)
  - Powering analytics for millions of vessel position reports daily.
  - Customer: Clearwater Dynamics
- [Resend delivers email metrics to builders with Tinybird](https://www.tinybird.co/customer-stories/resend)
  - Delivering email metrics to builders with Tinybird
  - Customer: Resend
- [Zembula fast-tracks its roadmap with Tinybird](https://www.tinybird.co/customer-stories/zembula)
  - Real-time email attribution with Tinybird.
  - Customer: Zembula
- [Plain builds real‑time customer support insights with Tinybird](https://www.tinybird.co/customer-stories/plain)
  - Building real‑time customer support insights with Tinybird.
  - Customer: Plain
- [Blacksmith builds faster CI analytics with Tinybird](https://www.tinybird.co/customer-stories/blacksmith)
  - Building faster CI analytics with Tinybird.
  - Customer: Blacksmith
- [Audiense evolves its social media timeline with Tinybird](https://www.tinybird.co/customer-stories/audiense)
  - Unleashing the value of X data with Tinybird.
  - Customer: Audiense
- [Dub shortens time to market for user-facing analytics with Tinybird](https://www.tinybird.co/customer-stories/dub)
  - Faster to market for user‑facing analytics with Tinybird.
  - Customer: Dub
- [Genially uses Tinybird to display realtime content interaction metrics for their customers](https://www.tinybird.co/customer-stories/genially-uses-tinybird-to-display-realtime-metrics)
  - Real-time content interaction metrics with Tinybird.
  - Customer: Genially
- [LocalStack scales product analytics with Tinybird](https://www.tinybird.co/customer-stories/localstack-relies-on-tinybird-to-understand-and-improve-their-product)
  - Analyzing 100,000+ instances in realtime with Tinybird.
  - Customer: LocalStack
- [Situm relies on Tinybird to accelerate the speed of data processing and querying at scale](https://www.tinybird.co/customer-stories/situm-accelerates-data-processing-and-querying-with-tinybird)
  - Faster IoT data processing at scale with Tinybird.
  - Customer: Situm
- [Smartme Analytics builds complete consumer insights with Tinybird](https://www.tinybird.co/customer-stories/smartme-analytics)
  - Building complete consumer insights with Tinybird.
  - Customer: Smartme Analytics
- [The Hotels Network relies on Tinybird to help customers turn lookers into bookers](https://www.tinybird.co/customer-stories/the-hotels-network-realtime-analytics-with-tinybird)
  - Turning lookers into bookers with Tinybird.
  - Customer: The Hotels Network
- [Canva designs brilliant user experiences with Tinybird](https://www.tinybird.co/customer-stories/canva)
  - Designing brilliant user experiences with Tinybird.
  - Customer: Canva
- [Factorial builds real‑time data products with Tinybird](https://www.tinybird.co/customer-stories/factorial-builds-real-time-data-products-with-tinybird)
  - Building real‑time data products with Tinybird.
  - Customer: Factorial
- [FanDuel scores big with real‑time insights via Tinybird](https://www.tinybird.co/customer-stories/fanduel)
  - Scoring big with real‑time insights via Tinybird.
  - Customer: FanDuel
- [Vercel uses Tinybird to help developers ship code faster](https://www.tinybird.co/customer-stories/vercel-relies-on-tinybird-to-power-their-realtime-user-facing-analytics)
  - Using Tinybird to help developers ship code faster
  - Customer: Vercel

## Templates

- [OpenTelemetry](https://www.tinybird.co/templates/opentelemetry)
  - Instrument your application with Tinybird and OpenTelemetry
  - Categories: monitoring, opentelemetry, foundation

- [Web Analytics](https://www.tinybird.co/templates/web-analytics-starter-kit)
  - Build your own real-time web analytics app using Tinybird
  - Categories: dashboard, nextjs, starter, foundation, analytics

- [Analytics Agents](https://www.tinybird.co/templates/analytics-agents)
  - Build your own analytics agent using Tinybird
  - Categories: ai, starter, agno, slack, python

- [Logs Explorer](https://www.tinybird.co/templates/logs-explorer-template)
  - Build your own real-time logs explorer using Tinybird
  - Categories: dashboard, nextjs, starter, foundation, analytics

- [LLM Tracker](https://www.tinybird.co/templates/ai-analytics-template)
  - Build your own real-time LLM usage tracker
  - Categories: dashboard, nextjs, starter, foundation, analytics, ai, clerk

- [Organization Metrics](https://www.tinybird.co/templates/tinybird-org-metrics)
  - Monitor your Tinybird organization metrics
  - Categories: monitoring, datadog, grafana, organizations, foundation

- [Ghost CMS](https://www.tinybird.co/templates/ghost-tinybird)
  - Analyze your Ghost CMS metrics with Tinybird
  - Categories: ghost, foundation, analytics

- [URL Shortener](https://www.tinybird.co/templates/dub)
  - Build an URL shortener with Dub and Tinybird
  - Categories: analytics, starter, nextjs

- [Inbox Zero](https://www.tinybird.co/templates/inbox-zero)
  - Build an AI email assistant to reach inbox zero
  - Categories: analytics, starter, nextjs, ai

- [Clerk JWT](https://www.tinybird.co/templates/clerk-jwt)
  - Build multi-tenant apps with Clerk and Tinybird
  - Categories: jwt, demo, clerk

- [Auth0 JWT](https://www.tinybird.co/templates/auth0-jwt)
  - Build multi-tenant apps with Auth0 and Tinybird
  - Categories: jwt, demo, auth0

- [MCP Analytics](https://www.tinybird.co/templates/mcp-server-analytics)
  - Monitor your MCP server logs with Tinybird
  - Categories: monitoring, grafana, starter, ai

- [Vercel Log Drains](https://www.tinybird.co/templates/vercel-log-drains)
  - Explore your Vercel logs with Tinybird
  - Categories: dashboard, nextjs, starter, analytics

## Blog Posts

- [How Tinybird's storage architecture works: S3, local caching, and zero-copy replication](https://www.tinybird.co/blog/md/tinybird-architecture)
  - How we run ClickHouse on top of object storage with local SSD caching, zero-copy replication, and a packed part format that cuts S3 costs by 30-40%.
  - Published: 2026-03-02 10:00:00

- [How We Built Branches: Sharing Production Data Without Copying It](https://www.tinybird.co/blog/md/branches-deep-dive)
  - The engineering behind Tinybird branches: zero-copy partition sharing via ClickHouse metadata, Kafka consumer group isolation, S3 sample imports, and CI/CD preview deployments.
  - Published: 2026-02-26 00:00:00

- [Branches are GA: data infrastructure for agents](https://www.tinybird.co/blog/md/branches-ga)
  - Branches now support Kafka, S3, and GCS connectors, preview deployments from CI, and agentic development workflows. Branches are how agents develop with Tinybird.
  - Published: 2026-02-24 12:00:00

- [How Order Editing Replaced a Failing DynamoDB Pipeline with Tinybird](https://www.tinybird.co/blog/md/orderediting)
  - A three-person team running $5B in Shopify GMV couldn't afford to babysit analytics infrastructure. Here's how they stopped debugging reconciliation failures and started shipping features.
  - Published: 2026-02-24 11:00:00

- [We built our own AI coding agent. Here's why we're sunsetting it.](https://www.tinybird.co/blog/md/deprecating-tinybird-code)
  - We're deprecating Tinybird Code. Not because we've lost faith in AI, but because of how much we've learned doing it.
  - Published: 2026-02-20 10:00:00

- [How We Built Tinybird's TypeScript SDK for ClickHouse](https://www.tinybird.co/blog/md/clickhouse-typescript-sdk)
  - How we built the Tinybird TypeScript SDK: phantom types for compile-time inference, esbuild for schema loading, and a dev workflow that connects your app and data layer.
  - Published: 2026-02-19 00:00:00

- [Tinybird, now in TypeScript](https://www.tinybird.co/blog/md/tinybird-now-in-typescript)
  - Introducing Tinybird's TypeScript SDK. Define datasources, pipes, and connectors as TypeScript code. Get type-safe ingestion, autocomplete for queries, and a CLI that feels like modern app development.
  - Published: 2026-02-17 00:00:00

- [The Linux Foundation tracks 700M+ open source events in real-time with Tinybird](https://www.tinybird.co/blog/md/linux-foundation)
  - Learn how the Linux Foundation powers real-time open source project analytics for LFX Insights, replacing a 12-hour Snowflake feedback loop with sub-second data freshness.
  - Published: 2026-02-16 10:00:00

- [How We Built Time Series: Configuration-Driven Visualization in Tinybird Forward](https://www.tinybird.co/blog/md/how-we-built-timeseries)
  - How we rebuilt Time Series: the SQL problems we hit, the ClickHouse patterns we used, and how we use it to debug our own alerts.
  - Published: 2026-02-09 00:00:00

- [How We Built Playgrounds: Bringing Browser-Based SQL Back to Tinybird Forward](https://www.tinybird.co/blog/md/how-we-built-playgrounds)
  - A technical deep-dive into the architecture decisions behind Playgrounds: Redis storage, workspace sharing, split-screen panels, template parameters, and AI-assisted SQL with diff preview.
  - Published: 2026-02-04 00:00:00

- [Apache Iceberg with ClickHouse: Integration & Optimization](https://www.tinybird.co/blog/md/clickhouse-apache-iceberg-integration)
  - Learn how to read and query Apache Iceberg tables directly from ClickHouse, with optimization tips and real-world examples for building scalable data lakes.
  - Published: 2026-02-04 00:00:00

- [How Fever Made Real-Time Partner Reporting Reliable Under Load with Tinybird](https://www.tinybird.co/blog/md/fever)
  - Learn how one of the world's largest live entertainment platforms replaced a fragile real-time ingestion pipeline with Tinybird, eliminating the inverse scaling problem where better business meant worse reporting.
  - Published: 2026-02-02 15:00:00

- [Nobody Ever Got Fired for Buying Confluent](https://www.tinybird.co/blog/md/ibm-confluent)
  - IBM buying Confluent is just another move to secure a safe place for enterprise. Nobody ever got fired for buying IBM—or Confluent.
  - Published: 2026-02-02 00:00:00

- [Best Database Choices for Fast SaaS Embedded Analytics](https://www.tinybird.co/blog/md/Best-Database-Choices-for-Fast-SaaS-Embedded-Analytics)
  - Choose the best embedded analytics database for SaaS to deliver fast, reliable dashboards and avoid noisy neighbor issues.
  - Published: 2026-01-31 00:00:00

- [New and improved Time Series Charts & Playgrounds in Forward](https://www.tinybird.co/blog/md/playgrounds-timeseries-browser-experience)
  - Whether you want to Explore with AI, Write SQL directly or visualize data, you can now do it from the browser in Tinybird Forward. Time Series and Playgrounds bring back the flexibility of Classic, improved for Forward
  - Published: 2026-01-29 00:00:00

- [Tinybird Best Practices for AI Agents](https://www.tinybird.co/blog/md/tinybird-best-practices-for-ai-agents)
  - Turn any AI coding agent into a Tinybird expert. 20 rules covering schema design, endpoints, materialized views, testing, and deployment.
  - Published: 2026-01-27 00:00:00

- [How we built a production Kafka connector for ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-kafka-connector)
  - How we built a scalable, reliable Kafka connector that processes billions of events with minimal operational overhead
  - Published: 2026-01-22 00:00:00

- [Fast Charts with Real-Time Data: Fix Slow Dashboards Fast](https://www.tinybird.co/blog/md/Fast-Charts-real-Time-Data)
  - Your real-time dashboard isn’t slow from rendering. Learn how to fix data, payload, and query bottlenecks for fast charts.
  - Published: 2026-01-15 00:00:00

- [How Analytics at Scale Breaks in Production](https://www.tinybird.co/blog/md/analytics-at-scale)
  - Learn why analytics at scale breaks in production and how Tinybird fixes performance, cost, and operational complexity.
  - Published: 2026-01-15 00:00:00

- [7 Real Time App Architecture Approaches Beyond WebSockets](https://www.tinybird.co/blog/md/build-real-time-apps)
  - Explore 7 real-time app architecture approaches beyond WebSockets and learn to scale live data systems with reliability.
  - Published: 2026-01-15 00:00:00

- [9 ClickHouse® Features Most Teams Don't Know They're Missing](https://www.tinybird.co/blog/md/clickhouse-with-more-features)
  - Uncover 9 hidden ClickHouse® features that boost query speed and simplify analytics far beyond basic OLAP capabilities.
  - Published: 2026-01-15 00:00:00

- [How We Built Tinybird Wrapped: A Year in Data](https://www.tinybird.co/blog/md/how-we-built-tinybird-wrapped)
  - Learn how we built Tinybird Wrapped, a yearly recap feature that aggregates and visualizes customer usage metrics across multiple regions, time periods, and data sources using... Tinybird!
  - Published: 2026-01-15 00:00:00

- [7 In Product Dashboard Options Beyond Embedded BI](https://www.tinybird.co/blog/md/inproduct-dashboards)
  - Explore 7 in-product dashboard options beyond embedded BI and deliver seamless real-time analytics within your application.
  - Published: 2026-01-15 00:00:00

- [Best Practices to Backfill Materialized Views in ClickHouse® Safely](https://www.tinybird.co/blog/md/backfilling-materialized-views-diy-vs-tinybird-and-best-practices)
  - Backfilling materialized views in ClickHouse®, how to do it safely and how Tinybird helps to reduce operational burden.
  - Published: 2026-01-09 00:00:00

- [ClickHouse® BYOC vs. Fully Managed: 8 Deployment Options Compared](https://www.tinybird.co/blog/md/clickhouse-byoc)
  - Compare ClickHouse BYOC vs fully managed. Understand costs, control, and simplicity before choosing your best fit.
  - Published: 2026-01-04 00:00:00

- [Hetzner ClickHouse® Hosting vs. 8 Managed Alternatives](https://www.tinybird.co/blog/md/hetzner-clickhouse-hosting)
  - Compare Hetzner ClickHouse Hosting vs 8 alternatives. Tinybird delivers higher value with no ops burden or hidden costs.
  - Published: 2026-01-04 00:00:00

- [ClickHouse® Kafka Engine vs Tinybird Kafka Connector](https://www.tinybird.co/blog/md/clickhouse-kafka-engine-vs-tinybird-connector)
  - Compare ClickHouse OSS Kafka Engine and Tinybird's Kafka connector. Understand tradeoffs, failure modes and when to choose each solution for your Kafka to ClickHouse pipeline.
  - Published: 2025-12-31 00:00:00

- [How to Fix Kafka to ClickHouse® Performance Bottlenecks](https://www.tinybird.co/blog/md/how-to-fix-kafka-to-clickhouse-performance-bottlenecks)
  - Learn how to optimize your Kafka to ClickHouse pipeline performance with schema optimization, Materialized View tuning, partition distribution strategies and throughput best practices.
  - Published: 2025-12-30 00:00:00

- [MongoDB Alternatives: 10 Best Options Compared for 2026](https://www.tinybird.co/blog/md/MongoDB-Alternatives)
  - Using MongoDB for analytics? Discover the 10 best MongoDB alternatives for real-time analytics in 2026 to boost performance.
  - Published: 2025-12-26 00:00:00

- [ParadeDB Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/ParadeDB-Alternatives)
  - Find the best ParadeDB alternatives for 2026 offering real-time analytics, effortless management, and unmatched performance.
  - Published: 2025-12-26 00:00:00

- [StarRocks Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/StarRocks-Alternatives)
  - Compare leading StarRocks alternatives like Tinybird, ClickHouse, and Druid. Real-time power, zero ops burden.
  - Published: 2025-12-26 00:00:00

- [ClickHouse® Courses: 5 Best Options to Learn ClickHouse® in 2026](https://www.tinybird.co/blog/md/clickhouse-course)
  - Learn ClickHouse® from fundamentals to production patterns. Compare the best courses, from Tinybird's free developer-focused training to official ClickHouse® Academy and professional certifications.
  - Published: 2025-12-26 00:00:00

- [Why Kafka pipelines fail (and how to fix them)](https://www.tinybird.co/blog/md/why-kafka-pipelines-fail)
  - Kafka pipelines fail in predictable ways. These are the mistakes that break streaming data and how to prevent them before they happen.
  - Published: 2025-12-23 00:00:00

- [Citus Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/Citus-Alternatives)
  - Citus alternatives for distributed analytics in 2026. If Postgres scaling isn't enough, these options offer different tradeoffs.
  - Published: 2025-12-22 00:00:00

- [CockroachDB Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/CockroachDB-Alternatives)
  - Discover the 8 best CockroachDB alternatives in 2026. Compare Tinybird, PostgreSQL, and more to find your ideal database.
  - Published: 2025-12-22 00:00:00

- [ScyllaDB Alternatives: 9 Best Options Compared for 2026](https://www.tinybird.co/blog/md/ScyllaDB-Alternatives)
  - Compare the best ScyllaDB alternatives. Avoid complexity and choose the right database architecture for your team.
  - Published: 2025-12-22 00:00:00

- [TimescaleDB (TigerData) Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/TimescaleDB-TigerData-Alternatives)
  - Discover the best TimescaleDB (TigerData) alternatives in 2026 and choose the ideal time-series database for your workloads.
  - Published: 2025-12-22 00:00:00

- [Build a Real-Time E-Commerce Analytics API from Kafka in 15 Minutes](https://www.tinybird.co/blog/md/build-real-time-ecommerce-analytics-api-kafka)
  - Build a real-time ecommerce analytics API with Kafka in hours, not weeks. This tutorial covers the complete architecture.
  - Published: 2025-12-17 00:00:00

- [Build a Real-Time E-Commerce Analytics API from Kafka - II](https://www.tinybird.co/blog/md/build-real-time-ecommerce-analytics-api-kafka-part-2)
  - Build a real-time ecommerce analytics API with Kafka part 2: add dashboards, alerts, and user-facing metrics to your store.
  - Published: 2025-12-17 00:00:00

- [How to Achieve Real-Time Exactly-Once Ingestion from Kafka to ClickHouse](https://www.tinybird.co/blog/md/kafka-to-clickhouse-exactly-once)
  - Exactly-once delivery from Kafka to ClickHouse isn't magic. It's architecture. Here's the pattern that guarantees no duplicates.
  - Published: 2025-12-16 00:00:00

- [Apache Kafka Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/apache-kafka-alternatives)
  - Compare Apache Kafka with Tinybird, Pulsar, and Kinesis. Discover the top alternatives for real-time streaming in 2026.
  - Published: 2025-12-11 00:00:00

- [Big Data Workflow Automation Tools for Real-Time Analytics](https://www.tinybird.co/blog/md/big-data-workflow-automation)
  - Explore the 8 best Big Data Workflow Automation Tools for 2026 and boost real-time analytics with faster, simpler solutions.
  - Published: 2025-12-11 00:00:00

- [Business Intelligence Software: 10 Best Options Compared for 2026](https://www.tinybird.co/blog/md/business-intelligence-software)
  - Compare the 8 best business intelligence software solutions and find the perfect fit for real-time analytics in 2026.
  - Published: 2025-12-11 00:00:00

- [Change Data Capture Tools: 10 Best Options Compared](https://www.tinybird.co/blog/md/change-data-capture-tools)
  - Compare the 8 best Change Data Capture tools in 2026 and see how Tinybird simplifies real-time analytics without added complexity.
  - Published: 2025-12-11 00:00:00

- [Data Integration Problems: 10 Common Issues and How to Solve Them](https://www.tinybird.co/blog/md/data-integration-problems)
  - Avoid the most critical Data Integration Problems with real solutions that simplify your architecture and boost real-time analytics.
  - Published: 2025-12-11 00:00:00

- [Big Data Workflow Automation Tools for Real-Time Analytics](https://www.tinybird.co/blog/md/data-workflow-automation)
  - Explore the best data workflow automation tools for modern analytics and learn when Tinybird outperforms traditional orchestration.
  - Published: 2025-12-11 00:00:00

- [6 Apache Flink Alternatives for Simpler Real Time Analytics](https://www.tinybird.co/blog/md/flink-alternatives)
  - Explore the 6 best Apache Flink alternatives for stream processing. Simpler, faster, and smarter options for 2026.
  - Published: 2025-12-11 00:00:00

- [How to Monitor Kafka with ClickHouse® Kafka Engine](https://www.tinybird.co/blog/md/kafka-monitoring-clickhouse-kafka-engine)
  - Kafka monitoring with ClickHouse Kafka Engine breaks in ways nobody documents. Here's how to set it up properly.
  - Published: 2025-12-10 00:00:00

- [8 Data Management Platform Alternatives Beyond Governance](https://www.tinybird.co/blog/md/Data-Management-Platforms)
  - Explore the 8 best data management platforms for 2026 and find the right one for your data-driven business.
  - Published: 2025-12-04 00:00:00

- [6 Data Migration Solutions Beyond Traditional Production Moves](https://www.tinybird.co/blog/md/Data-Migration-Solutions)
  - 2026 guide to data migration solutions: compare 6 best tools, prevent data loss, and ensure fast, secure migrations.
  - Published: 2025-12-04 00:00:00

- [10 Open Source Data Analytics Tools for a Modern Vendor Free Stack](https://www.tinybird.co/blog/md/Open-Source-Data-Analytics-Tools)
  - Explore the best open source data analytics tools in 2026, their strengths, limits, and when to choose managed platforms.
  - Published: 2025-12-04 00:00:00

- [6 Healthcare Data Integration Strategies for Secure Systems](https://www.tinybird.co/blog/md/healthcare-data-integration)
  - Learn how healthcare data integration drives real-time analytics, improves patient care, and ensures regulatory compliance.
  - Published: 2025-12-04 00:00:00

- [6 Instaclustr Managed ClickHouse® Alternatives Beyond Hosting](https://www.tinybird.co/blog/md/instaclustr-managed-clickHouse-alternatives)
  - Instaclustr managed ClickHouse alternatives offer different tradeoffs on price, performance, and features. Compare before migrating.
  - Published: 2025-12-01 00:00:00

- [6 Altinity Cloud Alternatives Beyond Kubernetes ClickHouse®](https://www.tinybird.co/blog/md/altinity-cloud-alternatives)
  - Explore the 6 best Altinity Cloud alternatives for managed ClickHouse®. Compare platforms and find the right fit for your needs.
  - Published: 2025-12-01 00:00:00

- [8 Amazon Redshift Alternatives Beyond Traditional Warehouses](https://www.tinybird.co/blog/md/amazon-redshift-alternatives)
  - Compare the best Amazon Redshift alternatives and pick the right fit for modern analytics: Tinybird, Snowflake, BigQuery, and more.
  - Published: 2025-12-01 00:00:00

- [8 Apache Druid Alternatives: Beyond Complex OLAP Infrastructure](https://www.tinybird.co/blog/md/apache-druid-alternatives)
  - Explore the 8 best Apache Druid alternatives for real-time analytics, offering faster speed and simpler operations.
  - Published: 2025-12-01 00:00:00

- [7 Apache Pinot Alternatives Beyond Index Driven OLAP](https://www.tinybird.co/blog/md/apache-pinot-alternatives)
  - Full guide to Apache Pinot alternatives: simpler, faster, and more efficient platforms for real-time analytics.
  - Published: 2025-12-01 00:00:00

- [8 DuckDB Alternatives: When In-Process Analytics Isn't Enough](https://www.tinybird.co/blog/md/duckdb-alternatives)
  - Explore the 8 best DuckDB alternatives for embedded and analytical workloads, perfect for data science, ETL, and production.
  - Published: 2025-12-01 00:00:00

- [Google Cloud BigQuery Alternatives: 10 Best Options Compared](https://www.tinybird.co/blog/md/google-cloud-bigquery-alternatives)
  - Explore the 10 best BigQuery alternatives for modern data analytics, from Tinybird to Snowflake, balancing speed and flexibility.
  - Published: 2025-12-01 00:00:00

- [8 Tinybird Alternatives Beyond Real Time Analytics](https://www.tinybird.co/blog/md/tinybird-alternatives)
  - Explore the 8 best Tinybird alternatives for real-time analytics and find the platform that fits your performance needs.
  - Published: 2025-12-01 00:00:00

- [Branches: test with real data in isolated environments](https://www.tinybird.co/blog/md/introducing-branches-in-beta)
  - Branches are now in beta. Develop and test Tinybird projects in isolation before merging to production. No more risky deploys.
  - Published: 2025-11-19 12:00:00

- [Building resilient ingestion with smart backpressure handling](https://www.tinybird.co/blog/md/backpressure-improvements)
  - Backpressure improvements prevent data loss during traffic spikes. Ingestion stays reliable even when volume exceeds expectations.
  - Published: 2025-11-18 12:00:00

- [Self-serve replicas for dedicated infrastructure: private beta](https://www.tinybird.co/blog/md/self-serve-replicas-beta)
  - Self-serve replicas are now in beta. Spin up read replicas on demand without waiting for support. Test it yourself today.
  - Published: 2025-11-17 08:00:00

- [7 Altinity Cloud Managed ClickHouse® Alternatives Beyond BYOC](https://www.tinybird.co/blog/md/altinity-cloud-managed-clickhouse)
  - Discover how Altinity Cloud delivers managed ClickHouse® on Kubernetes with control, flexibility and expert support for demanding teams
  - Published: 2025-11-14 00:00:00

- [8 Best Real-Time Data Analytics Tools Beyond OLAP Databases](https://www.tinybird.co/blog/md/best-real-time-data-analytics-tools)
  - The best real-time data analytics tools in 2026 balance speed, cost, and developer experience. These options lead the market.
  - Published: 2025-11-14 00:00:00

- [8 BigQuery Alternatives Beyond Serverless Warehouses](https://www.tinybird.co/blog/md/bigquery-alternatives)
  - BigQuery bills are getting ridiculous and your app is still slow. These alternatives solve both problems at once.
  - Published: 2025-11-14 00:00:00

- [8 Databricks Alternatives Beyond Lakehouse Platforms](https://www.tinybird.co/blog/md/databricks-alternatives)
  - Compare Databricks alternatives and discover 8 top tools for unified analytics, cutting costs and speeding up insights from your data
  - Published: 2025-11-14 00:00:00

- [8 Managed Data Platform Alternatives Beyond Unified Platforms](https://www.tinybird.co/blog/md/managed-data-platforms)
  - Explore managed data platforms for real time analytics with fast queries and easy scaling to enhance performance and reliability
  - Published: 2025-11-14 00:00:00

- [Materialize Alternatives: 10 Best Options Compared for 2026](https://www.tinybird.co/blog/md/materialize-alternatives)
  - Explore the best Materialize alternatives to boost real time analytics with fast queries flexible models and smarter data choices today now
  - Published: 2025-11-14 00:00:00

- [Snowflake Alternatives: 10 Best Options Compared for 2026](https://www.tinybird.co/blog/md/snowflake-alternatives)
  - Deep dive into 10 Snowflake alternatives, explaining tradeoffs in latency, pricing, cloud fit, and real time vs batch analytics quickly!
  - Published: 2025-11-14 00:00:00

- [7 Star-Tree Alternatives: When Index Optimization Isn't the Answer](https://www.tinybird.co/blog/md/startree-alternatives)
  - Explore 7 best StarTree alternatives for real-time analytics and pick the platform that gives your product the speed and scale it needs.
  - Published: 2025-11-14 00:00:00

- [8 Striim Alternatives: When CDC Platforms Aren't the Answer](https://www.tinybird.co/blog/md/striim-alternatives)
  - Discover 8 Striim alternatives for streaming data integration and real time pipelines, with pros, cons and ideal use cases for builders
  - Published: 2025-11-14 00:00:00

- [Step-by-step guide to self-host ClickHouse® for beginners (2026)](https://www.tinybird.co/blog/md/step-by-step-self-host-clickhouse)
  - Learn to self-host ClickHouse® with our complete 2026 guide covering installation, configuration, monitoring, and production-ready deployment strategies.
  - Published: 2025-11-07 17:24:11

- [Best ClickHouse® alternatives for real-time apps and analytics](https://www.tinybird.co/blog/md/clickhouse-alternative-real-time-apps)
  - Discover the best ClickHouse® alternatives for real-time apps including managed services, OLAP engines, and cloud warehouses with migration tips.
  - Published: 2025-11-07 17:11:20

- [How much does it cost to self-host ClickHouse® in 2026?](https://www.tinybird.co/blog/md/self-hosted-clickhouse-cost)
  - Find out the true cost to self-host ClickHouse® in 2026. Compare compute, storage, and hidden engineering costs vs managed services.
  - Published: 2025-11-07 17:09:31

- [How to build real-time APIs with ClickHouse® using Tinybird](https://www.tinybird.co/blog/md/build-real-time-apis-clickhouse-tinybird)
  - Build real-time APIs on ClickHouse with Tinybird. Skip the infrastructure work and ship analytics endpoints in hours.
  - Published: 2025-11-07 17:08:23

- [Key differences between Tinybird and ClickHouse® Cloud in 2026](https://www.tinybird.co/blog/md/tinybird-vs-clickhouse-cloud-differences)
  - Tinybird vs ClickHouse Cloud differences go beyond pricing. Features, support, and developer experience vary significantly.
  - Published: 2025-11-07 13:07:50

- [ClickHouse® vs Pinot: Which database is faster?](https://www.tinybird.co/blog/md/clickhouse-vs-pinot)
  - ClickHouse vs Pinot for real-time analytics: both are fast, but use cases differ. This comparison helps you choose in 2026.
  - Published: 2025-10-31 20:14:56

- [ClickHouse® vs YDB: Performance Guide & Benchmarks](https://www.tinybird.co/blog/md/clickhouse-vs-ydb-performance-guide)
  - Compare ClickHouse® vs YDB performance, benchmarks, and architecture differences to choose the right database for your analytics and streaming workloads.
  - Published: 2025-10-31 19:30:19

- [ClickHouse® vs Elasticsearch: Can ClickHouse® handle search?](https://www.tinybird.co/blog/md/clickhouse-vs-elasticsearch-search)
  - Compare ClickHouse® vs Elasticsearch for analytics and search workloads, including performance, costs, and when to use each database for your specific use case.
  - Published: 2025-10-31 19:29:26

- [ClickHouse® vs YugabyteDB: database comparison guide](https://www.tinybird.co/blog/md/clickhouse-vs-yugabytedb)
  - Compare ClickHouse® vs YugabyteDB for analytics and transactions - architecture, performance, costs, and when to choose each database for your use case.
  - Published: 2025-10-31 19:29:16

- [ClickHouse® vs pg_mooncake: Does a Postgres columnstore work at scale?](https://www.tinybird.co/blog/md/clickhouse-vs-postgresql-pg-mooncake)
  - ClickHouse vs PostgreSQL pg_mooncake: columnar performance meets Postgres compatibility. This comparison helps you choose in 2026.
  - Published: 2025-10-31 19:29:03

- [ClickHouse® vs Umbra: Database comparison guide](https://www.tinybird.co/blog/md/clickhouse-vs-umbra)
  - Compare ClickHouse® vs Umbra databases for analytics workloads - architecture, performance, ACID compliance, and costs to choose the right solution.
  - Published: 2025-10-31 19:28:50

- [ClickHouse® vs MariaDB: Can the MySQL fork scale?](https://www.tinybird.co/blog/md/clickhouse-vs-mariadb-columnstore)
  - ClickHouse vs MariaDB ColumnStore performance varies by query type. This benchmark reveals where each database excels and struggles.
  - Published: 2025-10-31 19:28:32

- [How to deploy and manage ClickHouse® on AWS](https://www.tinybird.co/blog/md/managed-clickhouse-on-aws)
  - Learn how to deploy and manage ClickHouse® on AWS with step-by-step guides covering deployment models, data ingestion, scaling, and cost optimization tips.
  - Published: 2025-10-31 12:59:30

- [How to implement real-time streaming ingestion with ClickHouse®](https://www.tinybird.co/blog/md/how-to-streaming-ingestion-clickhouse)
  - Learn how to build high-performance real-time streaming ingestion pipelines with ClickHouse® using Kafka engines, materialized views, and optimization techniques.
  - Published: 2025-10-31 12:58:16

- [ClickHouse® vs MongoDB: Best for real-time applications?](https://www.tinybird.co/blog/md/clickhouse-vs-mongodb)
  - ClickHouse vs MongoDB for analytics: document store versus columnar. The performance difference for analytical queries is massive.
  - Published: 2025-10-27 19:51:43

- [ClickHouse® vs MonetDB: performance guide](https://www.tinybird.co/blog/md/clickhouse-vs-monetdb-performance-guide)
  - ClickHouse vs MonetDB performance depends on your workload type. This benchmark guide shows where each database wins and loses.
  - Published: 2025-10-27 19:50:04

- [ClickHouse® vs Databend: Comparing AI data warehouses](https://www.tinybird.co/blog/md/clickhouse-vs-databend-ai-warehouse)
  - ClickHouse vs Databend for AI warehouse workloads: cloud-native alternatives with different tradeoffs. Compare before you commit.
  - Published: 2025-10-27 19:45:33

- [ClickHouse® vs chDB: let’s talk about embedded ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-vs-chdb-embedded-clickhouse)
  - ClickHouse vs chDB embedded ClickHouse: server versus in-process tradeoffs. Pick the right deployment model for your use case.
  - Published: 2025-10-27 19:45:18

- [ClickHouse® vs StarRocks: Which one is actually faster?](https://www.tinybird.co/blog/md/clickhouse-vs-starrocks)
  - ClickHouse vs StarRocks for real-time analytics: both are fast, but architectures differ. This comparison shows which fits your needs.
  - Published: 2025-10-27 19:30:49

- [ClickHouse® vs SingleStore: Who wins OLAP vs HTAP](https://www.tinybird.co/blog/md/clickhouse-vs-singlestore-olap-vs-htap)
  - ClickHouse vs SingleStore: OLAP vs HTAP architectures serve different needs. This guide helps you pick the right approach in 2026.
  - Published: 2025-10-27 15:36:41

- [Scrunch ships AI search analytics from decision to production in 48 hours with Tinybird](https://www.tinybird.co/blog/md/scrunch)
  - Learn how the AI search optimization startup built real-time Agent Traffic features in just 48 hours, achieving 100% cost predictability while tripling in size.
  - Published: 2025-10-24 00:00:00

- [Humblytics cuts infrastructure costs 10x by migrating from Timescale to Tinybird](https://www.tinybird.co/blog/md/humblytics)
  - Learn how a bootstrapped analytics startup eliminated monthly database sprints, achieved 10x faster queries, and reduced costs by 10x by switching from TimescaleDB to Tinybird.
  - Published: 2025-10-23 00:00:00

- [ClickHouse® vs Amazon Athena for real-time analytics](https://www.tinybird.co/blog/md/clickhouse-vs-amazon-athena)
  - ClickHouse vs Amazon Athena: one charges per query, the other doesn't. The cost difference at scale might shock you.
  - Published: 2025-10-22 20:09:07

- [ClickHouse® vs Aurora MySQL: Performance Guide](https://www.tinybird.co/blog/md/clickhouse-vs-aurora-mysql-performance-guide)
  - ClickHouse vs Aurora MySQL performance differs dramatically for analytical workloads. This benchmark shows exactly where each wins.
  - Published: 2025-10-22 20:07:17

- [ClickHouse® vs TimescaleDB: Best for real-time analytics 2026](https://www.tinybird.co/blog/md/clickhouse-vs-timescaledb)
  - Compare ClickHouse® vs TimescaleDB performance, cost, and scalability to choose the right database for real-time analytics.
  - Published: 2025-10-22 20:07:06

- [ClickHouse® vs SQLite: Is serverless the best option in 2026?](https://www.tinybird.co/blog/md/clickhouse-vs-sqlite-serverless-choice)
  - Compare ClickHouse® vs SQLite for analytics: learn when each database fits best and if serverless ClickHouse® is the ideal choice.
  - Published: 2025-10-22 19:27:41

- [ClickHouse® vs OrioleDB: Can Postgres extensions keep up?](https://www.tinybird.co/blog/md/clickhouse-vs-orioledb)
  - Compare ClickHouse® vs OrioleDB architecture, performance benchmarks, and use cases to choose the right analytical database for your workloads.
  - Published: 2025-10-22 19:26:43

- [ClickHouse® vs CrateDB: Performance and Usage Comparison](https://www.tinybird.co/blog/md/clickhouse-vs-cratedb)
  - Compare ClickHouse® vs CrateDB performance, features, and costs with detailed benchmarks, architectural analysis, and deployment guidance to choose the right database.
  - Published: 2025-10-22 19:26:24

- [ClickHouse® vs ParadeDB: Can the parade keep up?](https://www.tinybird.co/blog/md/clickhouse-vs-paradedb)
  - Compare ClickHouse® vs ParadeDB for analytics workloads: architecture differences, performance benchmarks, scaling capabilities, and migration guidance.
  - Published: 2025-10-22 19:26:21

- [ClickHouse® vs Oxla: Database comparison guide](https://www.tinybird.co/blog/md/clickhouse-vs-oxla)
  - Compare ClickHouse® vs Oxla performance with benchmark results showing 6x faster joins and 3x faster GROUP BY operations for analytical workloads.
  - Published: 2025-10-22 19:25:39

- [ClickHouse® vs CockroachDB: Comparison Guide](https://www.tinybird.co/blog/md/clickhouse-vs-cockroachdb)
  - Compare ClickHouse® vs CockroachDB architecture, performance, and use cases to choose the right database for OLAP analytics or OLTP transactions.
  - Published: 2025-10-22 19:24:24

- [ClickHouse® vs DuckDB: How many nodes do you need?](https://www.tinybird.co/blog/md/clickhouse-vs-duckdb-nodes)
  - Compare ClickHouse® vs DuckDB node requirements, performance benchmarks, and scaling decisions to choose the right OLAP database for your workload size.
  - Published: 2025-10-21 20:06:30

- [ClickHouse® vs Citus for Real-Time Analytics](https://www.tinybird.co/blog/md/clickhouse-vs-citus-real-time-analytics)
  - ClickHouse vs Citus for real-time analytics: columnar versus distributed Postgres. This benchmark reveals the performance gap.
  - Published: 2025-10-21 20:05:07

- [ClickHouse® vs Aurora PostgreSQL: Performance Guide](https://www.tinybird.co/blog/md/clickhouse-vs-aurora-postgresql-performance)
  - Compare ClickHouse® vs Aurora PostgreSQL performance for analytics workloads with benchmarks, cost analysis, and migration strategies to optimize your data stack.
  - Published: 2025-10-21 20:04:05

- [ClickHouse® vs CedarDB: Is Cedar really faster?](https://www.tinybird.co/blog/md/clickhouse-vs-cedardb)
  - Compare ClickHouse® vs CedarDB performance, architecture, and real-world use cases to choose the right analytical database for your project.
  - Published: 2025-10-21 20:03:14

- [Flink's 95% problem](https://www.tinybird.co/blog/md/flink-is-95-problem)
  - Flink might sound like the holy grail of streaming data processing, but for 95% of us, it's just a complex headache we don't need.
  - Published: 2025-10-21 00:00:00

- [How to optimize ClickHouse® for high-throughput streaming](https://www.tinybird.co/blog/md/clickhouse-streaming-analytics)
  - ClickHouse streaming analytics processes millions of events per second. Here's how to build pipelines that keep up with your data.
  - Published: 2025-10-17 22:02:31

- [ClickHouse® vs MySQL for analytics performance and use cases](https://www.tinybird.co/blog/md/clickhouse-vs-mysql-for-analytics)
  - ClickHouse vs MySQL for analytics: row-based struggles where columnar excels. This benchmark shows exactly when to switch.
  - Published: 2025-10-17 21:25:21

- [Connect Grafana to ClickHouse®: examples and walkthrough](https://www.tinybird.co/blog/md/clickhouse-grafana-example)
  - ClickHouse Grafana example that connects in minutes. Visualize analytical data in your existing dashboards without moving anything.
  - Published: 2025-10-17 19:51:08

- [ClickHouse® Go example: How to connect, insert, and query with Go](https://www.tinybird.co/blog/md/clickhouse-golang-example)
  - ClickHouse Golang example with efficient batching. High-performance analytical queries from Go without the usual pitfalls.
  - Published: 2025-10-17 19:50:38

- [ClickHouse® Python examples: clickhouse-connect vs. clickhouse-driver](https://www.tinybird.co/blog/md/clickhouse-python-example)
  - ClickHouse Python example that works in production. Copy this code and start querying analytical data from Python in minutes.
  - Published: 2025-10-17 19:50:09

- [ClickHouse® query examples: query the fastest OLAP database](https://www.tinybird.co/blog/md/clickhouse-query-examples)
  - ClickHouse query examples that solve real problems. Copy, paste, and adapt these patterns for your own analytical workloads.
  - Published: 2025-10-17 19:45:43

- [How to connect to and query ClickHouse® from Java with examples](https://www.tinybird.co/blog/md/clickhouse-java-example)
  - ClickHouse Java example with connection pooling done right. Production-ready code you can deploy without modifications.
  - Published: 2025-10-17 19:30:27

- [Kafka to ClickHouse®: How to connect streaming data to ClickHouse®](https://www.tinybird.co/blog/md/kafka-to-clickhouse-example)
  - Kafka to ClickHouse example that handles backpressure and exactly-once delivery. Production-ready code you can deploy today.
  - Published: 2025-10-17 19:30:17

- [Building real-time, generative UIs for analytics with Tinybird](https://www.tinybird.co/blog/md/generative-analytics-ui-with-tinybird-and-thesys)
  - Learn how to create rich, generative analytics UIs backed by real-time data using Tinybird and C1 by Thesys.
  - Published: 2025-10-17 10:00:00

- [ClickHouse® CREATE TABLE example: Follow these steps](https://www.tinybird.co/blog/md/clickhouse-create-table-example)
  - ClickHouse CREATE TABLE example with the settings that actually matter. Stop copying bad defaults from outdated tutorials.
  - Published: 2025-10-16 19:30:02

- [ClickHouse® CTE example: How to use WITH in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-cte-example)
  - Learn ClickHouse® CTE examples with practical WITH clause syntax, performance tips, and real-world use cases to simplify complex SQL queries effectively.
  - Published: 2025-10-16 19:29:22

- [ClickHouse® ReplacingMergeTree examples and best use cases](https://www.tinybird.co/blog/md/clickhouse-replacingmergetree-example)
  - ClickHouse ReplacingMergeTree example that handles deduplication correctly. Most implementations miss critical settings. Don't.
  - Published: 2025-10-16 19:28:27

- [ClickHouse® left join examples: step-by-step guide for Clickhouse®](https://www.tinybird.co/blog/md/clickhouse-left-join-example)
  - ClickHouse LEFT JOIN example that performs well at scale. Most JOIN queries are written wrong. Here's the pattern that works.
  - Published: 2025-10-16 19:27:12

- [ClickHouse® materialized view: how to materialize data in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-create-materialized-view-example)
  - ClickHouse CREATE MATERIALIZED VIEW examples that actually work. Copy these patterns and adapt them for your streaming pipelines.
  - Published: 2025-10-16 19:26:38

- [Here are some ClickHouse® Cloud alternatives to consider](https://www.tinybird.co/blog/md/clickhouse-cloud-alternatives)
  - ClickHouse Cloud isn't your only option. Depending on your workload, these alternatives might fit better in 2026.
  - Published: 2025-10-14 00:00:00

- [ClickHouse® vs BigQuery: real-time analytics comparison 2026](https://www.tinybird.co/blog/md/clickhouse-vs-bigquery-real-time-analytics)
  - ClickHouse vs BigQuery for real-time analytics: speed versus ecosystem. This comparison helps you choose the right tool in 2026.
  - Published: 2025-10-14 00:00:00

- [ClickHouse® vs Databricks: Architecture, performance & cost](https://www.tinybird.co/blog/md/clickhouse-vs-databricks)
  - ClickHouse vs Databricks comes down to speed versus flexibility. The right choice depends on your workload. Here's how to decide.
  - Published: 2025-10-14 00:00:00

- [ClickHouse® vs Druid: Battle of real-time analytics engines](https://www.tinybird.co/blog/md/clickhouse-vs-druid)
  - ClickHouse vs Druid for real-time analytics? Both are fast, but architectures differ significantly. This comparison helps you choose.
  - Published: 2025-10-14 00:00:00

- [ClickHouse® vs Firebolt: Best for real-time analytics](https://www.tinybird.co/blog/md/clickhouse-vs-firebolt-real-time-data-warehouse)
  - Compare ClickHouse® and Firebolt on architecture, speed, and scale. Find out which fits your real-time analytics needs.
  - Published: 2025-10-14 00:00:00

- [ClickHouse® vs PostgreSQL in 2026 (with extensions)](https://www.tinybird.co/blog/md/clickhouse-vs-postgresql-with-extensions)
  - Compare ClickHouse® vs PostgreSQL performance, scalability, and analytics. Learn when to use each database and migrate smoothly.
  - Published: 2025-10-14 00:00:00

- [ClickHouse® vs Snowflake: Performance, pricing, and migration 2026](https://www.tinybird.co/blog/md/clickhouse-vs-snowflake)
  - ClickHouse vs Snowflake for real-time analytics: warehouse versus OLAP. The latency and cost differences are significant.
  - Published: 2025-10-14 00:00:00

- [Master ClickHouse® array functions for analytics and manipulation](https://www.tinybird.co/blog/md/clickhouse-array-functions)
  - ClickHouse array functions unlock powerful analytical patterns. These examples solve problems that frustrate most SQL developers.
  - Published: 2025-10-10 00:00:00

- [How to set up your ClickHouse® config.xml file (with examples)](https://www.tinybird.co/blog/md/clickhouse-config-xml-example-explainer)
  - Learn how to configure ClickHouse® config.xml files with practical examples. From basic setup to production deployment, understand folder structure, core sections, and common problems.
  - Published: 2025-10-10 00:00:00

- [ClickHouse® deployment models 2026: managed vs self-hosted](https://www.tinybird.co/blog/md/clickhouse-deployment-options)
  - Compare ClickHouse® deployment models and choose between self-hosted or managed services to match your team's technical needs.
  - Published: 2025-10-10 00:00:00

- [How to perform case-insensitive string matching with ILIKE in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-ilike-operator)
  - Learn how to use the ILIKE operator in ClickHouse® for case-insensitive text search. Compare ILIKE vs LIKE vs match, optimize with ngram indexes, and build string matching APIs with Tinybird.
  - Published: 2025-10-10 00:00:00

- [Steps to optimize your ClickHouse® cluster for peak performance](https://www.tinybird.co/blog/md/optimize-clickhouse-cluster)
  - Optimize your ClickHouse® cluster in 9 easy steps. Boost performance up to 20× and simplify maintenance automation.
  - Published: 2025-10-10 00:00:00

- [How to stream Kafka topics to ClickHouse® in real-time](https://www.tinybird.co/blog/md/stream-kafka-to-clickhouse)
  - Stream Kafka to ClickHouse without the headaches. This guide covers setup, gotchas, and the patterns that actually work in production.
  - Published: 2025-10-10 00:00:00

- [OpenAI agent builder + Tinybird MCP: a data-driven agent workflow](https://www.tinybird.co/blog/md/openai-agent-builder-tinybird-mcp-building-a-data-driven-agent-workflow)
  - OpenAI Agent Builder plus Tinybird MCP creates data-driven agent workflows that actually scale. Here's how to build one step by step.
  - Published: 2025-10-09 10:00:00

- [Best cloud-based managed ClickHouse® services in 2026](https://www.tinybird.co/blog/md/best-cloud-managed-clickhouse)
  - Choosing the best cloud managed ClickHouse in 2026? Pricing, performance, and features vary wildly. This comparison cuts through the noise.
  - Published: 2025-10-08 23:19:22

- [OLAP databases: what's new and what's best in 2026](https://www.tinybird.co/blog/md/best-database-for-olap)
  - Choosing an OLAP database in 2026? ClickHouse, DuckDB, Druid all have tradeoffs. This comparison tells you which ones matter.
  - Published: 2025-10-08 23:19:22

- [A quick review of different ClickHouse® MCP servers](https://www.tinybird.co/blog/md/clickhouse-mcp-servers-review)
  - There's more than one ClickHouse® MCP Server. We compare popular ClickHouse® MCP server implementations including the official clickhouse-mcp, Tinybird MCP Server, and Altinity MCP.
  - Published: 2025-10-08 23:19:22

- [ClickHouse® schema migrations 2026 to prevent data loss safely](https://www.tinybird.co/blog/md/clickhouse-schema-migrations)
  - Avoid data loss with safe ClickHouse® schema migrations in production and learn how to apply changes with zero downtime.
  - Published: 2025-10-08 23:19:22

- [Fastest database for analytics in 2026 compared with benchmarks](https://www.tinybird.co/blog/md/fastest-database-for-analytics)
  - The fastest database for analytics in 2026 depends on your query patterns. These benchmarks cut through the marketing claims.
  - Published: 2025-10-08 23:19:22

- [OLTP vs OLAP: key differences, use cases, and architectures](https://www.tinybird.co/blog/md/oltp-vs-olap)
  - Understand OLTP vs OLAP differences. Learn when to use each, how they work together, and how modern data architectures combine both.
  - Published: 2025-10-08 23:19:22

- [Honest guide to the best ClickHouse® alternatives in 2026](https://www.tinybird.co/blog/md/clickhouse-alternatives)
  - ClickHouse alternatives in 2026: from managed services to embedded options. Compare features before committing to infrastructure.
  - Published: 2025-10-07 23:19:22

- [How to add and subtract time intervals in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-add-subtract-intervals)
  - Master ClickHouse® date arithmetic with addDays, subtractMonths, date_add functions plus performance tips, timezone handling, and real API examples.
  - Published: 2025-10-03 17:22:12

- [How to extract domains without www from URLs in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-extract-domain-without-www)
  - Learn how to use ClickHouse®'s domainWithoutWWW function to extract clean domains from URLs, plus advanced techniques for processing entire tables at scale.
  - Published: 2025-10-03 17:22:12

- [How to extract URL query strings without ? or # in ClickHouse®](https://www.tinybird.co/blog/md/extract-url-query-string-clickhouse)
  - Learn how to extract clean URL query strings in ClickHouse® using queryString(), cutFragment(), and other built-in functions with practical examples and performance tips.
  - Published: 2025-10-03 17:22:12

- [How to round timestamps in ClickHouse®](https://www.tinybird.co/blog/md/round-timestamps-clickhouse)
  - Learn how to round timestamps in ClickHouse® using toStartOfDay, toStartOfHour, and other built-in functions with syntax examples and performance tips.
  - Published: 2025-10-03 17:22:12

- [How to extract year, month, day, and time components from dates in ClickHouse®](https://www.tinybird.co/blog/md/extract-date-parts-clickhouse)
  - Learn how to extract year, month, day, hour, and other time components from ClickHouse® dates using toYear(), toMonth(), toHour() and more built-in functions.
  - Published: 2025-10-03 10:30:00

- [How to extract RFC-compliant hostnames from URLs in ClickHouse®](https://www.tinybird.co/blog/md/extract-rfc-hostname-clickhouse)
  - Learn how to extract RFC-compliant hostnames from URLs in ClickHouse® using domainRFC(), handle edge cases, optimize performance, and build production APIs.
  - Published: 2025-10-03 10:30:00

- [How to get the current timestamp with sub-second precision in ClickHouse®](https://www.tinybird.co/blog/md/how-to-get-current-timestamp-sub-second-clickhouse)
  - Learn how to use ClickHouse® now64() for sub-second timestamp precision, convert strings to DateTime64, and optimize high-resolution time queries for real-time apps.
  - Published: 2025-10-03 10:30:00

- [How to truncate dates in ClickHouse® with date_trunc](https://www.tinybird.co/blog/md/how-to-truncate-dates-in-clickhouse)
  - Learn how to use ClickHouse® date_trunc() function to truncate dates and timestamps to specific units like day, month, or week with practical SQL examples.
  - Published: 2025-10-03 10:30:00

- [How to strip query parameters from URLs in ClickHouse®](https://www.tinybird.co/blog/md/strip-query-parameters-clickhouse)
  - Learn how to strip query parameters from URLs in ClickHouse® using cutQueryString function with practical examples, performance tips, and production patterns.
  - Published: 2025-10-03 10:30:00

- [How to URL-encode query parameters in ClickHouse®](https://www.tinybird.co/blog/md/url-encode-query-parameters-clickhouse)
  - Learn how to safely URL-encode query parameters in ClickHouse® using encodeURLFormComponent, including syntax, examples, and performance tips for web applications.
  - Published: 2025-10-03 10:30:00

- [Compute-compute separation for faster populates](https://www.tinybird.co/blog/md/compute-compute-separation-for-faster-populates)
  - Compute separation for Populates means faster jobs and no resource fights. Large transformations finish in a fraction of the time.
  - Published: 2025-10-03 09:00:00

- [Build complete URL hierarchies with path truncation in ClickHouse®](https://www.tinybird.co/blog/md/how-to-build-url-hierarchy-clickhouse)
  - Building URL hierarchy in ClickHouse requires specific patterns. Get it wrong and queries crawl. This approach keeps them fast.
  - Published: 2025-10-02 20:50:00

- [How to update specific date parts (year month day hour) in ClickHouse®](https://www.tinybird.co/blog/md/update-date-part-clickhouse)
  - Learn how to update specific date parts in ClickHouse® using addYears, addMonths, addDays functions plus handling edge cases and scaling modifications.
  - Published: 2025-10-02 20:50:00

- [How to extract query parameter values from URLs in ClickHouse®](https://www.tinybird.co/blog/md/extract-query-parameter-clickhouse)
  - Extract query parameters in ClickHouse without regex pain. This function handles edge cases most solutions miss.
  - Published: 2025-10-02 20:45:00

- [How to extract ISO week numbers from dates in ClickHouse®](https://www.tinybird.co/blog/md/iso-week-number-clickhouse)
  - Learn how to extract ISO week numbers in ClickHouse® using toISOWeek function with syntax examples, performance tips, and edge case handling for accurate reporting.
  - Published: 2025-10-02 17:25:23

- [How to extract URL fragments without hash (#) in ClickHouse®](https://www.tinybird.co/blog/md/extract-url-fragment-clickhouse)
  - Extract URL fragments in ClickHouse without regex complexity. This function handles edge cases cleanly and runs fast.
  - Published: 2025-10-02 17:23:02

- [How to extract the protocol of a URL in ClickHouse®](https://www.tinybird.co/blog/md/extract-url-protocol-clickhouse)
  - Learn how to extract URL protocols in ClickHouse® using the protocol() function with practical examples, performance tips, and real-time API implementation.
  - Published: 2025-10-02 17:22:42

- [How to round dates in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-round-date-functions)
  - Master ClickHouse® date rounding with toStartOfYear, toStartOfMonth, toStartOfWeek and more - complete guide with syntax, examples, and API integration.
  - Published: 2025-10-02 17:22:12

- [How to extract ISO year in ClickHouse®: toISOYear vs toYear](https://www.tinybird.co/blog/md/extract-iso-year-clickhouse)
  - Learn how to extract ISO year numbers from dates in ClickHouse® using toISOYear(), including syntax examples, timezone handling, and performance tips.
  - Published: 2025-09-30 17:26:02

- [How to extract the first Significant Subdomain From URLs in ClickHouse®](https://www.tinybird.co/blog/md/how-to-extract-first-significant-subdomain-clickhouse)
  - Learn how to use ClickHouse®'s cutToFirstSignificantSubdomain function to extract core domains from URLs, with syntax examples, performance tips, and real-world use cases.
  - Published: 2025-09-30 17:25:43

- [How to get the current query timestamp with timezone in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-current-timestamp-timezone)
  - Learn how to get current timestamps with timezone support in ClickHouse® using now(), now64(), and timezone parameters for precise datetime handling.
  - Published: 2025-09-30 17:18:03

- [How to convert dates to compact numeric formats in ClickHouse®](https://www.tinybird.co/blog/md/convert-datetime-to-yyyymm-clickhouse)
  - Learn how to convert DateTime values to compact numeric formats using ClickHouse®'s toYYYYMM, toYYYYMMDD, and toYYYYMMDDhhmmss functions for faster queries and storage.
  - Published: 2025-09-30 17:17:42

- [How to convert DateTimes to a different timezone in ClickHouse®](https://www.tinybird.co/blog/md/convert-datetime-timezone-clickhouse-totimezone)
  - Learn how to convert datetime values between timezones in ClickHouse® using toTimeZone function with practical examples, best practices, and common pitfalls to avoid.
  - Published: 2025-09-30 17:17:32

- [How to extract URL paths without query strings in ClickHouse®](https://www.tinybird.co/blog/md/strip-url-query-string-clickhouse)
  - Strip URL query strings in ClickHouse with one function. Stop writing regex hacks. This approach is cleaner and faster.
  - Published: 2025-09-30 17:17:26

- [How to handle DST-aware UTC offset calculations in ClickHouse®](https://www.tinybird.co/blog/md/handle-dst-aware-utc-offset-clickhouse)
  - Learn how to calculate DST-aware UTC offsets in ClickHouse® using timeZoneOffset() function with practical examples, performance tips, and common pitfalls to avoid.
  - Published: 2025-09-30 17:17:15

- [How to extract port numbers from URLs in ClickHouse®](https://www.tinybird.co/blog/md/extract-port-from-url-clickhouse)
  - Learn how to extract port numbers from URLs in ClickHouse® using urlExtractPort() function, handle default ports for HTTP/HTTPS, and build reusable queries.
  - Published: 2025-09-30 17:17:02

- [How to get the hostname from a URL in ClickHouse®](https://www.tinybird.co/blog/md/get-hostname-from-url-clickhouse)
  - Learn how to extract hostnames from URLs in ClickHouse® using the domain() function, plus performance tips and real-world examples for web analytics.
  - Published: 2025-09-30 17:16:32

- [How to decode URL-encoded strings in ClickHouse®](https://www.tinybird.co/blog/md/how-to-decode-url-encoded-strings-in-clickhouse)
  - Learn how to decode URL-encoded strings in ClickHouse® using decodeURLComponent, with performance tips, edge cases, and production deployment strategies.
  - Published: 2025-09-30 17:16:32

- [How to convert dates to Unix timestamps in ClickHouse®](https://www.tinybird.co/blog/md/convert-date-to-unix-timestamp-clickhouse)
  - Learn how to convert dates to Unix timestamps in ClickHouse® using toUnixTimestamp() with practical examples, timezone handling, and performance tips.
  - Published: 2025-09-30 17:15:47

- [How to parse numeric date formats in ClickHouse®](https://www.tinybird.co/blog/md/parse-numeric-date-formats-clickhouse)
  - Learn how to convert numeric date formats to ClickHouse® Date/DateTime types using YYYYMMDDToDate functions for better performance and built-in date operations.
  - Published: 2025-09-30 17:15:33

- [How to retrieve the server timezone in ClickHouse®](https://www.tinybird.co/blog/md/retreive-clickhouse-server-timezone-servertimezone)
  - Learn how to retrieve ClickHouse® server timezone using SELECT timezone(), {serverTimeZone} macro, and clickhouse-client commands with practical examples.
  - Published: 2025-09-30 17:14:22

- [How to extract top-level domains from URLs in ClickHouse®](https://www.tinybird.co/blog/md/extract-top-level-domain-clickhouse)
  - Learn how to extract top-level domains from URLs using ClickHouse®'s topLevelDomain() function with practical examples and performance tips for working with domains and URLs.
  - Published: 2025-09-30 17:14:17

- [How to extract timezone information from Datetime values in ClickHouse®](https://www.tinybird.co/blog/md/extract-timezone-clickhouse-timezoneof)
  - Learn how to extract timezone information from datetime values in ClickHouse® using the timeZoneOf function with practical examples and best practices.
  - Published: 2025-09-30 17:11:03

- [Tinybird code gets smarter: reads any file, works more autonomously](https://www.tinybird.co/blog/md/what-s-new-with-tinybird-code)
  - We've been polishing our agentic CLI based on your feedback. Now you don't even need Claude Code.
  - Published: 2025-09-23 10:00:00

- [A redesigned Explorations UI: better data exploration · Tinybird](https://www.tinybird.co/blog/md/explorations-ui-revamp)
  - Stop writing SQL from scratch. Ask in plain English, get the exact query you need. Explorations just got a serious AI upgrade.
  - Published: 2025-09-19 12:00:00

- [How to compute timestamp differences with age() in ClickHouse®](https://www.tinybird.co/blog/md/clickhouse-age-function-timestamp-difference)
  - Learn how to use ClickHouse®'s age() function to calculate complete time units between timestamps, from nanoseconds to years, with syntax examples and practical queries.
  - Published: 2025-09-18 16:20:56

- [How to convert values to DateTime64(6) using timestamp() in ClickHouse®](https://www.tinybird.co/blog/md/convert-to-datetime64-with-timestamp-clickhouse)
  - Learn how to convert strings, timestamps, and date values to DateTime64(6) using ClickHouse®'s timestamp() function with microsecond precision and optional time addition.
  - Published: 2025-09-18 16:20:55

- [How to create a date from year, month, and day components in ClickHouse®](https://www.tinybird.co/blog/md/create-date-from-year-month-day-clickhouse)
  - Learn how to create dates from year, month, and day components in ClickHouse® using makeDate() function with syntax examples, validation rules, and API integration.
  - Published: 2025-09-18 16:20:55

- [How to retrieve current session timezone using timeZone() in ClickHouse®](https://www.tinybird.co/blog/md/how-to-get-session-timezone-clickhouse)
  - Learn how to retrieve your current session timezone in ClickHouse® using timezone() function, manage timezone settings, and handle UTC conversions effectively.
  - Published: 2025-09-18 16:20:55

- [How to calculate date differences using dateDiff in ClickHouse®](https://www.tinybird.co/blog/md/how-to-use-datediff-unit-boundaries-clickhouse)
  - Learn how ClickHouse® dateDiff counts unit boundaries, not elapsed time, with practical examples for cohort analysis, billing cycles, and common pitfalls to avoid.
  - Published: 2025-09-18 16:20:55

- [Why we maintain a ClickHouse® fork at Tinybird (how it's different)](https://www.tinybird.co/blog/md/why-we-maintain-a-clickhouse-fork-at-tinybird)
  - We maintain a ClickHouse fork at Tinybird. Not for ego. For performance. Here's what we changed and why it matters for you.
  - Published: 2025-09-11 08:00:00

- [Query the underlying ClickHouse® database in Tinybird via HTTP](https://www.tinybird.co/blog/md/clickhouse-http-interface-support)
  - ClickHouse HTTP interface support opens new integration patterns. Learn how to use it and when it outperforms native protocols.
  - Published: 2025-09-08 08:00:00

- [Tinybird vs ClickHouse® Cloud cost comparison explained](https://www.tinybird.co/blog/md/tinybird-vs-clickhouse-cloud-cost-comparison)
  - Tinybird vs ClickHouse Cloud cost comparison at real production scale. The pricing difference might change your architecture decision.
  - Published: 2025-08-26 10:00:00

- [How to install ClickHouse® on your own servers with Tinybird](https://www.tinybird.co/blog/md/how-to-install-clickhouse-on-your-own-servers-with-tinybird-self-managed-regions)
  - Want ClickHouse in your own cloud without the infrastructure headaches? Tinybird's self-managed regions handle the hard parts.
  - Published: 2025-08-24 10:00:00

- [Don't trust the prompt: use RLAC to secure LLM database access](https://www.tinybird.co/blog/md/rlac-for-llm-database-access)
  - RLAC for LLM database access prevents AI from querying data it shouldn't see. Secure your analytics before exposing them to agents.
  - Published: 2025-08-22 10:00:00

- [How to ingest 1 billion rows per second in ClickHouse®](https://www.tinybird.co/blog/md/1b-rows-per-second-clickhouse)
  - After seeing the engineers at Tesla talk about 1B row/s ClickHouse® ingestion, I wanted to see if I could do it myself.
  - Published: 2025-08-18 10:00:00

- [How Sync bills for real-time AI model usage with Tinybird](https://www.tinybird.co/blog/md/sync)
  - Learn how this growing AI video lip-sync startup built customer-facing usage dashboards and internal analytics to power their transition to usage-based pricing, going from proof of concept to production in less than a week.
  - Published: 2025-08-18 00:00:00

- [Web analytics starter kit, supercharged with AI and core vitals](https://www.tinybird.co/blog/md/web-analytics-with-multitenancy-and-ai)
  - Web analytics with multitenancy and AI serves thousands of customers from one platform. Here's the architecture behind it.
  - Published: 2025-08-13 14:00:00

- [How we built our own Claude Code](https://www.tinybird.co/blog/md/how-we-built-our-own-claude-code)
  - We built our own Claude Code for internal workflows. Here's why off-the-shelf AI coding tools weren't enough and what we learned.
  - Published: 2025-08-12 10:00:00

- [Tinybird is the analytics platform for Ghost 6.0](https://www.tinybird.co/blog/md/tinybird-is-the-analytics-platform-for-ghost-6-0)
  - Ghost 6.0 chose Tinybird as its analytics platform. Learn why the publishing platform trusted us with millions of pageviews.
  - Published: 2025-08-08 10:00:00

- [ClickHouse® ReplacingMergeTree examples and best use cases](https://www.tinybird.co/blog/md/ghost-analytics-agent-with-vercel-ai-sdk-and-tinybird)
  - Build a Ghost analytics agent with Vercel AI SDK and Tinybird. Give Claude real-time access to your publishing data.
  - Published: 2025-08-06 10:00:00

- [Marc Lou gets ClickHouse® performance without ClickHouse complexity using Tinybird](https://www.tinybird.co/blog/md/marc-lou)
  - Build-in-public guru Marc Lou migrated his web analytics SaaS, DataFast, from MongoDB to Tinybird, getting 150x+ faster queries and 75% lower cost without any of the operational complexity typically associated with ClickHouse.
  - Published: 2025-07-30 00:00:00

- [Multi-agent mastery: integrated analytics features with Tinybird](https://www.tinybird.co/blog/md/multi-agent-claude-code-tinybird-code)
  - Multi-agent workflows with Claude Code and Tinybird Code automate complex data tasks. Here's how to orchestrate them effectively.
  - Published: 2025-07-28 10:00:00

- [Why LLMs struggle with analytics](https://www.tinybird.co/blog/md/why-llms-struggle-with-analytics-and-how-we-fixed-that)
  - Why LLMs struggle with analytics and how we fixed that. AI can finally query data accurately. Here's the approach that works.
  - Published: 2025-07-21 10:00:00

- [Building a product feedback loop with Tinybird MCP and LLM](https://www.tinybird.co/blog/md/building-a-product-feedback-loop-with-tinybird-mcp-plain-and-one-llm-prompt)
  - Build a product feedback loop with Tinybird MCP, Plain, and one LLM prompt. Customer insights delivered automatically to your team.
  - Published: 2025-07-15 10:00:00

- [CI/CD with Tinybird Forward: automating real-time deployments](https://www.tinybird.co/blog/md/ci-cd-with-tinybird-forward-automating-real-time-data-deployments)
  - An example based on the Electric Project created in a previous post to show how to create a CI/CD workflow using Tinybird Forward.
  - Published: 2025-07-11 10:01:00

- [Turning Spain's blackout into real-time insights](https://www.tinybird.co/blog/md/tinybird-forward-turning-spain-s-blackout-into-real-time-insight)
  - How real data analytics could help to understand electric grid's work
  - Published: 2025-07-11 10:00:00

- [Local development: Redpanda Kafka + Tinybird with Docker Compose](https://www.tinybird.co/blog/md/custom-ci-for-kafka-and-tinybird)
  - Custom CI for Kafka and Tinybird pipelines prevents broken deployments. This setup catches errors before they reach production.
  - Published: 2025-07-09 10:00:00

- [10 Analytics Agents examples you can copy](https://www.tinybird.co/blog/md/10-analytics-agents-examples-you-can-copy)
  - Learn how to use Tinybird’s built-in MCP server to create LLM based analytics agents that autonomously explore and report on your data
  - Published: 2025-07-07 16:00:00

- [How to build an analytics agent with Agno and Tinybird](https://www.tinybird.co/blog/md/how-to-build-an-analytics-agent-with-agno-and-tinybird-step-by-step)
  - How to build an analytics agent with Agno and Tinybird step by step. Give AI access to your real-time data safely.
  - Published: 2025-07-02 10:00:00

- [Framer upgrades user-facing analytics to real-time with Tinybird](https://www.tinybird.co/blog/md/framer)
  - Learn how the popular no-code website builder transformed their analytics offering from basic metrics to advanced features like A/B testing and funnels, enabling new revenue streams with Tinybird's real-time analytics infrastructure.
  - Published: 2025-07-01 00:00:00

- [Why we ditched Prometheus for autoscaling (and don't miss it)](https://www.tinybird.co/blog/md/scaling-with-keda-and-tinybird)
  - Tinybird uses KEDA and its own real-time analytics platform to autoscale Kafka workloads. Learn how we made it work.
  - Published: 2025-06-27 10:00:00

- [Cut AWS costs by 20% while scaling with EKS, Karpenter, and Spot](https://www.tinybird.co/blog/md/how-we-cut-aws-costs-while-scaling-faster-with-eks-karpenter-and-spot-instances)
  - We cut AWS costs 40% while scaling faster using EKS, Karpenter, and Spot Instances. Here's exactly what we changed.
  - Published: 2025-06-27 10:00:00

- [Scaling ClickHouse® ingestion with multi-writer architecture](https://www.tinybird.co/blog/md/scaling-real-time-ingestion-with-multiple-writers)
  - Scaling real-time ingestion with multiple writers creates conflicts most architectures can't handle. This design prevents data loss.
  - Published: 2025-06-27 10:00:00

- [Protecting workloads with compute-compute separation for populates](https://www.tinybird.co/blog/md/compute-compute-separation-for-populates)
  - Populates used to fight for shared compute. Now they get dedicated resources. Your largest jobs will finish faster in 2026.
  - Published: 2025-06-27 10:00:00

- [How we made ingestion 30% faster with C++ (not Rust, sorry)](https://www.tinybird.co/blog/md/improved-rowbinary-conversion)
  - Improved RowBinary conversion speeds up ingestion significantly. Less CPU overhead, faster data loading. Here's what we optimized.
  - Published: 2025-06-27 10:00:00

- [How we automatically handle ClickHouse® schema migrations](https://www.tinybird.co/blog/md/when-not-to-migrate-your-data)
  - How we use data lineage to optimize ClickHouse® table deployments and avoid unnecessary and expensive data migrations.
  - Published: 2025-06-27 00:00:00

- [Sinks: Export your data to S3, GCS, and Kafka](https://www.tinybird.co/blog/md/sinks-in-forward)
  - Export processed data from Tinybird pipes to S3, GCS, or Kafka -- on a schedule or on demand, in any format, with full control.
  - Published: 2025-06-26 10:00:00

- [Tinybird CLI now supports Windows](https://www.tinybird.co/blog/md/tinybird-cli-now-supports-windows)
  - The Tinybird CLI now supports Windows. Windows developers can finally use local development workflows without workarounds.
  - Published: 2025-06-25 10:00:00

- [Improving the Tinybird onboarding flow: What we learned](https://www.tinybird.co/blog/md/redesigning-quickstart-in-tinybird-forward)
  - Redesigning the quickstart in Tinybird Forward gets you building faster. Less setup, more shipping. See what we simplified.
  - Published: 2025-06-25 09:59:00

- [Introducing the Tinybird OpenTelemetry Exporter](https://www.tinybird.co/blog/md/introducing-the-tinybird-opentelemetry-exporter)
  - You can now stream OTel logs, traces, and metrics directly into Tinybird data sources for standardized observability within Tinybird.
  - Published: 2025-06-24 10:00:00

- [Introducing the Tinybird MCP server: LLM-ready real-time data](https://www.tinybird.co/blog/md/introducing-the-tinybird-mcp-server-your-real-time-data-llm-ready)
  - The Tinybird MCP Server makes your real-time data LLM-ready. Connect Claude to your analytics and let AI query directly.
  - Published: 2025-06-23 10:00:00

- [Chat with your data using the Birdwatcher Slack App](https://www.tinybird.co/blog/md/birdwatcher-slack-app)
  - Birdwatcher Slack app alerts you when something breaks. Monitor your Tinybird pipelines without leaving your team's chat.
  - Published: 2025-06-23 09:01:00

- [Building an autonomous analytics agent with Agno and Tinybird](https://www.tinybird.co/blog/md/building-an-analytics-agent-with-agno-and-tinybird)
  - Building an analytics agent with Agno and Tinybird creates AI that queries your data intelligently. Here's the complete setup guide.
  - Published: 2025-06-23 09:00:00

- [MCP vs APIs: When to Use Which for AI Agent Development](https://www.tinybird.co/blog/md/mcp-vs-apis-when-to-use-which-for-ai-agent-development)
  - MCP vs APIs for AI agent development: different tools, different strengths. Here's when to use each in 2026.
  - Published: 2025-06-10 14:00:00

- [Optimizing Apache Iceberg tables for real-time analytics](https://www.tinybird.co/blog/md/optimizing-apache-iceberg-tables-for-real-time-analytics)
  - Learn how to use Iceberg's partitioning, sorting, and compaction features to build high-performance real-time analytics systems
  - Published: 2025-06-03 10:00:00

- [Can I use Supabase for analytics?](https://www.tinybird.co/blog/md/can-i-use-supabase-for-user-facing-analytics)
  - Supabase is great until you need user-facing analytics. Then it struggles. Here's what works better for that use case.
  - Published: 2025-05-26 00:00:00

- [How to build CI/CD pipelines for real-time analytics projects](https://www.tinybird.co/blog/md/ci-cd-best-practices-with-tinybird)
  - CI/CD for data pipelines fails differently than application code. These best practices prevent the mistakes we've seen repeatedly.
  - Published: 2025-05-25 00:00:00

- [Building real-time analytics with Redpanda, Iceberg, and Tinybird](https://www.tinybird.co/blog/md/building-real-time-analytical-apps-with-redpanda-iceberg-and-tinybird)
  - Building real-time analytical apps with Redpanda, Iceberg, and Tinybird creates a modern stack that scales. Complete architecture inside.
  - Published: 2025-05-23 10:00:00

- [Real-Time Analytics on Apache Iceberg with Tinybird](https://www.tinybird.co/blog/md/real-time-analytics-on-apache-iceberg-with-tinybird)
  - Learn how to build real-time analytics APIs that scale over your Iceberg tables
  - Published: 2025-05-20 10:00:00

- [IoT monitoring with Kafka and Tinybird](https://www.tinybird.co/blog/md/iot-monitoring-with-kafka-and-tinybird)
  - Millions of IoT events per second and your monitoring can't keep up. Kafka plus Tinybird fixes that. Here's the architecture.
  - Published: 2025-05-20 00:00:00

- [We graded 19 LLMs on SQL. You graded us.](https://www.tinybird.co/blog/md/we-graded-19-llms-on-sql-you-graded-us)
  - We tested 19 LLMs on SQL. The results surprised us. Then you challenged our methodology. Here's the updated truth.
  - Published: 2025-05-16 00:00:00

- [A Developer's Guide to Data Engineering](https://www.tinybird.co/blog/md/data-engineering-for-developers)
  - Developers work with code and some data, data engineers work with a lot of data and some code. We explain the main differences.
  - Published: 2025-05-15 00:00:00

- [Query Booster: How Tinybird optimizes table schemas for you](https://www.tinybird.co/blog/md/query-booster-how-tinybird-optimizes-table-schemas-for-you)
  - Query Booster optimizes table schemas automatically. Stop tuning indexes manually. Let Tinybird find the fastest configuration for you.
  - Published: 2025-05-12 00:00:00

- [Get to know your data's data -  EDA in Tinybird](https://www.tinybird.co/blog/md/eda-in-tinybird-with-explorations)
  - EDA in Tinybird with Explorations lets you investigate data interactively. Ask questions, get answers, build pipelines from insights.
  - Published: 2025-05-09 00:00:00

- [Which LLM writes the best analytical SQL?](https://www.tinybird.co/blog/md/which-llm-writes-the-best-sql)
  - Can natural language replace SQL? We benchmarked the SQL-writing ability of the top 19 LLMs to find out.
  - Published: 2025-05-08 00:00:00

- [Phantom gives crypto traders faster buy/sell decisions with Tinybird](https://www.tinybird.co/blog/md/phantom)
  - Learn how the most popular Solana wallet processes 2.5B+ daily events for 15M+ users while maintaining sub-50ms query latency.
  - Published: 2025-05-08 00:00:00

- [Building a conversational AI tool for real-time analytics](https://www.tinybird.co/blog/md/building-explorations-a-conversational-analytics-ai)
  - We just launched a conversational AI feature. Here's how we built the feature that lets you chat with your data.
  - Published: 2025-05-06 00:00:00

- [Explorations: a chat UI for real-time analytics](https://www.tinybird.co/blog/md/introducing-explorations)
  - Introducing Explorations, a conversational UI to chat with your real-time data in Tinybird.
  - Published: 2025-05-06 00:00:00

- [dbt in real-time](https://www.tinybird.co/blog/md/dbt-in-real-time)
  - dbt in real-time transforms your batch models into streaming pipelines. Same SQL, completely different performance profile.
  - Published: 2025-04-24 00:00:00

- [How Raindrop became the Sentry of AI: Scaling to petabytes with Tinybird](https://www.tinybird.co/blog/md/raindrop)
  - Learn how this AI observability platform processes hundreds of millions of requests daily to help companies understand how users interact with their AI applications, powered by Tinybird's real‑time analytics infrastructure.
  - Published: 2025-04-24 00:00:00

- [How to count 100B events: Comparing architectures](https://www.tinybird.co/blog/md/how-to-count-100b-events-comparing-architectures)
  - How to count 100 billion events: comparing architectures that handle massive scale without exploding costs. The results surprised us.
  - Published: 2025-04-21 00:00:00

- [Using LLMs to generate real-time data visualizations](https://www.tinybird.co/blog/md/using-llms-to-generate-user-defined-real-time-data-visualizations)
  - Using LLMs to generate user-defined real-time data visualizations lets users create charts by asking. Here's how to build it.
  - Published: 2025-04-17 00:00:00

- [Lessons learned from 5 years with ClickHouse® clusters: Part II](https://www.tinybird.co/blog/md/what-i-learned-operating-clickhouse-part-ii)
  - What I learned operating ClickHouse part II: more production lessons, more failures, more insights you won't find in docs.
  - Published: 2025-04-16 00:00:00

- [The simplest way to count 100B unique IDs: Part 2](https://www.tinybird.co/blog/md/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
  - Published: 2025-04-11 00:00:00

- [Build natural language filters for real-time analytics dashboards](https://www.tinybird.co/blog/md/natural-language-dashboard-filters)
  - Natural language dashboard filters let users query data by asking questions. No SQL knowledge required. AI handles the translation.
  - Published: 2025-04-10 00:00:00

- [Best practices for downsampling billions of rows of data](https://www.tinybird.co/blog/md/data-downsampling-best-practices)
  - Data downsampling can be an effective way to reduce compute resources, but it comes with tradeoffs.
  - Published: 2025-04-08 00:00:00

- [How to safely cancel a database query](https://www.tinybird.co/blog/md/how-to-safely-cancel-a-database-query)
  - How to safely cancel a database query without corrupting data or leaving resources hanging. This approach handles edge cases cleanly.
  - Published: 2025-04-07 00:00:00

- [How Inbox Zero uses Tinybird for real-time analytics](https://www.tinybird.co/blog/md/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. 
  - Published: 2025-04-04 00:00:00

- [We made an open source LLM Performance Tracker](https://www.tinybird.co/blog/md/introducing-llm-performance-tracker)
  - The LLM Performance Tracker monitors latency, tokens, and costs across all your AI calls. Stop guessing what your models are doing.
  - Published: 2025-04-03 00:00:00

- [Hype vs. reality: 5 AI features that work in production](https://www.tinybird.co/blog/md/ai-features-that-work)
  - 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.
  - Published: 2025-04-02 00:00:00

- [I've operated petabyte-scale ClickHouse® clusters for 5 years](https://www.tinybird.co/blog/md/what-i-learned-operating-clickhouse)
  - What I learned operating ClickHouse at scale: the wins, the failures, and the lessons that only come from production experience.
  - Published: 2025-04-01 00:00:00

- [Real-time inventory management with lambda architecture](https://www.tinybird.co/blog/md/real-time-inventory-management-with-lambda-architecture)
  - Real-time inventory management with Lambda architecture balances speed and accuracy. Here's how to track stock without overselling.
  - Published: 2025-03-28 00:00:00

- [Instrument your LLM calls to analyze AI costs and usage](https://www.tinybird.co/blog/md/instrument-your-llm-calls)
  - Instrument your LLM calls or fly blind on costs and latency. This observability setup shows exactly what your AI is doing.
  - Published: 2025-03-27 00:00:00

- [Vibe code tools, not toys.](https://www.tinybird.co/blog/md/vibe-code-tools-not-toys)
  - How I vibe coded an internal anomaly detection system that had previously taken me months to build and deploy.
  - Published: 2025-03-26 00:00:00

- [The simplest way to count 100 billion unique IDs: Part 1](https://www.tinybird.co/blog/md/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.
  - Published: 2025-03-25 00:00:00

- [Run Tinybird on your own infrastructure](https://www.tinybird.co/blog/md/tb-infra)
  - You can now run Tinybird on your own infrastructure, for free, with Tinybird Self-Managed.
  - Published: 2025-03-24 00:00:00

- [Less ceremony, more shipping](https://www.tinybird.co/blog/md/tb-deploy)
  - Deployments in data finally get their due. With tb deploy, live schema migrations happen painlessly and automatically.
  - Published: 2025-03-21 00:00:00

- [Writing tests sucks. Use LLMs so it sucks less.](https://www.tinybird.co/blog/md/tb-test)
  - tb test validates your Tinybird pipelines before deployment. Catch errors locally instead of discovering them in production.
  - Published: 2025-03-20 00:00:00

- [Build fast software with big data requirements](https://www.tinybird.co/blog/md/tb-dev)
  - Somehow we got stuck on the idea that big data systems should be slow. We're making it fast.
  - Published: 2025-03-19 00:00:00

- [Clearwater Dynamics uses Tinybird to power its maritime insurtech solution](https://www.tinybird.co/blog/md/clearwater-dynamics)
  - Learn how Clearwater Dynamics uses Tinybird to power analytics for over 200 million vessel position reports daily.
  - Published: 2025-03-19 00:00:00

- [Local first.](https://www.tinybird.co/blog/md/local-first-experience)
  - Run Tinybird on your machine. Deploy your data project locally or to the cloud in the exact same way, as it should be.
  - Published: 2025-03-17 00:00:00

- [Vibe data engineering](https://www.tinybird.co/blog/md/tb-create)
  - You're probably sick of hearing people talk about "vibe coding", but what about "vibe data engineering?" ;)
  - Published: 2025-03-17 00:00:00

- [Forward: Evolving Tinybird for the AI-native developer](https://www.tinybird.co/blog/md/announcing-tinybird-forward)
  - Announcing Tinybird Forward: the next evolution of how you build with real-time data. Everything changes from here.
  - Published: 2025-03-14 00:00:00

- [How to run load tests in real-time data systems](https://www.tinybird.co/blog/md/how-to-run-load-tests-in-real-time-data-systems)
  - Load tests on real-time data systems fail differently than traditional apps. Here's how to run them without breaking production.
  - Published: 2025-03-07 00:00:00

- [We added the Backup Database engine to ClickHouse®](https://www.tinybird.co/blog/md/new-clickhouse-backup-engine)
  - We added a new ClickHouse® engine: Backup. Here's why we did it, how it's implemented, and example usage.
  - Published: 2025-03-03 00:00:00

- [Outgrowing Postgres: optimize and integrate OLTP + OLAP stack](https://www.tinybird.co/blog/md/outgrowing-postgres-how-to-optimize-and-integrate-an-oltp-olap-stack)
  - Postgres handles transactions fine but chokes on analytics at scale. Here's how to optimize it and when to add OLAP.
  - Published: 2025-02-27 00:00:00

- [Build a Datadog alternative in 5 minutes](https://www.tinybird.co/blog/md/build-a-datadog-alternative-in-5-minutes)
  - Build a Datadog alternative in 5 minutes. Seriously. This tutorial shows how to create observability dashboards from scratch.
  - Published: 2025-02-26 00:00:00

- [You built a Datadog alternative. Now scale it.](https://www.tinybird.co/blog/md/build-a-datadog-alternative-in-5-minutes-part-2)
  - Build a Datadog alternative part 2: add alerts, dashboards, and retention policies. Complete your observability stack today.
  - Published: 2025-02-26 00:00:00

- [The perfect data ingestion API design](https://www.tinybird.co/blog/md/the-perfect-data-ingestion-api-design)
  - If you ask me, this is pretty much perfect.
  - Published: 2025-02-21 00:00:00

- [I've helped huge companies scale logs analysis. Here’s how.](https://www.tinybird.co/blog/md/real-time-logs-analytics-architectures)
  - Real-time logs analytics architectures range from simple to complex. Choose the wrong one and you'll rebuild it later. Choose wisely.
  - Published: 2025-02-19 00:00:00

- [Outgrowing Postgres: how to evaluate the right OLAP solution](https://www.tinybird.co/blog/md/outgrowing-postgres-how-to-evaluate-the-right-olap-solution-for-analytics)
  - Outgrowing Postgres for analytics? Evaluating the right OLAP solution requires understanding your query patterns. Start here.
  - Published: 2025-02-17 00:00:00

- [Build a data-intensive Next.js app with Tinybird and Cursor](https://www.tinybird.co/blog/md/data-intensive-nextjs-app-tinybird-cursor)
  - Build a data-intensive Next.js app with Tinybird and Cursor. Ship analytics features faster than your backend team expected.
  - Published: 2025-02-13 00:00:00

- [Ship data as you ship code: deploy changes with one command](https://www.tinybird.co/blog/md/tinybird-forward)
  - We've redesigned the Tinybird CLI, codename "FORWARD". You can now test it in beta.
  - Published: 2025-02-13 00:00:00

- [Outgrowing Postgres: When to move OLAP workloads off Postgres](https://www.tinybird.co/blog/md/outgrowing-postgres-when-to-move-olap-workloads-off-postgres)
  - Learn when to move analytics off Postgres by watching for technical and team health warning signs before crisis hits.
  - Published: 2025-02-07 00:00:00

- [Ship data as you ship code: Tinybird becomes local-first](https://www.tinybird.co/blog/md/tinybird-is-local-first)
  - Tinybird is local-first. Develop on your machine, test locally, deploy when ready. No cloud dependency during development.
  - Published: 2025-02-05 00:00:00

- [Why we created new pricing for Developer plans](https://www.tinybird.co/blog/md/why-we-created-new-pricing-for-developer-plans)
  - We created new pricing for developer plans because the old model didn't fit how developers actually build. Here's what changed.
  - Published: 2025-02-04 00:00:00

- [Outgrowing Postgres: How to run OLAP workloads on Postgres](https://www.tinybird.co/blog/md/outgrowing-postgres-how-to-run-olap-workloads-on-postgres)
  - A deep dive into running analytics on Postgres, from basic optimizations to advanced techniques and knowing when to quit.
  - Published: 2025-01-31 00:00:00

- [Analyzing the Dub.co analytics playbook](https://www.tinybird.co/blog/md/analyzing-dub-co-saas-analytics)
  - Dub is an archetype of the successful modern SaaS. Learn from their success and model their approach to analytics.
  - Published: 2025-01-29 00:00:00

- [A guide to Tinybird's new pricing model](https://www.tinybird.co/blog/md/new-pricing-model-jan-2025)
  - New pricing model January 2026: simpler, more predictable, better for teams scaling fast. Here's what changed and why.
  - Published: 2025-01-29 00:00:00

- [Resend delivers email metrics to builders with Tinybird](https://www.tinybird.co/blog/md/resend)
  - Learn how Resend processes terabytes of email event logs while maintaining 62ms average query latency for its Marketing Analytics dashboards.
  - Published: 2025-01-29 00:00:00

- [Outgrowing Postgres: Handling increased user concurrency](https://www.tinybird.co/blog/md/outgrowing-postgres-handling-increased-user-concurrency)
  - When your application grows, so too do your database connections. Learn how to handle increased user concurrency on Postgres.
  - Published: 2025-01-24 00:00:00

- [Logging 150M+ link clicks: how Dub built webhook event logs](https://www.tinybird.co/blog/md/dub-webhooks-event-logs)
  - Dub webhooks event logs show exactly what happened and when. Debug integrations faster with complete event visibility.
  - Published: 2025-01-23 00:00:00

- [Tinybird Local: Build with data on your machine](https://www.tinybird.co/blog/md/tinybird-local-docker-container)
  - You can now build and test your data projects locally using the Tinybird Local Docker container.
  - Published: 2025-01-21 00:00:00

- [Building a Resend analytics dashboard](https://www.tinybird.co/blog/md/building-a-resend-analytics-dashboard)
  - Sending emails is painful. Knowing if they actually work? Worse. Here's how to track every bounce, open, and delivery in real time.
  - Published: 2025-01-20 00:00:00

- [Outgrowing Postgres: Handling growing data volumes](https://www.tinybird.co/blog/md/outgrowinghandling-growing-data-volumes)
  - Postgres slowing down at terabyte scale? Before you migrate, try these optimization techniques. And know when it's time to move on.
  - Published: 2025-01-17 00:00:00

- [I rebuilt the Auth0 Activity Page with webhooks and Tinybird](https://www.tinybird.co/blog/md/auth0-webhooks-tinybird-integration)
  - If you know, you grow. I rebuilt the Auth0 activity page with added features so I can learn more about my user growth.
  - Published: 2025-01-16 00:00:00

- [Measure deployment velocity with Vercel and Tinybird](https://www.tinybird.co/blog/md/vercel-webhooks-and-tinybird-integration)
  - Learn how to use Vercel webhooks, Tinybird, and Next.js to build a simple app that tracks your deployment velocity.
  - Published: 2025-01-13 00:00:00

- [Outgrowing Postgres: How to identify scale problems](https://www.tinybird.co/blog/md/outgrowing-postgres-how-to-identify-scale-problems)
  - Is Postgres slowing down or are you just imagining it? Here are the early warning signs and what to do before it becomes a crisis.
  - Published: 2025-01-10 00:00:00

- [Open observability in Tinybird with Prometheus endpoints](https://www.tinybird.co/blog/md/tinybird-prometheus-endpoint-format)
  - Tinybird now supports Prometheus endpoint format. Export metrics directly to your existing monitoring stack. No adapters needed.
  - Published: 2024-12-20 00:00:00

- [How to analyze usage from your MCP Server](https://www.tinybird.co/blog/md/analyze-mcp-server-usage)
  - Built an MCP Server for Claude? Now monitor it properly. Track errors, analyze usage, and debug issues with Tinybird and Grafana.
  - Published: 2024-12-09 00:00:00

- [Building an Insights page for your SaaS: from idea to production](https://www.tinybird.co/blog/md/building-an-insights-page-for-your-saas)
  - Building an insights page for your SaaS increases retention. Here's how to add analytics your users will actually check daily.
  - Published: 2024-12-05 00:00:00

- [Building Real-Time Live Sports Viewer Analytics with Tinybird and AWS](https://www.tinybird.co/blog/md/building-real-time-live-sports-viewer-analytics-with-tinybird-and-aws)
  - Showing real-time stats to millions of viewers without crashing? It's possible. Here's the architecture that won't drain your budget.
  - Published: 2024-12-03 00:00:00

- [Hey Claude, help me analyze Bluesky data.](https://www.tinybird.co/blog/md/claude-analyze-bluesky-data-tinybird-mcp-server)
  - Claude can analyze Bluesky data with the Tinybird MCP Server. Connect your social data and let AI find the insights.
  - Published: 2024-11-27 00:00:00

- [Zembula fast-tracks its roadmap with Tinybird](https://www.tinybird.co/blog/md/zembula)
  - Learn how a rising email personalization platform used Tinybird to answer previously unanswerable questions about real‑time attribution for their retail customers.
  - Published: 2024-11-20 00:00:00

- [Application Architecture: Combining DynamoDB and Tinybird](https://www.tinybird.co/blog/md/application-architecture-combining-dynamodb-and-tinybird)
  - DynamoDB is fast for transactions but slow for analytics. Here's how to combine it with Tinybird and get the best of both worlds.
  - Published: 2024-11-06 00:00:00

- [Query DynamoDB tables with SQL](https://www.tinybird.co/blog/md/query-dynamodb-with-sql)
  - Query DynamoDB with SQL instead of fighting with PartiQL. Tinybird makes your NoSQL data accessible to anyone who knows SQL.
  - Published: 2024-10-30 00:00:00

- [The Tinybird DynamoDB Connector is now GA](https://www.tinybird.co/blog/md/dynamodb-connector-ga)
  - The DynamoDB Connector is now production-ready. Sub-second queries across partitions, unlimited indexing. No more workarounds.
  - Published: 2024-10-28 00:00:00

- [Simple patterns for aggregating on DynamoDB](https://www.tinybird.co/blog/md/dynamodb-aggregation)
  - DynamoDB doesn't natively support aggregations, so here are four different approaches to aggregate data in DynamoDB tables.

  - Published: 2024-10-15 00:00:00

- [Plain builds real‑time customer support insights with Tinybird](https://www.tinybird.co/blog/md/plain)
  - Read how the fastest, most powerful support platform for technical B2B teams uses Tinybird to permeate its product with data‑driven features that help customers identify support trends in real time.
  - Published: 2024-10-07 00:00:00

- [From CDC to real-time analytics with Tinybird and Estuary](https://www.tinybird.co/blog/md/cdc-real-time-analytics-estuary-dekaf)
  - With Estuary's release of Dekaf, you can now integrate with hundreds of CDC data sources using Tinybird's Kafka Connector.
  - Published: 2024-09-24 00:00:00

- [Introducing the Tinybird DynamoDB Connector in public beta](https://www.tinybird.co/blog/md/dynamodb-public-beta)
  - The DynamoDB Connector just hit public beta. Cross-partition queries in milliseconds are now possible. Test it yourself.
  - Published: 2024-09-20 00:00:00

- [Top Use Cases for DynamoDB in 2024](https://www.tinybird.co/blog/md/dynamodb-use-cases)
  - DynamoDB use cases where it excels and where it struggles. Pick the right tool before you're stuck migrating later.
  - Published: 2024-09-18 00:00:00

- [How to build real-time analytics on AWS with DynamoDB](https://www.tinybird.co/blog/md/dynamodb-real-time-analytics)
  - DynamoDB isn’t built for analytics, but AWS tools make it possible. Learn three proven ways to build real-time analytics on AWS with DynamoDB.
  - Published: 2024-09-11 00:00:00

- [Tinybird is now HIPAA compliant](https://www.tinybird.co/blog/md/tinybird-hipaa-compliant)
  - Tinybird is now HIPAA compliant. Healthcare teams can build real-time analytics on protected data with confidence. Details inside.
  - Published: 2024-09-03 00:00:00

- [Best managed ClickHouse® services compared in 2026](https://www.tinybird.co/blog/md/managed-clickhouse-options)
  - Managed ClickHouse options in 2026 range from basic hosting to full platforms. This comparison shows what you actually get.
  - Published: 2024-08-20 00:00:00

- [Tinybird vs. ClickHouse®: What's the difference?](https://www.tinybird.co/blog/md/tinybird-vs-clickhouse)
  - Tinybird vs ClickHouse: same engine, different experience. One requires infrastructure expertise. The other lets you ship today.
  - Published: 2024-08-13 00:00:00

- [Import Postgres tables into Tinybird with PostgreSQL Table Function](https://www.tinybird.co/blog/md/postgresql-table-function-announcement)
  - The PostgreSQL table function connects your Postgres data to Tinybird directly. Query across systems without complex ETL pipelines.
  - Published: 2024-07-29 00:00:00

- [Blacksmith builds faster CI analytics with Tinybird](https://www.tinybird.co/blog/md/blacksmith)
  - Learn how a fast-moving startup is shaking up the world of Continuous Integration by offering 2x faster GitHub Actions at less than half the cost, with user‑facing CI analytics powered by Tinybird.
  - Published: 2024-07-24 00:00:00

- [Behind the scenes of Tinybird's big frontend refactor](https://www.tinybird.co/blog/md/tinybird-frontend-refactor)
  - We refactored the Tinybird frontend completely. Faster loads, better UX, cleaner code. Here's why we rebuilt instead of patched.
  - Published: 2024-07-19 00:00:00

- [Best practices for timestamps and time zones in databases](https://www.tinybird.co/blog/md/database-timestamps-timezones)
  - Confused about how to handle dates, times, and DateTimes in your database? We’ve got you covered, now() and always.
  - Published: 2024-07-16 00:00:00

- [Introducing Rate Limiting for Tinybird APIs](https://www.tinybird.co/blog/md/rate-limiting-announcement)
  - Rate limiting protects your APIs from abuse and runaway costs. Native support is here. Configure limits in minutes.
  - Published: 2024-07-10 00:00:00

- [Multi-tenant analytics for SaaS applications](https://www.tinybird.co/blog/md/multi-tenant-saas-options)
  - Multi-tenant SaaS options for analytics vary wildly in cost and complexity. This guide helps you pick the right architecture in 2026.
  - Published: 2024-07-03 00:00:00

- [Migrating from Rockset? See how Tinybird features compare](https://www.tinybird.co/blog/md/migrating-from-rockset-feature-comparison)
  - Rockset is gone. If you're stuck choosing a replacement, this feature comparison shows exactly where Tinybird fits.
  - Published: 2024-06-25 00:00:00

- [Audiense evolves its social media timeline with Tinybird](https://www.tinybird.co/blog/md/audiense)
  - Learn how a leader in social audience intelligence leveraged Tinybird to unlock the incredible value in the data it had collected from over 1.5 billion X users.
  - Published: 2024-06-25 00:00:00

- [Dub shortens time to market for user-facing analytics with Tinybird](https://www.tinybird.co/blog/md/dub)
  - Learn how a fast-rising short link platform builds fast user-facing analytics dashboards and tracks its usage-based billing with Tinybird's end-to-end operational analytics platform.
  - Published: 2024-06-25 00:00:00

- [Genially uses Tinybird to display realtime content interaction metrics for their customers](https://www.tinybird.co/blog/md/genially-uses-tinybird-to-display-realtime-metrics)
  - Learn how the visual content platform replaced Google Analytics, Postgres, and MongoDB with Tinybird to deliver instant content performance insights to 20M+ users.
  - Published: 2024-06-25 00:00:00

- [LocalStack scales product analytics with Tinybird](https://www.tinybird.co/blog/md/localstack-relies-on-tinybird-to-understand-and-improve-their-product)
  - Learn how the cloud emulation platform migrated from MySQL to Tinybird to support real-time analytics for 10,000+ developers and 100,000+ instances.
  - Published: 2024-06-25 00:00:00

- [Situm relies on Tinybird to accelerate the speed of data processing and querying at scale](https://www.tinybird.co/blog/md/situm-accelerates-data-processing-and-querying-with-tinybird)
  - Learn how the indoor positioning platform reduced engineering hours by 10x while processing 300 million geolocations daily with millisecond latency.
  - Published: 2024-06-25 00:00:00

- [Smartme Analytics builds complete consumer insights with Tinybird](https://www.tinybird.co/blog/md/smartme-analytics)
  - Read how the leading consumer behavior platform builds comprehensive Consumer 360 software with real‑time, zero‑party data and analytics powered by Tinybird.
  - Published: 2024-06-25 00:00:00

- [The Hotels Network relies on Tinybird to help customers turn lookers into bookers](https://www.tinybird.co/blog/md/the-hotels-network-realtime-analytics-with-tinybird)
  - The Hotels Network processes several petabytes through Tinybird each month, delivering personalized, realtime booking experiences to prospective hotel clients.
  - Published: 2024-06-25 00:00:00

- [Jobs log: Improved o11y for background jobs](https://www.tinybird.co/blog/md/jobs-log-launch)
  - Now it’s easier than ever to build production-level observability of your Tinybird data.
  - Published: 2024-06-20 00:00:00

- [Canva designs brilliant user experiences with Tinybird](https://www.tinybird.co/blog/md/canva)
  - Discover how the world's most-loved online design platform builds user-facing analytics 10x cheaper and 5x faster with Tinybird.
  - Published: 2024-06-20 00:00:00

- [Factorial builds real‑time data products with Tinybird](https://www.tinybird.co/blog/md/factorial-builds-real-time-data-products-with-tinybird)
  - Factorial turned to Tinybird to build 12 new user‑facing analytics features in just a few months.
  - Published: 2024-06-20 00:00:00

- [FanDuel scores big with real‑time insights via Tinybird](https://www.tinybird.co/blog/md/fanduel)
  - Discover how the US's largest online sportsbook leveraged Tinybird for real‑time data analytics.
  - Published: 2024-06-20 00:00:00

- [Vercel uses Tinybird to help developers ship code faster](https://www.tinybird.co/blog/md/vercel-relies-on-tinybird-to-power-their-realtime-user-facing-analytics)
  - Vercel's customers see usage metrics for their applications in realtime, so they can accelerate releases that boost their user experience.
  - Published: 2024-06-20 00:00:00

- [$30M to lead the shift to real-time data](https://www.tinybird.co/blog/md/announcing-tinybird-series-b)
  - We’ve raised a $30M Series B from Balderton Capital to build the real-time data platform that developers and data teams love.
  - Published: 2024-06-17 00:00:00

- [Announcing Tinybird Charts: Fast Real-Time Charts, Even Faster](https://www.tinybird.co/blog/md/announcing-tinybird-charts)
  - Tinybird Charts turns your APIs into visualizations instantly. No frontend code required. See your data in seconds.
  - Published: 2024-06-12 00:00:00

- [Tinybird is now available in AWS us-west-2](https://www.tinybird.co/blog/md/tinybird-is-now-available-in-aws-us-west-2)
  - Tinybird is now available in AWS US-West-2. West coast teams get lower latency. Deploy in your region starting today.
  - Published: 2024-06-10 00:00:00

- [Building real-time leaderboards with Tinybird](https://www.tinybird.co/blog/md/building-real-time-leaderboards-with-tinybird)
  - Build real-time leaderboards using Tinybird. Engage users with live data and real-time analytics that update in milliseconds.
  - Published: 2024-06-06 00:00:00

- [Tinybird has joined the AWS ISV Accelerate Program](https://www.tinybird.co/blog/md/tinybird-joins-aws-isv-accelerate)
  - Tinybird joins AWS ISV Accelerate. Enterprise customers get better pricing and faster procurement through AWS Marketplace.
  - Published: 2024-06-05 00:00:00

- [JWTs for API Endpoints now in public beta!](https://www.tinybird.co/blog/md/jwt-api-endpoints-public-beta)
  - JWT API endpoints hit public beta. Secure your Tinybird APIs with token-based authentication. Setup takes minutes.
  - Published: 2024-06-03 00:00:00

- [ClickHouse® JOINs... 100x faster](https://www.tinybird.co/blog/md/clickhouse-joins-improvements)
  - We recently introduced two pull requests to ClickHouse® that significantly improve JOIN performance in common scenarios.
  - Published: 2024-04-30 00:00:00

- [User-Facing Analytics: Examples, Use Cases, and Resources](https://www.tinybird.co/blog/md/user-facing-analytics)
  - User-facing analytics separates good products from great ones. Most teams build them wrong. This guide shows what actually works.
  - Published: 2024-04-23 00:00:00

- [We rebuilt our docs from scratch. It was worth it.](https://www.tinybird.co/blog/md/new-docs)
  - New docs make finding answers faster. Rebuilt from scratch with better search, clearer examples, and real-world tutorials.
  - Published: 2024-04-15 00:00:00

- [Real-time anomaly detection: algorithms, use cases & SQL code](https://www.tinybird.co/blog/md/real-time-anomaly-detection)
  - Learn how to build real-time anomaly detection systems. Explore SQL algorithms, examples, and use cases to detect outliers instantly.
  - Published: 2024-04-01 00:00:00

- [Best database for real time analytics in 2026 and how to choose](https://www.tinybird.co/blog/md/best-database-for-real-time-analytics)
  - The best database for real-time analytics in 2026 depends on your workload. This comparison covers the options that actually matter.
  - Published: 2024-03-26 00:00:00

- [Export data from Tinybird to Amazon S3 with the S3 Sink](https://www.tinybird.co/blog/md/s3-sink-launch)
  - Today, we release the S3 Sink. Now, you can export data from Tinybird to Amazon S3 without any external processes or additional code.
  - Published: 2024-03-21 00:00:00

- [Iterating terabyte-sized ClickHouse® tables in production](https://www.tinybird.co/blog/md/clickhouse-schema-migration-while-streaming)
  - Schema migrations on a streaming ClickHouse table? At 100s of MB/s? Here's how we do it across clusters without losing a single bit.
  - Published: 2024-03-11 00:00:00

- [How to scale a real-time data platform](https://www.tinybird.co/blog/md/how-tinybird-scales)
  - How Tinybird scales to handle billions of events without breaking. The infrastructure decisions that keep queries fast under load.
  - Published: 2024-02-16 00:00:00

- [8 example projects to master real-time data engineering](https://www.tinybird.co/blog/md/real-time-data-engineering-example-projects)
  - Looking to hone your real-time data engineering skills? Here are 8 end-to-end projects (with code) to help you learn and advance.
  - Published: 2023-12-11 00:00:00

- [Tinybird expands self-service real-time analytics to AWS](https://www.tinybird.co/blog/md/tinybird-expands-self-service-to-amazon-web-services)
  - Tinybird on AWS is now fully self-service. No sales calls, no waiting. Pick your region and start building in minutes.
  - Published: 2023-11-28 00:00:00

- [Using Tinybird for real-time marketing at Tinybird](https://www.tinybird.co/blog/md/tinybird-for-real-time-marketing)
  - Here's how we use Tinybird to drive the growth of Tinybird. 
  - Published: 2023-11-14 00:00:00

- [Build a real-time dashboard in Python with Tinybird and Dash](https://www.tinybird.co/blog/md/python-real-time-dashboard)
  - Want to build a real-time dashboard with Python? Here's a step-by-step guide with included code that shows you how.
  - Published: 2023-11-06 00:00:00

- [What are columnar databases? Here are 35 examples.](https://www.tinybird.co/blog/md/what-is-a-columnar-database)
  - What is a columnar database and why does it matter? Understanding the architecture explains why analytical queries run 100x faster.
  - Published: 2023-11-03 00:00:00

- [7 tips to make your dashboards faster](https://www.tinybird.co/blog/md/7-tips-to-make-your-dashboards-faster)
  - Want to speed up your data visualizations? Here are seven tried and true tips to improve dashboard performance.
  - Published: 2023-10-31 00:00:00

- [Resolving a year-long ClickHouse® lock contention](https://www.tinybird.co/blog/md/clickhouse-lock-contention)
  - Here's how we fixed a problem that had stumped us for over a year and saw a 5x performance improvement in the process.
  - Published: 2023-10-30 00:00:00

- [Automating data workflows with plaintext files and Git](https://www.tinybird.co/blog/md/automating-data-workflows-with-git)
  - Automating data workflows with Git brings version control to pipelines. Track changes, review PRs, and deploy with confidence.
  - Published: 2023-10-23 00:00:00

- [Build a real-time dashboard over BigQuery](https://www.tinybird.co/blog/md/bigquery-real-time-dashboard)
  - BigQuery real-time dashboard sounds impossible. It's not. Here's how to add sub-second updates to your warehouse data.
  - Published: 2023-10-20 00:00:00

- [We have released a stable version of the Tinybird CLI](https://www.tinybird.co/blog/md/stable-cli-v-1-0-0)
  - Introducing the Tinybird CLI v1.0.0, our first stable release.
  - Published: 2023-10-19 00:00:00

- [Real-time dashboards: are they worth it? Find out here](https://www.tinybird.co/blog/md/real-time-dashboards-are-they-worth-it)
  - Are real-time dashboards still relevant? Learn their benefits, when to use them, and how they help make faster, data-driven decisions.
  - Published: 2023-10-13 00:00:00

- [How to query Google Sheets with SQL in real time](https://www.tinybird.co/blog/md/query-google-sheets-with-sql-in-real-time)
  - Want to access real-time data from Google Sheets? Follow this tutorial to query your Google Sheets data with a real-time SQL engine.
  - Published: 2023-10-11 00:00:00

- [Event sourcing with Kafka: A practical example](https://www.tinybird.co/blog/md/event-sourcing-with-kafka)
  - Event sourcing with Kafka creates an immutable history of everything. Here's how to implement it without the usual complexity.
  - Published: 2023-09-27 00:00:00

- [Iterate your real-time data pipelines with Git](https://www.tinybird.co/blog/md/git-for-real-time-data-projects)
  - Git workflows for real-time data projects are tricky. Version control that actually works for streaming pipelines exists. Here's how.
  - Published: 2023-09-20 00:00:00

- [Why iterating real-time data pipelines is so hard](https://www.tinybird.co/blog/md/why-iterating-real-time-data-pipelines-is-hard)
  - "Why can't we just use Git?"
  - Published: 2023-09-19 00:00:00

- [How to do real-time data processing for modern analytics 2026](https://www.tinybird.co/blog/md/real-time-data-processing)
  - Discover what real-time data processing is, how it works, and which tools you need to analyze and act on data instantly.
  - Published: 2023-09-07 00:00:00

- [A step-by-step guide to build a real-time dashboard](https://www.tinybird.co/blog/md/real-time-dashboard-step-by-step)
  - Build a real-time dashboard step by step. No fluff, no theory. Just working code and architecture decisions explained clearly.
  - Published: 2023-09-05 00:00:00

- [Real-time Personalization: Choosing the right tools](https://www.tinybird.co/blog/md/real-time-personalization)
  - Real-time personalization drives conversions but most implementations lag. Here's how to deliver personalized experiences instantly.
  - Published: 2023-08-25 00:00:00

- [A practical guide to real-time CDC with MySQL](https://www.tinybird.co/blog/md/mysql-cdc)
  - A step-by-step guide to setting up Change Data Capture (CDC) with MySQL, Confluent Cloud, and Tinybird.
  - Published: 2023-08-23 00:00:00

- [Real-time data ingestion: instant analytics](https://www.tinybird.co/blog/md/real-time-data-ingestion)
  - Real-time data ingestion at scale requires specific patterns. Get this wrong and you'll lose data under load. Here's what works.
  - Published: 2023-08-18 00:00:00

- [A practical guide to real-time CDC with Postgres](https://www.tinybird.co/blog/md/postgres-cdc)
  - A step-by-step guide to setting up Change Data Capture (CDC) with PostgreSQL, Confluent Cloud, and Tinybird.
  - Published: 2023-08-17 00:00:00

- [A practical guide to real-time CDC with MongoDB](https://www.tinybird.co/blog/md/mongodb-cdc)
  - A step-by-step guide to setting up Change Data Capture (CDC) with MongoDB Atlas, Confluent Cloud, and Tinybird.
  - Published: 2023-08-15 00:00:00

- [Killing the ProcessPoolExecutor](https://www.tinybird.co/blog/md/killing-the-processpoolexecutor)
  - A story about the Python GIL, threading, and fixing code that already works.
  - Published: 2023-08-09 00:00:00

- [Modern data management with real time Change Data Capture](https://www.tinybird.co/blog/md/real-time-change-data-capture)
  - Real-time change data capture streams database changes as they happen. Build CDC pipelines that keep systems in sync instantly.
  - Published: 2023-08-08 00:00:00

- [Real-time Data Visualization: How to build faster dashboards](https://www.tinybird.co/blog/md/real-time-data-visualization)
  - Real-time data visualization turns raw streams into instant insights. Most tools add too much latency. Here's how to keep it fast.
  - Published: 2023-08-08 00:00:00

- [Tinybird: A ksqlDB alternative for stateful stream processing](https://www.tinybird.co/blog/md/ksqldb-alternative)
  - Looking for a ksqlDB alternative? Tinybird gives you streaming SQL without the Kafka Streams complexity. Compare the approaches.
  - Published: 2023-07-27 00:00:00

- [Real-time data platforms explained: components & benefits](https://www.tinybird.co/blog/md/real-time-data-platforms)
  - Real-time data platforms process streams as they arrive. Understanding the architecture helps you pick the right one for your needs.
  - Published: 2023-07-27 00:00:00

- [What it takes to build a real-time recommendation system](https://www.tinybird.co/blog/md/real-time-recommendation-system)
  - Real-time recommendation systems drive revenue but most are too slow. Here's how to serve personalized suggestions in under 100ms.
  - Published: 2023-07-25 00:00:00

- [Real-time streaming data architectures: how to build & scale](https://www.tinybird.co/blog/md/real-time-streaming-data-architectures-that-scale)
  - Real-time streaming data architectures that scale handle growth without redesigns. These patterns prevent the rewrites you're dreading.
  - Published: 2023-07-21 00:00:00

- [Run analytics on Amazon S3 data with Tinybird S3 connector](https://www.tinybird.co/blog/md/s3-analytics-the-easy-way-tinybird-connector)
  - S3 analytics the easy way with the Tinybird Connector. Query your data lake files without complex ETL pipelines.
  - Published: 2023-07-20 00:00:00

- [Tinybird connects with Confluent for real-time analytics at scale](https://www.tinybird.co/blog/md/tinybird-connect-with-confluent)
  - Tinybird now connects with Confluent directly. Stream your Kafka data and build real-time APIs without custom integration code.
  - Published: 2023-07-18 00:00:00

- [16 questions to ask about your real-time data strategy](https://www.tinybird.co/blog/md/16-questions-real-time-data-strategy)
  - 16 questions for your real-time data strategy reveal gaps before they become problems. Answer these before your next architecture review.
  - Published: 2023-07-13 00:00:00

- [Data-driven CI pipeline monitoring with pytest](https://www.tinybird.co/blog/md/data-driven-ci-pipeline-monitoring-with-pytest)
  - Data-driven CI pipeline monitoring with pytest catches failures traditional tests miss. Add observability to your test suite today.
  - Published: 2023-07-07 00:00:00

- [Set up event-based S3 file ingestion with AWS Lambda for free](https://www.tinybird.co/blog/md/how-to-set-up-event-based-ingestion-of-files-in-s3-for-free)
  - Set up event-based ingestion of S3 files for free. No Lambda costs, no polling. This architecture triggers on new file arrivals.
  - Published: 2023-06-30 00:00:00

- [Event-driven architecture best practices for databases and files](https://www.tinybird.co/blog/md/event-driven-architecture-best-practices-for-databases-and-files)
  - Your event-driven architecture is only as good as your database can handle. These patterns prevent the failures nobody warns you about.
  - Published: 2023-06-29 00:00:00

- [Using Tinybird as a serverless online feature store](https://www.tinybird.co/blog/md/using-tinybird-as-a-serverless-online-feature-store)
  - Feature stores cost thousands per month. Tinybird does the same job with SQL you already know. Compare the results yourself.
  - Published: 2023-06-27 00:00:00

- [Using Bloom filter indexes for real-time text search in ClickHouse®](https://www.tinybird.co/blog/md/using-bloom-filter-text-indexes-in-clickhouse)
  - Bloom filters can make your ClickHouse text searches 10x faster. But most teams implement them wrong. Don't be most teams.
  - Published: 2023-06-22 00:00:00

- [Designing and implementing a weather data API](https://www.tinybird.co/blog/md/designing-and-implementing-a-weather-data-api)
  - Weather APIs look simple until you build one that actually scales. These design patterns save you months of refactoring.
  - Published: 2023-06-20 00:00:00

- [A new way to create intermediate Data Sources in Tinybird](https://www.tinybird.co/blog/md/announcing-copy-pipes)
  - Copy Pipes automate data movement between sources and destinations. Set up scheduled transforms without writing custom scripts.
  - Published: 2023-06-15 00:00:00

- [5 criteria of data quality and how to test for them](https://www.tinybird.co/blog/md/5-criteria-of-data-quality-and-how-to-test-for-them)
  - Bad data will eventually break your production pipeline. These 5 quality tests catch problems before your users do.
  - Published: 2023-06-09 00:00:00

- [Adding JOIN support for parallel replicas on ClickHouse®](https://www.tinybird.co/blog/md/adding-join-support-for-parallel-replicas-on-clickhouse)
  - Parallel replicas in ClickHouse couldn't handle JOINs. We fixed that. Now your distributed queries just got significantly faster.
  - Published: 2023-06-08 00:00:00

- [Why we just released a huge upgrade to our VS Code Extension](https://www.tinybird.co/blog/md/tinybird-vs-code-extension-v100-announcement)
  - The Tinybird VS Code extension hits v1.0. Write pipes, test queries, deploy to production. All without leaving your editor.
  - Published: 2023-06-01 00:00:00

- [5 Snowflake struggles that every Data Engineer deals with](https://www.tinybird.co/blog/md/5-snowflake-struggles-that-every-data-engineer-deals-with)
  - Every data engineer knows these 5 Snowflake frustrations. Here's how to solve them without abandoning your warehouse investment.
  - Published: 2023-05-18 00:00:00

- [Using custom Kafka headers for advanced message processing](https://www.tinybird.co/blog/md/using-custom-kafka-headers)
  - Kafka headers carry metadata most teams ignore. Learn what they're for and how to build real-time analytics pipelines using them.
  - Published: 2023-05-16 00:00:00

- [The 8 considerations for designing public data APIs](https://www.tinybird.co/blog/md/8-considerations-for-designing-public-data-apis)
  - Designing a public API? Get one of these 8 decisions wrong and developers will abandon it. Here's how to get them right.
  - Published: 2023-05-15 00:00:00

- [Upgrading short link analytics by 100x with Steven Tey](https://www.tinybird.co/blog/md/upgrading-short-link-analytics-by-100x-with-steven-tey)
  - Steven Tey upgraded short link analytics by 100x. Not 2x, not 10x. Here's exactly how he did it and what you can steal for your project.
  - Published: 2023-05-12 00:00:00

- [Building privacy-first native app telemetry with Guilherme Oenning](https://www.tinybird.co/blog/md/dev-qa-guilherme-oenning)
  - Guilherme quit his job to build Aptabase. He tested Postgres, BigQuery, and ClickHouse. Here's why he chose none of them.
  - Published: 2023-05-11 00:00:00

- [How to build a real-time fraud detection system](https://www.tinybird.co/blog/md/how-to-build-a-real-time-fraud-detection-system)
  - Build a real-time fraud detection system using Tinybird. Stop fraud fast with streaming data, smart analytics, and instant alerts.
  - Published: 2023-05-09 00:00:00

- [The 5 rules for writing faster SQL queries](https://www.tinybird.co/blog/md/5-rules-for-writing-faster-sql-queries)
  - Slow SQL queries cost more than you think. These 5 rules speed them up without major rewrites. Apply them today.
  - Published: 2023-05-08 00:00:00

- [Low-code analytics with James Devonport of UserLoop](https://www.tinybird.co/blog/md/low-code-analytics-with-james-devonport-of-userloop)
  - James built analytics for Userloop without hiring a data team. Low-code made it possible. Here's his exact approach.
  - Published: 2023-05-05 00:00:00

- [Automating customer usage alerts with Tinybird and Make](https://www.tinybird.co/blog/md/automating-customer-usage-alerts-with-tinybird-and-make)
  - Here's how I used "low-code" analytics and automation to help my team be more proactive.
  - Published: 2023-05-01 00:00:00

- [7 strategies to reduce cloud infrastructure costs in 2023](https://www.tinybird.co/blog/md/7-strategies-for-reducing-cloud-infrastructure-costs-in-2023)
  - Cloud costs doubled for most teams since 2023. These 7 strategies cut infrastructure spend in 2026 without breaking anything.
  - Published: 2023-04-27 00:00:00

- [Real-time Databases: What developers need to know](https://www.tinybird.co/blog/md/real-time-databases-what-developers-need-to-know)
  - Real-time databases hide painful tradeoffs in the fine print. Read this before you commit to one.
  - Published: 2023-04-25 00:00:00

- [Chatting GraphQL with Jamie Barton of Grafbase](https://www.tinybird.co/blog/md/chatting-graphql-with-jamie-barton-of-grafbase)
  - Jamie Barton settled the GraphQL vs REST debate. The answer isn't what most developers assume. Listen to his reasoning.
  - Published: 2023-04-24 00:00:00

- [Generate mock data schemas with GPT](https://www.tinybird.co/blog/md/generate-mock-data-schemas-with-gpt)
  - Describe your data in plain English. Get a complete mock schema instantly. Tinybird's AI-powered generator is now live in the UI.
  - Published: 2023-04-21 00:00:00

- [Free open-source mock data generator for your next project](https://www.tinybird.co/blog/md/mockingbird-announcement-mock-data-generator)
  - Need realistic streaming data for testing? Mockingbird generates mock data to any destination. Use the CLI, UI, or library. Free.
  - Published: 2023-04-20 00:00:00

- [Building real-time solutions with Snowflake at a fraction of cost](https://www.tinybird.co/blog/md/real-time-solutions-with-snowflake)
  - Real-time solutions with Snowflake require workarounds. Here's how to add speed to your warehouse without replacing it.
  - Published: 2023-04-19 00:00:00

- [Real-time streaming analytics with Confluent and Tinybird](https://www.tinybird.co/blog/md/real-time-streaming-analytics-confluent-connector-tinybird)
  - Confluent users: stop waiting for batch jobs. Stream your data into Tinybird and build fast APIs on top of it. Real time, for real.
  - Published: 2023-04-18 00:00:00

- [Tinyshop: Get Tinybird swag delivered to your doorstep](https://www.tinybird.co/blog/md/tinybird-swag-store-announcement)
  - The Tinybird swag store is live. Quality gear for data engineers who ship real-time analytics. Limited stock available.
  - Published: 2023-04-17 00:00:00

- [Building a faster CI pipeline with Turborepo and pnpm](https://www.tinybird.co/blog/md/frontend-ci-monorepo-turborepo-pnpm)
  - We made 3 big changes that have shortened our frontend CI execution time despite a massive increase in code size and test coverage.
  - Published: 2023-04-11 00:00:00

- [Developer Q&A: Monitoring global API latency with chronark](https://www.tinybird.co/blog/md/dev-qa-global-api-latency-chronark)
  - Chronark needed global latency under 50ms. Most said it was impossible. Here's the architecture that proved them wrong.
  - Published: 2023-03-30 00:00:00

- [Developer Q&A with JR the Builder, co-creator of Beam Analytics](https://www.tinybird.co/blog/md/qa-with-jr-the-builder-beam-analytics)
  - JR built a privacy-first alternative to Google Analytics. No cookies, no compromises. Here's the tech stack behind Beam.
  - Published: 2023-03-24 00:00:00

- [Data-driven talk: build fast APIs over data at scale](https://www.tinybird.co/blog/md/ddnyc-talk-fast-apis-faster-at-scale)
  - Fast APIs break at scale. Most teams learn this the hard way. This Data Driven NYC talk shows how to avoid it.
  - Published: 2023-03-23 00:00:00

- [Real-Time Analytics: Boost your business with instant data](https://www.tinybird.co/blog/md/real-time-analytics-a-definitive-guide)
  - Discover what real-time analytics is, how it works, and why it matters. Explore examples, key tools, and practical business use cases.
  - Published: 2023-03-17 00:00:00

- [Build fast charts faster with the Tinybird Grafana plugin](https://www.tinybird.co/blog/md/tinybird-grafana-plugin-launch)
  - Query Tinybird directly from Grafana. No data movement, no sync issues. The plugin is free and available now.
  - Published: 2023-03-04 00:00:00

- [Build serverless real-time analytics on Vercel with Tinybird](https://www.tinybird.co/blog/md/serverless-realtime-analytics-vercel-marketplace)
  - Vercel users: deploy real-time analytics as fast as you ship code. The new Tinybird integration syncs your Workspaces automatically.
  - Published: 2023-03-03 00:00:00

- [Simplifying event sourcing with scheduled snapshots in Tinybird](https://www.tinybird.co/blog/md/scheduled-copy-api-launch)
  - The Scheduled Copy API automates data movement on your terms. No more manual triggers. Set it and let it run.
  - Published: 2023-03-02 00:00:00

- [Building an enterprise-grade real-time analytics platform](https://www.tinybird.co/blog/md/enterprise-grade-real-time-analytics)
  - Managing multiple Workspaces was messy. Now enterprise teams get one dashboard to control usage, billing, and projects. Finally.
  - Published: 2023-03-01 00:00:00

- [Transforming real-time apps with Tinybird and BigQuery](https://www.tinybird.co/blog/md/real-time-applications-with-bigquery-connector)
  - Your BigQuery data is powerful but slow for apps. Now you can query it in milliseconds and publish APIs without moving warehouses.
  - Published: 2023-02-28 00:00:00

- [More Data, More Apps: Improving data ingestion in Tinybird](https://www.tinybird.co/blog/md/more-data-more-apps)
  - More data usually means more headaches. It doesn't have to. Here's how teams in 2026 are scaling without the chaos.
  - Published: 2023-02-21 00:00:00

- [How we cut our CI pipeline execution time in half](https://www.tinybird.co/blog/md/better-ci-pipeline-with-data)
  - Better CI pipelines with data catch problems traditional tests miss. Add analytics to your deployment process and ship with confidence.
  - Published: 2023-02-17 00:00:00

- [Log analytics: trends and correlations that tools miss](https://www.tinybird.co/blog/md/log-analytics-how-to-identify-trends-and-correlations-that-log-analysis-tools-cannot)
  - Stop drowning in logs. This free starter kit helps you spot trends, find patterns, and debug faster. Open source, ready today.
  - Published: 2023-02-01 00:00:00

- [Horizontally scaling Kafka consumers with rendezvous hashing](https://www.tinybird.co/blog/md/kafka-horizontal-scaling)
  - Kafka horizontal scaling sounds straightforward until partitions become bottlenecks. These patterns keep throughput high as you grow.
  - Published: 2023-01-25 00:00:00

- [The top emojis on Twitter for every hour of 2022](https://www.tinybird.co/blog/md/top-emojis-of-2022)
  - We analyzed billions of messages to find the top emojis of 2022. Some results were obvious. Others will surprise you.
  - Published: 2022-12-31 00:00:00

- [Tinybird is SOC 2 Type II compliant](https://www.tinybird.co/blog/md/tinybird-is-soc-2-type-ii)
  - Tinybird is SOC 2 Type II certified. Enterprise security without enterprise friction. Your compliance team will thank you.
  - Published: 2022-12-19 00:00:00

- [Measuring World Cup sentiment with Twitter and Tinybird](https://www.tinybird.co/blog/md/world-cup-sentiment)
  - How do people feel during a World Cup match? I combined Twitter, Python, Tinybird, and Retool to find out.
  - Published: 2022-12-06 00:00:00

- [Understanding the Data Warehouse](https://www.tinybird.co/blog/md/why-data-warehouses)
  - What gave rise to the Data Warehouse? What do they enable? I answer these questions in this first of a two-blog series.
  - Published: 2022-11-29 00:00:00

- [Comparing Tinybird to AWS Kinesis, S3, Glue, and Athena](https://www.tinybird.co/blog/md/comparing-tinybird-to-aws-kinesis-s3-glue-and-athena)
  - Tinybird vs AWS Kinesis, S3, Glue, and Athena: one platform versus four services duct-taped together. The complexity difference is real.
  - Published: 2022-10-26 00:00:00

- [Introducing a redesigned Tinybird UI for better developer productivity](https://www.tinybird.co/blog/md/redesigned-tinybird-ui-developer-productivity)
  - The redesigned Tinybird UI focuses on developer productivity. Less clicking, faster workflows, better debugging. See what changed.
  - Published: 2022-10-20 00:00:00

- [When to use columnar databases over Postgres, MySQL, or MongoDB](https://www.tinybird.co/blog/md/when-to-use-columnar-database)
  - When to use a columnar database depends on your query patterns. Get this decision wrong and performance suffers. Here's how to decide.
  - Published: 2022-10-17 00:00:00

- [We launched an open source ClickHouse® Knowledge Base](https://www.tinybird.co/blog/md/we-launched-an-open-source-clickhouse-knowledge-base)
  - ClickHouse® is an incredible database. We want to help our community learn how to better use it for realtime analytics.
  - Published: 2022-10-11 00:00:00

- [The Data Journey: Unlocking data for the right now](https://www.tinybird.co/blog/md/the-data-journey)
  - The data journey follows predictable stages. Knowing where you are helps you avoid mistakes that slow teams down repeatedly.
  - Published: 2022-10-06 00:00:00

- [You can now explore and analyze time series data in Tinybird](https://www.tinybird.co/blog/md/announcing-time-series)
  - Visualize and analyze in real time any data source with a timestamp using SQL WHERE, GROUP BY, and HAVING filters.
  - Published: 2022-10-04 00:00:00

- [Open-source Google Analytics alternative? Set it up in 3 minutes](https://www.tinybird.co/blog/md/google-analytics-alternative-in-3-minutes)
  - Use the Tinybird Web Analytics Starter Kit to quickly start streaming web events data to a readymade dashboard.
  - Published: 2022-09-12 00:00:00

- [How Session Rewind built an affordable session replay tool](https://www.tinybird.co/blog/md/session-rewind-affordable-session-replay-with-tinybird)
  - Session Rewind delivers a seamless UX at an unmatched price using Tinybird.
  - Published: 2022-09-06 00:00:00

- [How I replaced Google Analytics with Retool and Tinybird, Part 2](https://www.tinybird.co/blog/md/how-i-replaced-google-analytics-with-retool-and-tinybird-part-2)
  - Tinybird serves as a powerful and flexible backend for building analytics dashboards in any UI - in this case Retool. Part 2 of 2.
  - Published: 2022-09-05 00:00:00

- [We've improved notifications for ingestion issues](https://www.tinybird.co/blog/md/improved-notifications-ingestion-issues)
  - A little boost to ingestion observability in Tinybird.
  - Published: 2022-08-26 00:00:00

- [How an ecommerce giant replaced Google Analytics for privacy](https://www.tinybird.co/blog/md/ecommerce-google-analytics-alternative)
  - Here's the architecture they built to satisfy data privacy laws without limiting speed or scale.
  - Published: 2022-08-25 00:00:00

- [How I replaced Google Analytics with Retool and Tinybird, Part 1](https://www.tinybird.co/blog/md/how-i-replaced-google-analytics-with-retool-and-tinybird-part-1)
  - Tinybird serves as a powerful and flexible backend for building analytics dashboards in any UI - in this case Retool. Part 1 of 2.
  - Published: 2022-08-24 00:00:00

- [A privacy-first approach to building a Google Analytics alternative](https://www.tinybird.co/blog/md/privacy-first-google-analytics-alternative)
  - Respecting your web visitors' privacy and getting the data you need don't have to be mutually exclusive.
  - Published: 2022-08-23 00:00:00

- [What is a data product?](https://www.tinybird.co/blog/md/what-is-a-data-product)
  - Like a song recorded in a studio, a data product is more than the sum of its parts.
  - Published: 2022-08-05 00:00:00

- [The definition of real-time data](https://www.tinybird.co/blog/md/definition-of-real-time-data)
  - What is real-time data? A precise definition is elusive. In this case, a metaphor helps.
  - Published: 2022-07-29 00:00:00

- [Text search at scale with ClickHouse®](https://www.tinybird.co/blog/md/text-search-at-scale-with-clickhouse)
  - Searching for thousands of regex patterns on millions of documents in seconds like it’s no big deal.
  - Published: 2022-07-26 00:00:00

- [The data rules worth $40,000 a day](https://www.tinybird.co/blog/md/data-rules-materialized-views-40000-dollars)
  - A "real-world" example of how data best practices can seriously shrink your usage bill.
  - Published: 2022-07-19 00:00:00

- [To the limits of SQL... and beyond](https://www.tinybird.co/blog/md/to-the-limits-of-sql-api-parameters)
  - The Tinybird templating language lets you do more than define query parameters for your endpoints.
  - Published: 2022-07-15 00:00:00

- [Big security updates from Tinybird](https://www.tinybird.co/blog/md/soc-2-enterprise-authentication-announcement)
  - Tinybird is now SOC 2 Type 1 compliant, plus we've added support for enterprise authentication.
  - Published: 2022-07-14 00:00:00

- [Use AWS SNS to send data to Tinybird](https://www.tinybird.co/blog/md/use-aws-sns-to-send-data-to-tinybird)
  - SNS is a popular pub/sub messaging system for AWS users. Here's how to use SNS to send data to Tinybird.
  - Published: 2022-07-12 00:00:00

- [Usage-based pricing: Should you build or buy?](https://www.tinybird.co/blog/md/usage-based-pricing-should-you-build-or-buy)
  - With the advent of realtime analytics platforms, the value of buying SaaS usage-based pricing may be diminishing.
  - Published: 2022-07-08 00:00:00

- [How we recreated r/place with 10 lines of SQL](https://www.tinybird.co/blog/md/how-we-recreated-r-place-with-10-lines-of-sql)
  - Two developers built a data-intensive real-time app in half an hour.
  - Published: 2022-07-06 00:00:00

- [DataMarket replaced 4 data stack tools with Tinybird](https://www.tinybird.co/blog/md/data-market-whitebox-replaces-4-data-stack-tools-with-tinybird)
  - We originally built the WhiteBox spinoff with on-premise infrastructure, but consolidated everything on Tinybird to scale.
  - Published: 2022-06-28 00:00:00

- [Thinking in Tinybird](https://www.tinybird.co/blog/md/thinking-in-tinybird)
  - The best way to build a data project in Tinybird is to work backwards
  - Published: 2022-06-17 00:00:00

- [The challenges of building data systems with high concurrency](https://www.tinybird.co/blog/md/the-hard-parts-of-building-massive-data-systems-with-high-concurrency)
  - Here are 8 things to think about when you're trying to scale in realtime.
  - Published: 2022-06-15 00:00:00

- [I built a Tinybird syntax highlighter for VSCode](https://www.tinybird.co/blog/md/i-built-a-tinybird-syntax-highlighter-for-vscode)
  - The most popular IDE in the world just got cooler.
  - Published: 2022-06-13 00:00:00

- [How to monitor Tinybird using Datadog with vector.dev](https://www.tinybird.co/blog/md/how-to-monitor-tinybird-using-datadog-with-vector-dev)
  - Making better observability possible with Tinybird API endpoints and vector.dev
  - Published: 2022-06-10 00:00:00

- [What are Materialized Views and why do they matter for real-time?](https://www.tinybird.co/blog/md/what-are-materialized-views-and-why-do-they-matter-for-realtime)
  - Use Materialized Views for speed, simplicity, and consistency in your data pipelines.
  - Published: 2022-06-09 00:00:00

- [Roll up data with Materialized Views](https://www.tinybird.co/blog/md/roll-up-data-with-materialized-views)
  - How I used rollups and Materialized Views in Tinybird to dynamically track transactions made on the Ethereum blockchain.
  - Published: 2022-06-01 00:00:00

- [See how much data your endpoints scan in real-time](https://www.tinybird.co/blog/md/see-how-much-data-your-endpoints-scan-in-real-time)
  - Break down every API request by scan size (rows or bytes) and token.
  - Published: 2022-05-25 00:00:00

- [You can now create Materialized Views in the Tinybird UI](https://www.tinybird.co/blog/md/you-can-now-create-materialized-views-in-the-tinybird-ui)
  - Creating faster 1-click endpoints with Tinybird just became easier.
  - Published: 2022-05-20 00:00:00

- [How Typeform built a fully functional user dashboard with Tinybird](https://www.tinybird.co/blog/md/typeform-utm-realtime-analytics)
  - Creating an API that groups different UTM parameters from Typeform URLs
  - Published: 2022-05-17 00:00:00

- [Designing a faster data model to personalize browsing in real time](https://www.tinybird.co/blog/md/clickhouse-query-optimization)
  - Optimizing API endpoint performance for browsing personalisation.
  - Published: 2022-05-11 00:00:00

- [Looking ahead to Kafka Summit '22](https://www.tinybird.co/blog/md/looking-ahead-to-kafka-summit-22)
  - Kafka pro’s and con’s for real-time streaming
  - Published: 2022-04-18 00:00:00

- [The realtime data stack. What’s next for Tinybird.](https://www.tinybird.co/blog/md/tinybird-series-a-whats-next)
  - Sign up and start turning data into realtime insights, actions and business value.
  - Published: 2022-04-05 00:00:00

- [Tinybird is out of beta and open to everyone](https://www.tinybird.co/blog/md/self-serve)
  - Sign up and start turning data into realtime insights, actions and business value.
  - Published: 2022-03-31 00:00:00

- [Welcoming new senior leaders to Tinybird](https://www.tinybird.co/blog/md/executives)
  - Tinybird announces four new senior leaders to help deliver even more value to customers at a key stage of growth.
  - Published: 2022-03-24 00:00:00

- [Visualizing your Twitter timeline sentiment with Tinybird](https://www.tinybird.co/blog/md/analysis-twitter-streaming)
  - What if you could measure happiness and sadness, the peaks and troughs, just by analyzing the sentiment of your Twitter timeline?
  - Published: 2022-03-21 00:00:00

- [Tiny Updates: Drag and Drop to Rearrange Nodes in a Pipe](https://www.tinybird.co/blog/md/rearrange-nodes-in-pipe)
  - New feature: dragging and dropping to rearrange the nodes in a Pipe.
  - Published: 2022-02-15 00:00:00

- [Add data from CSVs with different column orders](https://www.tinybird.co/blog/md/add-data-from-csvs-with-different-column-orders)
  - Add data to a Data Source from a CSV, even if the columns are in a different order to the one used when the Data Source was created.
  - Published: 2022-01-31 00:00:00

- [Spatial Indexing aids Finding which Polygons contain a Point](https://www.tinybird.co/blog/md/spatial-indexing-aids-finding-which-polygons-contain-a-point)
  - Speed up your queries by using a spatial index to select fewer polygons before testing if a point is inside a polygon.
  - Published: 2022-01-27 00:00:00

- [From Kafka streams to data products](https://www.tinybird.co/blog/md/kafka-to-api-endpoints)
  - Productize data ingested via Kafka using API endpoints with Tinybird
  - Published: 2022-01-11 00:00:00

- [Operational Analytics in Real Time with Tinybird and Retool](https://www.tinybird.co/blog/md/service-data-sources-and-retool)
  - Three steps to create a Retool app or dashboard in minutes to display your operational analytics in real time.
  - Published: 2022-01-04 00:00:00

- [The era of JSON data analytics](https://www.tinybird.co/blog/md/the-era-of-json-analytics)
  - JSON is the de facto standard for data communication in the web and that's why we are supporting it natively: from a Kafka stream or from local or remote NDJSON files (and very soon in other flavours)
  - Published: 2021-12-21 00:00:00

- [Splitting CSV files at 3GB/s](https://www.tinybird.co/blog/md/simd)
  - Splitting CSV files is a must when dealing with large, potentially larger than RAM, files. But how fast can it be?
  - Published: 2021-12-14 00:00:00

- [Performance and Kafka compression](https://www.tinybird.co/blog/md/kafka-performance-and-compression)
  - The **unmodified** support message we sent to one of our clients outlining potential performance gains through Kafka compression
  - Published: 2021-12-09 00:00:00

- [SQL and Python: alerts from predictions](https://www.tinybird.co/blog/md/sql-and-python)
  - Combine Tinybird with pre-coded models to make predictions, compare data in real time to the predictions and alert.
  - Published: 2021-10-04 00:00:00

- [ClickHouse® Tips #12: Apply Functions to Columns with a Single Call](https://www.tinybird.co/blog/md/tips-12-how-to-apply-a-function-into-multiple-col-1call)
  - Clickhouse® 21 allows some fancy operations packed into multiple columns with SELECT modifiers.
  - Published: 2021-09-29 00:00:00

- [ClickHouse® tips #11: Best way to get query types](https://www.tinybird.co/blog/md/tips-11-how-to-get-the-types-returned-by-a-query)
  - A fast and simple solution to know the types returned by a query. Part 11.
  - Published: 2021-09-22 00:00:00

- [New feature: sharing Data Sources across workspaces](https://www.tinybird.co/blog/md/new-feature-sharing-data-sources-across-workspaces)
  - Sharing data sources across Workspaces enables team collaboration without duplication. One source, multiple consumers. Available now.
  - Published: 2021-08-04 00:00:00

- [ClickHouse® tips #10: Null behavior with LowCardinality columns](https://www.tinybird.co/blog/md/tips-10-null-behavior-with-lowcardinality-columns)
  - Does it work? What's actually inserted? Part 10.
  - Published: 2021-07-21 00:00:00

- [Experimental ClickHouse®: Projections](https://www.tinybird.co/blog/md/projections)
  - Projections in ClickHouse can 10x query performance when used correctly. Most teams skip them. Don't make that mistake.
  - Published: 2021-07-09 00:00:00

- [ClickHouse® tips #9: Filling gaps in time-series on ClickHouse®](https://www.tinybird.co/blog/md/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.
  - Published: 2021-07-08 00:00:00

- [Starting with Kafka](https://www.tinybird.co/blog/md/starting-with-kafka)
  - Starting with Kafka feels overwhelming. This guide cuts through the complexity and gets you streaming data in hours, not weeks.
  - Published: 2021-06-25 00:00:00

- [Simple statistics for anomaly detection on time-series data](https://www.tinybird.co/blog/md/anomaly-detection)
  - Anomaly detection is a type of data analytics whose goal is detecting outliers or unusual patterns in a dataset.
  - Published: 2021-06-24 00:00:00

- [Adapt Postgres queries to Tinybird](https://www.tinybird.co/blog/md/adapt-postgres-queries-to-tinybird)
  - Your Postgres queries won't work the same in Tinybird. These adaptations ensure your migration actually improves performance.
  - Published: 2021-06-21 00:00:00

- [ClickHouse® tips #8: Generating time-series on ClickHouse®](https://www.tinybird.co/blog/md/tips-8-generating-time-series-on-clickhouse)
  - ClickHouse® doesn't have a generate_series function yet, but you can achieve the same with other functions. Learn how here. Part 8.
  - Published: 2021-06-01 00:00:00

- [Analyzing artists performance in real-time with Tinybird](https://www.tinybird.co/blog/md/analyzing-artists-streams-in-real-time-with-tinybird)
  - Spotify builds Wrapped once a year. You can build real-time artist analytics today. Here's exactly how to do it.
  - Published: 2021-05-27 00:00:00

- [New feature: add column to a Data Source](https://www.tinybird.co/blog/md/add-column)
  - From now on, it's possible to add new columns to existing Data Sources on Tinybird. This is how.
  - Published: 2021-05-25 00:00:00

- [ClickHouse® tips #7: Forward and backfilling null values](https://www.tinybird.co/blog/md/tips-7-filling-null-values-on-clickhouse)
  - Making use of array functions to do it. Part 7.
  - Published: 2021-05-18 00:00:00

- [Analyzing our own Nginx logs with ClickHouse® on Tinybird](https://www.tinybird.co/blog/md/analyzing-nginx-logs-with-clickhouse-and-tinybird)
  - How we analyze our own logs in real-time using our own product.
  - Published: 2021-05-02 00:00:00

- [ClickHouse® tips #6: Filtering data in subqueries to avoid joins](https://www.tinybird.co/blog/md/tips-6-faster-joins-without-joining-using-where)
  - Faster JOINs without joining: use WHERE instead. This ClickHouse tip speeds up queries that don't actually need full joins.
  - Published: 2021-04-23 00:00:00

- [Visualize data sources and pipes dependencies on Tinybird](https://www.tinybird.co/blog/md/data-lineage-graph)
  - A better way to visualize the relationships between your Data Sources, Pipes and Materialized Views.
  - Published: 2021-03-25 00:00:00

- [ClickHouse® tips #5: Adding and subtracting intervals](https://www.tinybird.co/blog/md/tips-5-adding-and-subtracting-intervals)
  - Tips and recipes to learn how to make the most of ClickHouse®, curated weekly by the Tinybird team. Part 5.
  - Published: 2021-03-24 00:00:00

- [Coming soon on ClickHouse®: Window functions](https://www.tinybird.co/blog/md/coming-soon-on-clickhouse-window-functions)
  - Discover ClickHouse® window functions, the new experimental feature that brings advanced SQL analytics to your datasets.
  - Published: 2021-03-16 00:00:00

- [ClickHouse® Tips #4: Materializing UNION ALL queries](https://www.tinybird.co/blog/md/clickhouse-tips-4-materializing-union-all-queries-using-simpleaggregatefunction-and-grouparrayarray-function)
  - Master UNION ALL in ClickHouse®. Build faster materialized views and optimize queries with SimpleAggregateFunction.
  - Published: 2021-03-07 00:00:00

- [DataOps: How to Develop and Scale Data Intensive Projects](https://www.tinybird.co/blog/md/dataops)
  - DataOps practices separate teams that ship from teams that struggle. These workflows bring DevOps rigor to data pipelines in 2026.
  - Published: 2021-02-27 00:00:00

- [DataOps: 10 principles to develop data intensive projects](https://www.tinybird.co/blog/md/dataops-principles)
  - 10 of the principles of DataOps that we make available to data teams.
  - Published: 2021-02-27 00:00:00

- [ClickHouse® tips #3: the transform function](https://www.tinybird.co/blog/md/tips-3-transform)
  - Using the transform function to join two tables when joinGet is not available. Part 3.
  - Published: 2021-02-25 00:00:00

- [Clickhouse®, Open Source and Tinybird](https://www.tinybird.co/blog/md/tinybird-clickhouse)
  - Tinybird runs on ClickHouse but adds what's missing: APIs, auth, scaling, and deployment. Same engine, completely different experience.
  - Published: 2021-02-16 00:00:00

- [Build real-time analytics APIs collaboratively with Tinybird](https://www.tinybird.co/blog/md/workspaces)
  - Workspaces organize your Tinybird projects cleanly. Separate environments, manage access, and deploy with confidence.
  - Published: 2021-02-11 00:00:00

- [ClickHouse® tips #2: Debugging ClickHouse® on Visual Studio Code](https://www.tinybird.co/blog/md/tinybird-tips-debugging-clickhouse-on-vscode)
  - How to configure Visual Studio Code to debug ClickHouse® on it. Part 2.
  - Published: 2021-02-10 00:00:00

- [Publish SQL-based endpoints on NGINX log analysis](https://www.tinybird.co/blog/md/nginx-log-analysis)
  - Building a highly scalable log analytics tool with Tinybird and exporting your queries as an API.
  - Published: 2021-01-28 00:00:00

- [Low-latency APIs over your BigQuery datasets](https://www.tinybird.co/blog/md/real-time-analytics-bigquery-dataflow)
  - Real-time analytics with BigQuery and Dataflow adds speed to your warehouse. Here's the architecture that bridges batch and streaming.
  - Published: 2021-01-28 00:00:00

- [ClickHouse® tips #1: calculating aggregations after a date](https://www.tinybird.co/blog/md/tinybird-tips-1-calculating-aggregations-after-and-before-a-date)
  - Tips and recipes to learn how to make the most of ClickHouse®, curated weekly by the Tinybird team. Part 1.
  - Published: 2021-01-26 00:00:00

- [Product design: how our SaaS integrates with git](https://www.tinybird.co/blog/md/tech-product-design-how-we-integrate-with-git)
  - Analytics data projects are code and code should be in a repo.
  - Published: 2021-01-22 00:00:00

- [Querying large CSVs online with SQL](https://www.tinybird.co/blog/md/query-csvs-online-with-sql)
  - Use Tinybird to query large CSVs using SQL, right from your browser.
  - Published: 2021-01-19 00:00:00

- [Gain Visibility Over Your Asynchronous Operations](https://www.tinybird.co/blog/md/gain-visibility-of-async-ops-with-the-jobs-api)
  - Now, you will be also able to see the status of your job queue from the UI.
  - Published: 2020-12-22 00:00:00

- [How we processed 12 trillion rows during Black Friday](https://www.tinybird.co/blog/md/how-we-setup-real-time-analytics-service-to-process-12-trillion-rows-during-black-friday)
  - In this post we explain the data architecture, infrastructure and how we scale our real-time analytics service with ClickHouse®.
  - Published: 2020-12-21 00:00:00

- [Investigating Performance Bottlenecks With SQL & Statistics](https://www.tinybird.co/blog/md/eating-our-own-dog-food-how-we-investigate-performance-bottlenecks-using-our-product-and-google-sheets)
  - We investigate performance bottlenecks using our own product and Google Sheets. Dogfooding reveals problems customers never report.
  - Published: 2020-12-15 00:00:00

- [Selective data deletion: a new feature for data quality management](https://www.tinybird.co/blog/md/selective-data-deletion)
  - Selective data deletion in ClickHouse is tricky. Delete the wrong way and performance tanks. Here's the approach that actually works.
  - Published: 2020-08-27 00:00:00

- [Operational Analytics. Data Insights Are Great](https://www.tinybird.co/blog/md/operational-analytics)
  - Operational analytics power real-time business decisions. Dashboards that refresh hourly aren't enough anymore. Here's what works.
  - Published: 2020-08-26 00:00:00

- [Improving data ingestion: better error feedback](https://www.tinybird.co/blog/md/ingestion-improvements)
  - We rebuilt ingestion from scratch. Faster uploads, fewer failures, better error messages. Here's what changed under the hood.
  - Published: 2020-08-19 00:00:00

- [Analytics API endpoints for your developers](https://www.tinybird.co/blog/md/badass-api-endpoint)
  - Build an API endpoint that actually impresses. Performance, reliability, and developer experience that makes integrations easy.
  - Published: 2020-08-11 00:00:00

- [A new dashboard for Tinybird Analytics](https://www.tinybird.co/blog/md/new-dashboard)
  - The new dashboard shows what matters at a glance. Usage, performance, errors. All the metrics you need without digging through tabs.
  - Published: 2020-05-07 00:00:00

- [Introducing the Data Operations Log](https://www.tinybird.co/blog/md/data-operations-log)
  - Data operations log tracks every change to your pipelines. Debug issues faster with complete visibility into what happened and when.
  - Published: 2020-04-20 00:00:00

- [Dynamic API reponses based on endpoint parameters](https://www.tinybird.co/blog/md/create-a-dynamic-api)
  - Make your Tinybird real-time API endpoints to return data at different resolutions depending on the selected temporal range.
  - Published: 2020-03-25 00:00:00

- [Tinybird Changelog: sharing pipes](https://www.tinybird.co/blog/md/share-pipes)
  - Sharing data is hard - here is our alternative to sending a CSV file by email
  - Published: 2020-03-24 00:00:00

- [Enriching Kafka streams for real-time queries](https://www.tinybird.co/blog/md/enriching-kafka-streams-in-real-time)
  - Enriching Kafka streams in real-time adds context your analytics desperately need. Here's the architecture that doesn't slow you down.
  - Published: 2020-03-19 00:00:00

- [Create a Static Application to Analyze +50M Github Events](https://www.tinybird.co/blog/md/create-analytic-static-applications)
  - Your static site doesn't need a backend to have real-time analytics. Here's how to add them without the complexity.
  - Published: 2020-03-11 00:00:00

- [How We Handle Technical Incidents and Service Disruptions](https://www.tinybird.co/blog/md/how-we-handle-service-disruptions)
  - Service disruptions happen. How you handle them defines trust. Here's our incident response process and what we learned from failures.
  - Published: 2020-01-09 00:00:00

- [Tinybird Changelog: New User Experience for Data Exploration](https://www.tinybird.co/blog/md/redesigned-data-pipe-ui)
  - During the last few weeks we’ve been studying the best way of building and organizing large applications using Tinybird Analytics, and, in addition to a few ...
  - Published: 2019-11-18 00:00:00

- [The cron job that will speed up your Postgres queries 100x](https://www.tinybird.co/blog/md/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold)
  - One cron job made Postgres analytics 100x faster. Seriously. This optimization takes 10 minutes to implement.
  - Published: 2019-10-14 00:00:00

- [Real-time analytics API at scale with billions of rows](https://www.tinybird.co/blog/md/real-time-analytics-with-billion-rows-at-scale)
  - How to create an analytics API that deals with billions of rows in a matter of minutes.
  - Published: 2019-09-30 00:00:00

- [Tinybird at South Summit Madrid 2019](https://www.tinybird.co/blog/md/south-summit-madrid-2019)
  - Tinybird at South Summit Madrid 2019: where our journey with real-time analytics began. A look back at how far we've come.
  - Published: 2019-09-26 00:00:00

- [Improved Support for Replacing or Appending Data](https://www.tinybird.co/blog/md/replace-and-append)
  - One of the foundational ideas of Tinybird Analytics is resiliency and consistency under high frequency or big data updates.
  - Published: 2019-09-03 00:00:00

- [Our focus on Speed](https://www.tinybird.co/blog/md/our-focus-on-speed)
  - Our focus on speed isn't marketing. It's architecture. Here's why milliseconds matter and how we optimize for them obsessively.
  - Published: 2019-08-08 00:00:00

- [Learnings and results of our first User Testing sessions](https://www.tinybird.co/blog/md/user-testing)
  - In Product Development, “User Testing” is often easier to talk about than to actually do.
  - Published: 2019-08-02 00:00:00

- [Try out Tinybird's closed beta](https://www.tinybird.co/blog/md/closed-beta)
  - Tinybird started in closed beta with a handful of teams. Here's what we learned and how it shaped the product you use today.
  - Published: 2019-06-28 00:00:00

- [Tinybird Changelog: Faster CSV Imports](https://www.tinybird.co/blog/md/faster-csv-import-and-auth-tokens-with-filters)
  - During the last couple of weeks, we’ve made major improvements to our CSV import process, increasing its speed and reliability, getting almost a 2x performance.
  - Published: 2019-06-04 00:00:00

- [ClickHouse® Meetup Madrid videos](https://www.tinybird.co/blog/md/clickhouse-meetup-madrid-videos)
  - Last April we had the pleasure to host the ClickHouse® meetup in Madrid.
  - Published: 2019-05-29 00:00:00

- [Simple Time Series Prediction Modeling Using Tinybird](https://www.tinybird.co/blog/md/simple-time-series-prediction)
  - Simple time series prediction doesn't require a PhD. This approach gives you forecasts with SQL you already understand.
  - Published: 2019-04-21 00:00:00

- [Typical Challenges of Building Your Data Layer](https://www.tinybird.co/blog/md/data-journey)
  - Every data project hits the same walls at the same stages. Knowing where you are helps you avoid the predictable mistakes.
  - Published: 2019-04-15 00:00:00