# 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 · The analytics backend for your application](https://www.tinybird.co/) - All the infrastructure you need to ship analytics in your app. Capture, store, transform, and serve data without dependencies on external tools or teams. - [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. - [Pricing · Tinybird](https://www.tinybird.co/pricing) - Fair, simple pricing. Pay as you go. Start for free. - [tinybird.ai](https://www.tinybird.co/ai) - The era of agentic analytics is here. The agentic analytics stack finally is, too. - [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 Us · Tinybird](https://www.tinybird.co/contact-us) - Request a Tinybird demo right here. ## Customer Stories - [Canva designs brilliant user experiences with Tinybird](https://www.tinybird.co/customer-stories/canva) - Discover how the world's most‑loved online design platform builds user‑facing analytics 10x cheaper and 5x faster with Tinybird. - Customer: Canva - Use Case: User-Facing Analytics - [FanDuel scores big with real‑time insights via Tinybird](https://www.tinybird.co/customer-stories/fanduel) - Discover how the US's largest online sportsbook leveraged Tinybird for real‑time data analytics. - Customer: FanDuel - Use Case: Real-Time Personalization - [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) - Vercel's customers see usage metrics for their applications in realtime, so they can accelerate releases that boost their user experience. - Customer: Vercel - Use Case: User-Facing Analytics - [Factorial builds real‑time data products with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Factorial - Use Case: User-Facing Analytics - [Dub shortens time to market for user‑facing analytics with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Dub - Use Case: User-Facing Analytics - [Phantom gives crypto traders faster buy/sell decisions with Tinybird](https://www.tinybird.co/customer-stories/phantom) - Learn how the most popular Solana wallet processes 2.5B+ daily events for 15M+ users while maintaining sub-50ms query latency. - Customer: Phantom - Use Case: User-Facing Analytics - [Resend delivers email metrics to builders with Tinybird](https://www.tinybird.co/customer-stories/resend) - Learn how Resend processes terabytes of email event logs while maintaining 62ms average query latency for its Marketing Analytics dashboards. - Customer: Resend - Use Case: User-Facing Analytics - [Plain builds real‑time customer support insights with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Plain - Use Case: User-Facing Analytics - [How Raindrop became the Sentry of AI: Scaling to petabytes with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Raindrop - Use Case: User-Facing Analytics - [Blacksmith builds faster CI analytics with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Blacksmith - Use Case: User-Facing Analytics - [Clearwater Dynamics uses Tinybird to power its maritime insurtech solution](https://www.tinybird.co/customer-stories/clearwater-dynamics) - Learn how Clearwater Dynamics uses Tinybird to power analytics for over 200 million vessel position reports daily. - Customer: Clearwater Dynamics - Use Case: User-Facing Analytics - [Audiense evolves its social media timeline with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Audiense - Use Case: User-Facing 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) - The Hotels Network processes several petabytes through Tinybird each month, delivering personalized, realtime booking experiences to prospective hotel clients. - Customer: The Hotels Network - Use Case: User-Facing Analytics - [Smartme Analytics builds complete consumer insights with Tinybird](https://www.tinybird.co/customer-stories/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. - Customer: Smartme Analytics - Use Case: User-Facing Analytics - [Zembula fast-tracks its roadmap with Tinybird](https://www.tinybird.co/customer-stories/zembula) - Learn how a rising email personalization platform used Tinybird to answer previously unanswerable questions about real‑time attribution for their retail customers. - Customer: Zembula - Use Case: Real-Time Personalization - [LocalStack uses Tinybird to analyze 100,000+ instances in realtime](https://www.tinybird.co/customer-stories/localstack-relies-on-tinybird-to-understand-and-improve-their-product) - Customer: LocalStack - Use Case: Operational Intelligence - [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) - Customer: Genially - Use Case: User-Facing Analytics - [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) - Customer: Situm - Use Case: User-Facing Analytics ## Templates - [OpenTelemetry](https://www.tinybird.co/templates/tinybird-otel-template) - 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 - [Birdwatcher Notifications](https://www.tinybird.co/templates/birdwatcher-ai-notifications) - 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 - [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 - [Why we ditched Prometheus for autoscaling (and don't miss it)](https://www.tinybird.co/blog-posts/md/scaling-with-keda-and-tinybird.md) - 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 - [We cut AWS costs by 20% while scaling faster with EKS, Karpenter, and Spot Instances](https://www.tinybird.co/blog-posts/md/how-we-cut-aws-costs-while-scaling-faster-with-eks-karpenter-and-spot-instances.md) - Read how Tinybird slashed AWS costs by 20% —and up to 90% on CI— with Karpenter, Spot Instances, and real-time autoscaling. A deep dive into our setup, lessons learned, and tips you can steal. - Published: 2025-06-27 10:00:00 - [Scaling up ClickHouse ingestion with a Multi-writer architecture](https://www.tinybird.co/blog-posts/md/scaling-real-time-ingestion-with-multiple-writers.md) - Sometimes compute-compute separation isn't enough. Here's how we horizontally scaled our ClickHouse streaming ingestion service to handle bigger loads more efficiently. - Published: 2025-06-27 10:00:00 - [How we protect your primary workloads with Compute-Compute Separation for Populates](https://www.tinybird.co/blog-posts/md/compute-compute-separation-for-populates.md) - With compute-compute separation for populates, Tinybird now handles even the most demanding data transformations and backfills without impacting your primary workloads or having to temporarily scale your cluster for more compute resources. - Published: 2025-06-27 10:00:00 - [How we made our ingestion pipeline 30% faster with C++ (not Rust, sorry)](https://www.tinybird.co/blog-posts/md/improved-rowbinary-conversion.md) - JSON to ClickHouse RowBinary conversion powers much of Tinybird's ingestion. We made it more efficient, complete, and predictable, cutting CPU usage by more than 30%. - Published: 2025-06-27 10:00:00 - [How we automatically handle ClickHouse schema migrations](https://www.tinybird.co/blog-posts/md/when-not-to-migrate-your-data.md) - 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-posts/md/sinks-in-forward.md) - 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-posts/md/tinybird-cli-now-supports-windows.md) - With Forward, Tinybird is CLI-first. Now, developers on Windows can install and use the Tinybird CLI with native PowerShell support and cross-platform compatibility fixes. - Published: 2025-06-25 10:00:00 - [Improving the Tinybird onboarding flow: What we learned](https://www.tinybird.co/blog-posts/md/redesigning-quickstart-in-tinybird-forward.md) - Designing onboarding for a CLI is hard. Here’s how we rebuilt Tinybird's onboarding to make getting started easier, faster, and less overwhelming. - Published: 2025-06-25 09:59:00 - [Introducing the Tinybird OpenTelemetry Exporter](https://www.tinybird.co/blog-posts/md/introducing-the-tinybird-opentelemetry-exporter.md) - 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: Your real-time data, LLM-ready](https://www.tinybird.co/blog-posts/md/introducing-the-tinybird-mcp-server-your-real-time-data-llm-ready.md) - Announcing Tinybird MCP Server - a hosted, remote MCP server that gives LLMs and AI agents secure access to your real-time Tinybird data. - Published: 2025-06-23 10:00:00 - [Chat with your data using the Birdwatcher Slack App](https://www.tinybird.co/blog-posts/md/birdwatcher-slack-app.md) - I built Birdwatcher, an analytics agent that connects to your Tinybird Workspace. You can add it to your Slack workspace to start talking to your data. - Published: 2025-06-23 09:01:00 - [Building an autonomous analytics agent with Agno and Tinybird](https://www.tinybird.co/blog-posts/md/building-an-analytics-agent-with-agno-and-tinybird.md) - Here's how I build Birdwatcher, an autonomous AI agent that uses the Tinybird MCP Server to explore data in Tinybird and accomplish any mission you give it. - Published: 2025-06-23 09:00:00 - [MCP vs APIs: When to Use Which for AI Agent Development](https://www.tinybird.co/blog-posts/md/mcp-vs-apis-when-to-use-which-for-ai-agent-development.md) - MCP enforces consistency that HTTP APIs lack, which is essential for LLMs' autonomous tool selection and agent autonomy. This post breaks down real-world trade-offs of using MCPs and/or APIs - Published: 2025-06-10 14:00:00 - [Research on Indexing in Real-Time OLAP Systems](https://www.tinybird.co/blog-posts/md/research-on-indexing-in-real-time-olap-systems-sb.md) - Explore the latest advancements in indexing techniques for real-time OLAP systems, enhancing performance, scalability, and data freshness. - Published: 2025-06-07 07:24:06 - [Distributed Caching for Scalable Real-Time Systems](https://www.tinybird.co/blog-posts/md/distributed-caching-for-scalable-real-time-systems-sb.md) - Explore the vital role of distributed caching in enhancing the speed, reliability, and scalability of real-time systems. - Published: 2025-06-06 07:04:02 - [Slow Query Performance? 6 Quick Fixes](https://www.tinybird.co/blog-posts/md/slow-query-performance-6-quick-fixes-sb.md) - Improve slow query performance with practical tips on execution plans, indexing, query rewriting, caching, resource management, and storage optimization. - Published: 2025-06-05 06:08:25 - [Cloud vs On-Premise Analytics: Cost Analysis](https://www.tinybird.co/blog-posts/md/cloud-vs-on-premise-analytics-cost-analysis-sb.md) - Explore the cost analysis of cloud versus on-premise analytics, focusing on initial investment, operational costs, scalability, and control. - Published: 2025-06-04 07:11:05 - [Optimizing Apache Iceberg tables for real-time analytics](https://www.tinybird.co/blog-posts/md/optimizing-apache-iceberg-tables-for-real-time-analytics.md) - 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 - [5 Best Practices for Scaling Analytics APIs](https://www.tinybird.co/blog-posts/md/5-best-practices-for-scaling-analytics-apis-sb.md) - Learn essential best practices for scaling analytics APIs to enhance performance, reliability, and cost-effectiveness in handling data loads. - Published: 2025-06-03 03:40:04 - [Materialized Views: Common Questions Answered](https://www.tinybird.co/blog-posts/md/materialized-views-common-questions-answered-sb.md) - Explore materialized views, their benefits, refresh methods, best practices, and use cases in real-time analytics to enhance database performance. - Published: 2025-06-02 11:40:33 - [SQL Performance Checklist for Large Datasets](https://www.tinybird.co/blog-posts/md/sql-performance-checklist-for-large-datasets-sb.md) - Optimize SQL performance for large datasets with effective strategies on infrastructure, indexing, query design, and real-time analytics. - Published: 2025-06-01 06:25:52 - [OLAP vs OLTP: Which Database Fits Your Project?](https://www.tinybird.co/blog-posts/md/olap-vs-oltp-which-database-fits-your-project-sb.md) - Understand the differences between OLAP and OLTP databases to choose the right one for your project needs in transactions or analytics. - Published: 2025-05-31 06:31:05 - [Real-Time Sentiment Analysis with Kafka Streams](https://www.tinybird.co/blog-posts/md/real-time-sentiment-analysis-with-kafka-streams-sb.md) - Explore how Kafka Streams enables real-time sentiment analysis, turning raw text into actionable insights for businesses instantly. - Published: 2025-05-30 17:34:02 - [Can I use Supabase for analytics?](https://www.tinybird.co/blog-posts/md/can-i-use-supabase-for-user-facing-analytics.md) - Supabase is a popular managed Postgres with a bunch of great features. Learn how to use Supabase to build simple user-facing analytics systems, and when to pair Supabase with technologies optimized for analytics. - Published: 2025-05-26 00:00:00 - [How to build CI/CD pipelines for real-time analytics projects](https://www.tinybird.co/blog-posts/md/ci-cd-best-practices-with-tinybird.md) - Learn how to build a proper CI/CD pipeline for your real-time analytics project. This follow-up post shows you how to implement automated testing, versioning, and deployment for your real-time data APIs. - Published: 2025-05-25 00:00:00 - [Building Real-Time Analytics Applications with Redpanda, Iceberg, and Tinybird](https://www.tinybird.co/blog-posts/md/building-real-time-analytical-apps-with-redpanda-iceberg-and-tinybird.md) - I share an alternative architecture to build real-time analytical APIs for your applications using a combination of Redpanda, Iceberg tables, and Tinybird. - Published: 2025-05-23 10:00:00 - [Real-Time Analytics on Apache Iceberg with Tinybird](https://www.tinybird.co/blog-posts/md/real-time-analytics-on-apache-iceberg-with-tinybird.md) - 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-posts/md/iot-monitoring-with-kafka-and-tinybird.md) - Learn how to build a real-time IoT analytics pipeline using Kafka and Tinybird. This hands-on guide shows you how to process thousands of device readings and expose instant insights through API endpoints, with complete local to production deployment. - Published: 2025-05-20 00:00:00 - [We graded 19 LLMs on SQL. You graded us.](https://www.tinybird.co/blog-posts/md/we-graded-19-llms-on-sql-you-graded-us.md) - We benchmarked 19 LLMs on analytical SQL and the internet had thoughts. Here's a breakdown of your feedback, what we got wrong, what we got right (but didn’t explain), and how we’re improving the benchmark for round two. - Published: 2025-05-16 00:00:00 - [A Developer's Guide to Data Engineering](https://www.tinybird.co/blog-posts/md/data-engineering-for-developers.md) - 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-posts/md/query-booster-how-tinybird-optimizes-table-schemas-for-you.md) - Query Booster is an intelligent feature that automatically monitors your database usage patterns and optimizes performance by fine-tuning data source schemas. - Published: 2025-05-12 00:00:00 - [Get to know your data's data - EDA in Tinybird](https://www.tinybird.co/blog-posts/md/eda-in-tinybird-with-explorations.md) - Exploratory Data Analysis (EDA) helps you understand the shape of your data. Here's how to get metadata on your data using Tinybird's new Explorations feature. - Published: 2025-05-09 00:00:00 - [Which LLM writes the best analytical SQL?](https://www.tinybird.co/blog-posts/md/which-llm-writes-the-best-sql.md) - 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 - [Building a conversational AI tool for real-time analytics](https://www.tinybird.co/blog-posts/md/building-explorations-a-conversational-analytics-ai.md) - 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-posts/md/introducing-explorations.md) - 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-posts/md/dbt-in-real-time.md) - Tinybird is kind of like dbt, but for real-time use cases. Here's how and why you might migrate real-time API use cases from dbt to Tinybird. - Published: 2025-04-24 00:00:00 - [How to count 100B events: Comparing architectures](https://www.tinybird.co/blog-posts/md/how-to-count-100b-events-comparing-architectures.md) - Reddit built a powerful architecture in 2017 to count views and unique viewers on posts. How does it compare to our simpler Tinybird approach? - Published: 2025-04-21 00:00:00 - [Using LLMs to generate user-defined real-time data visualizations](https://www.tinybird.co/blog-posts/md/using-llms-to-generate-user-defined-real-time-data-visualizations.md) - UIs are changing. Here's how to use LLMs and real-time analytics APIs to build allow your users to generate their own data visualizations. - Published: 2025-04-17 00:00:00 - [Lessons learned from 5 years operating huge ClickHouse® clusters: Part II](https://www.tinybird.co/blog-posts/md/what-i-learned-operating-clickhouse-part-ii.md) - This is the second part of the series. Here's more of what I've learned from operating petabyte-scale ClickHouse clusters for the last 5+ years. - Published: 2025-04-16 00:00:00 - [The simplest way to count 100B unique IDs: Part 2](https://www.tinybird.co/blog-posts/md/the-simplest-way-to-count-100b-unique-ids-part-2.md) - 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-posts/md/natural-language-dashboard-filters.md) - Click-to-filter is out. Prompt-to-filter is in. Learn how to ditch the filter sidebars and dropdowns and replace them with a single user text input and an LLM. - Published: 2025-04-10 00:00:00 - [Best practices for downsampling billions of rows of data](https://www.tinybird.co/blog-posts/md/data-downsampling-best-practices.md) - 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-posts/md/how-to-safely-cancel-a-database-query.md) - Cancelling a query from a UI client is more nuanced than it might seem. Here's how we implemented safe KILL QUERY operations in Tinybird. - Published: 2025-04-07 00:00:00 - [How Inbox Zero uses Tinybird for real-time analytics](https://www.tinybird.co/blog-posts/md/how-inbox-zero-uses-tinybird-for-real-time-analytics.md) - 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-posts/md/introducing-llm-performance-tracker.md) - You can't just build AI features, you have to operate them in production, which means observability. Here's an open source tool to watch your LLMs in real-time. - Published: 2025-04-03 00:00:00 - [Hype v. Reality: 5 AI features that actually work in production](https://www.tinybird.co/blog-posts/md/ai-features-that-work.md) - 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-posts/md/what-i-learned-operating-clickhouse.md) - I've been operating large ClickHouse clusters for years. Here's what I've learned about architecture, storage, upgrades, config, testing, costs, and ingestion. - Published: 2025-04-01 00:00:00 - [Real-time inventory management with lambda architecture](https://www.tinybird.co/blog-posts/md/real-time-inventory-management-with-lambda-architecture.md) - Learn how to use Tinybird to build a lambda architecture for real-time inventory, unifying batch and real-time workflows in a single platform. - Published: 2025-03-28 00:00:00 - [Instrument your LLM calls to analyze AI costs and usage](https://www.tinybird.co/blog-posts/md/instrument-your-llm-calls.md) - If you're building AI features, make sure to instrument your LLM calls so you can analyze costs, usage, and adoption. Here are a few examples in Python and TypeScript. - Published: 2025-03-27 00:00:00 - [Vibe code tools, not toys.](https://www.tinybird.co/blog-posts/md/vibe-code-tools-not-toys.md) - 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-posts/md/the-simplest-way-to-count-100-billion-unique-ids-part-1.md) - 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-posts/md/tb-infra.md) - 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-posts/md/tb-deploy.md) - 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-posts/md/tb-test.md) - Testing is a fundamental software practice. But people don't do it in data because it's hard. We're making it less hard (and more fun). - Published: 2025-03-20 00:00:00 - [Build fast software with big data requirements](https://www.tinybird.co/blog-posts/md/tb-dev.md) - 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 - [Local first.](https://www.tinybird.co/blog-posts/md/local-first-experience.md) - 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-posts/md/tb-create.md) - 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-posts/md/announcing-tinybird-forward.md) - Announcing Tinybird Forward, a new evolution of the Tinybird user experience designed to make building real-time data applications faster and more intuitive than ever before. - Published: 2025-03-14 00:00:00 - [How to run load tests in real-time data systems](https://www.tinybird.co/blog-posts/md/how-to-run-load-tests-in-real-time-data-systems.md) - We have run hundreds of load tests for customers processing petabytes of data in real-time. Here's everything you need to know to plan, execute, and analyze a load test in a real-time data system. - Published: 2025-03-07 00:00:00 - [We added the Backup Database engine to ClickHouse](https://www.tinybird.co/blog-posts/md/new-clickhouse-backup-engine.md) - 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: How to optimize and integrate an OLTP + OLAP stack](https://www.tinybird.co/blog-posts/md/outgrowing-postgres-how-to-optimize-and-integrate-an-oltp-olap-stack.md) - Navigate the complexities of OLTP and OLAP integration by choosing simple, scalable data movement patterns that reduce infrastructure overhead and keep your focus on building great products for users. - Published: 2025-02-27 00:00:00 - [Build a Datadog alternative in 5 minutes](https://www.tinybird.co/blog-posts/md/build-a-datadog-alternative-in-5-minutes.md) - I built an open source template that you can use to have a free, simple Datadog alternative in about 5 minutes. Here was my process for building it. - Published: 2025-02-26 00:00:00 - [You built a Datadog alternative. Now scale it.](https://www.tinybird.co/blog-posts/md/build-a-datadog-alternative-in-5-minutes-part-2.md) - I bootstrapped a logs explorer, but I knew it wouldn't scale. Here's how I optimized the data pipeline for billions of logs and thousands of users. - Published: 2025-02-26 00:00:00 - [The perfect data ingestion API design](https://www.tinybird.co/blog-posts/md/the-perfect-data-ingestion-api-design.md) - 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-posts/md/real-time-logs-analytics-architectures.md) - I've spent years optimizing logs explorers across multiple domains with trillions of logs to process. Here's what I've learned about building a performant logs analytics system. - Published: 2025-02-19 00:00:00 - [Outgrowing Postgres: How to evaluate the right OLAP solution for analytics](https://www.tinybird.co/blog-posts/md/outgrowing-postgres-how-to-evaluate-the-right-olap-solution-for-analytics.md) - Moving analytical workloads off Postgres? Learn how to evaluate real-time OLAP solutions based on what actually matters: performance, SQL compatibility, and developer experience. - Published: 2025-02-17 00:00:00 - [Build a data-intensive Next.js app with Tinybird and Cursor](https://www.tinybird.co/blog-posts/md/data-intensive-nextjs-app-tinybird-cursor.md) - Building a Next.js app is easy. Setting up infra to handle millions of logs isn't. Here's how I built a data-intensive Next app with Tinybird and Cursor. - Published: 2025-02-13 00:00:00 - [Ship data as you ship code: Deploy changes with a single command](https://www.tinybird.co/blog-posts/md/tinybird-forward.md) - 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-posts/md/outgrowing-postgres-when-to-move-olap-workloads-off-postgres.md) - 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 is becoming local-first.](https://www.tinybird.co/blog-posts/md/tinybird-is-local-first.md) - Tinybird's local-first experience is coming. Write code. Test it locally. Push it to git. CI runs the build. It's deployed. You're done. - Published: 2025-02-05 00:00:00 - [Why we created new pricing for Developer plans](https://www.tinybird.co/blog-posts/md/why-we-created-new-pricing-for-developer-plans.md) - Last week, Tinybird deployed a new pricing model for Developer plans. Here's a deep dive into our reasoning behind the new pricing and how it helps developers ship faster. - Published: 2025-02-04 00:00:00 - [Outgrowing Postgres: How to run OLAP workloads on Postgres](https://www.tinybird.co/blog-posts/md/outgrowing-postgres-how-to-run-olap-workloads-on-postgres.md) - 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-posts/md/analyzing-dub-co-saas-analytics.md) - 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-posts/md/new-pricing-model-jan-2025.md) - Tinybird has updated its pricing to be more predictable and flexible. Learn what's new with Tinybird's pricing, and learn how to migrate to a new plan. - Published: 2025-01-29 00:00:00 - [Outgrowing Postgres: Handling increased user concurrency](https://www.tinybird.co/blog-posts/md/outgrowing-postgres-handling-increased-user-concurrency.md) - 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 its webhook Event Logs](https://www.tinybird.co/blog-posts/md/dub-webhooks-event-logs.md) - Dub recently released real-time webhooks. Dig into the code to learn how they store and surface event logs for millions of webhook events. - Published: 2025-01-23 00:00:00 - [Tinybird Local: Build with data on your machine](https://www.tinybird.co/blog-posts/md/tinybird-local-docker-container.md) - 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-posts/md/building-a-resend-analytics-dashboard.md) - Resend is a developer platform for sending transactional and marketing emails. If you don’t do much with email, well done, you’ve won in life. But if you do, Resend is probably going to save you a bunch of headaches. Once you’re set up to send with Resend, how do you know you’re “doing email right”? Resend captures events about the status of your emails - when it's sent, delivered, bounced, etc. - and offers webhooks so you can push these events elsewhere. Sending these webhooks to Tinybird’s E - Published: 2025-01-20 00:00:00 - [Outgrowing Postgres: Handling growing data volumes](https://www.tinybird.co/blog-posts/md/outgrowinghandling-growing-data-volumes.md) - Managing terabyte-scale data in Postgres? From basic maintenance to advanced techniques like partitioning and materialized views, learn how to scale your database effectively. Get practical advice on optimizing performance and knowing when it's time to explore other options. - Published: 2025-01-17 00:00:00 - [I rebuilt the Auth0 Activity Page with webhooks and Tinybird](https://www.tinybird.co/blog-posts/md/auth0-webhooks-tinybird-integration.md) - 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 - [How fast do you ship? Measure your deployment velocity with Vercel and Tinybird](https://www.tinybird.co/blog-posts/md/vercel-webhooks-and-tinybird-integration.md) - 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-posts/md/outgrowing-postgres-how-to-identify-scale-problems.md) - Discover early warning signs that you’ve outgrown PostgreSQL and learn how to keep performance high. This introductory article offers diagnostic techniques and proactive strategies to help you scale and plan the future of your analytics without losing momentum. - Published: 2025-01-10 00:00:00 - [Open observability in Tinybird with Prometheus endpoints](https://www.tinybird.co/blog-posts/md/tinybird-prometheus-endpoint-format.md) - Observability is a cornerstone of software development. The Prometheus format for Tinybird endpoints makes it easier to monitor your Tinybird resources from any o11y tool. - Published: 2024-12-20 00:00:00 - [How to analyze usage from your MCP Server](https://www.tinybird.co/blog-posts/md/analyze-mcp-server-usage.md) - Since Anthropic launched Model Context Protocol (MCP), thousands of developers have built MCP Servers to connect Claude AI to their unique contexts. Here's how to monitor your MCP Servers for errors and analyze usage with standard logging handlers, 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-posts/md/building-an-insights-page-for-your-saas.md) - I've helped so many people add an Insights page or dashboard to their app. Here are the steps to take your user-facing analytics from idea to prod. - Published: 2024-12-05 00:00:00 - [Building Real-Time Live Sports Viewer Analytics with Tinybird and AWS](https://www.tinybird.co/blog-posts/md/building-real-time-live-sports-viewer-analytics-with-tinybird-and-aws.md) - Ever tried to show millions of viewers real-time stats about how many other people like them are watching the same event? It's a bit like trying to count grains of sand while they're being poured into your bucket. Fun times! Let's look at how to build this without breaking the bank (or your sanity). The Challenge: Fan Engagement at Massive Scale Imagine you're streaming a major live event and want to show each viewer some engaging stats: * How many people in their state are watching? * How - Published: 2024-12-03 00:00:00 - [Hey Claude, help me analyze Bluesky data.](https://www.tinybird.co/blog-posts/md/claude-analyze-bluesky-data-tinybird-mcp-server.md) - This is the full, unedited transcript of our conversation with Claude, whose context-awareness is provided by a v0 Tinybird MCP Server. - Published: 2024-11-27 00:00:00 - [Application Architecture: Combining DynamoDB and Tinybird](https://www.tinybird.co/blog-posts/md/application-architecture-combining-dynamodb-and-tinybird.md) - Most applications tend to be built around a “transactional” core. Buy a thingamajig. Cancel a whoosiwatsie. Edit a whatchamacallit. You might be booking flights, posting bird pics on Insta, or patronizing the local Syrian restaurant for lunch (tabouleh, anyone?). While CRUD transactions are the foundation of applications, many are now are starting to offer (or see user demand for) analytical experiences: travellers want to see price change history to find the best time to fly, content creators w - Published: 2024-11-06 00:00:00 - [Query DynamoDB tables with SQL](https://www.tinybird.co/blog-posts/md/query-dynamodb-with-sql.md) - Want to aggregate, filter, or join DynamoDB tables with SQL? Here's how to do it, and why you should (and shouldn't) query DynamoDB tables with SQL. - Published: 2024-10-30 00:00:00 - [The Tinybird DynamoDB Connector is now GA](https://www.tinybird.co/blog-posts/md/dynamodb-connector-ga.md) - The Tinybird DynamoDB Connector is now GA and ready for production use in all Workspaces. Last month, the DynamoDB Connector hatched into public beta, and quickly broke the record for fastest adoption of a Connector launch yet. We knew DynamoDB was popular, but the reception was beyond what we expected! “Tinybird's DynamoDB Connector has proved to be easy to set up, reliable and low-latency, while providing cross partition queries, with unlimited indexing, at sub second speeds for our massive - Published: 2024-10-28 00:00:00 - [Simple patterns for aggregating on DynamoDB](https://www.tinybird.co/blog-posts/md/dynamodb-aggregation.md) - 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 - [From CDC to real-time analytics with Tinybird and Estuary](https://www.tinybird.co/blog-posts/md/cdc-real-time-analytics-estuary-dekaf.md) - 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-posts/md/dynamodb-public-beta.md) - Today we announce the Tinybird DynamoDB Connector in public beta, enabling those who use the popular AWS database to quickly ingest and sync their DynamoDB tables to Tinybird. The DynamoDB Connector is available in all Workspaces in AWS regions. - Published: 2024-09-20 00:00:00 - [Top Use Cases for DynamoDB in 2024](https://www.tinybird.co/blog-posts/md/dynamodb-use-cases.md) - DynamoDB… it's fast, scalable, and flexible. What's not to love? Here are the top use cases for DynamoDB in 2024 (and a few areas where it won't work). - Published: 2024-09-18 00:00:00 - [3 ways to run real-time analytics on AWS with DynamoDB](https://www.tinybird.co/blog-posts/md/dynamodb-real-time-analytics.md) - DynamoDB is a great database for real-time transactions, but it isn't suited for analytical queries or real-time analytics. Explore a few ways to build real-time analytics on data you already have in DynamoDB. - Published: 2024-09-11 00:00:00 - [Tinybird is now HIPAA compliant](https://www.tinybird.co/blog-posts/md/tinybird-hipaa-compliant.md) - Tinybird has achieved compliance with the Health Insurance Portability and Accountability Act (HIPAA). Learn more about our commitment to data privacy and security. - Published: 2024-09-03 00:00:00 - [Want a managed ClickHouse®️? Here are some options](https://www.tinybird.co/blog-posts/md/managed-clickhouse-options.md) - A managed ClickHouse service can speed up your development and reduce the infrastructure you need to set up and maintain. But what managed ClickHouse service should you choose? Here are your options. - Published: 2024-08-20 00:00:00 - [Tinybird vs. ClickHouse®️: What's the difference?](https://www.tinybird.co/blog-posts/md/tinybird-vs-clickhouse.md) - Tinybird is a real-time data platform for user-facing analytics, built using ClickHouse. Here are the differences between Tinybird and other ClickHouse solutions, including self-hosted and managed. - Published: 2024-08-13 00:00:00 - [Import Postgres tables into Tinybird with the PostgreSQL Table Function](https://www.tinybird.co/blog-posts/md/postgresql-table-function-announcement.md) - Today we announce the PostgreSQL Table Function, a powerful and flexible way to import and sync data from Postgres to Tinybird with just a few lines of SQL. - Published: 2024-07-29 00:00:00 - [Behind the scenes of Tinybird's big frontend refactor](https://www.tinybird.co/blog-posts/md/tinybird-frontend-refactor.md) - We recently refactored the Tinybird frontend. Take a look behind the scenes at how we started, the choices we made, and how we arrived at a faster and simpler app deployment. - Published: 2024-07-19 00:00:00 - [Best practices for timestamps and time zones in databases](https://www.tinybird.co/blog-posts/md/database-timestamps-timezones.md) - 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-posts/md/rate-limiting-announcement.md) - Today, we introduce Rate Limiting for Tinybird API Endpoints. With this new feature, you can limit how often your users can fetch Tinybird APIs on a per-endpoint or per-user basis. - Published: 2024-07-10 00:00:00 - [Multi-tenant analytics for SaaS applications](https://www.tinybird.co/blog-posts/md/multi-tenant-saas-options.md) - Customer-facing analytics becomes more challenging in multi-tenant environments. Learn strategies for building multi-tenant analytics in a secure and scalable way. - Published: 2024-07-03 00:00:00 - [Migrating from Rockset? See how Tinybird features compare](https://www.tinybird.co/blog-posts/md/migrating-from-rockset-feature-comparison.md) - This post will show you how Tinybird offers a natural migration path for user-facing analytics, applications and dashboards. It will cover what Tinybird is, how Rockset features map to Tinybird and what Tinybird uniquely offers. - Published: 2024-06-25 00:00:00 - [Jobs log: Improved o11y for background jobs](https://www.tinybird.co/blog-posts/md/jobs-log-launch.md) - Now it’s easier than ever to build production-level observability of your Tinybird data. - Published: 2024-06-20 00:00:00 - [$30M to lead the shift to real-time data](https://www.tinybird.co/blog-posts/md/announcing-tinybird-series-b.md) - 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-posts/md/announcing-tinybird-charts.md) - We’re excited to launch Tinybird Charts, functionality built-in to Tinybird to turn API Endpoints into real-time visualizations with just a few clicks. - Published: 2024-06-12 00:00:00 - [Tinybird is now available in AWS us-west-2](https://www.tinybird.co/blog-posts/md/tinybird-is-now-available-in-aws-us-west-2.md) - We’re excited to announce Tinybird availability in AWS US-West-2. Lower latency for customers deploying their applications on the US West Coast. - Published: 2024-06-10 00:00:00 - [Building real-time leaderboards with Tinybird](https://www.tinybird.co/blog-posts/md/building-real-time-leaderboards-with-tinybird.md) - Leaderboards aren’t just for games. In this post, you’ll learn how and why leaderboards can help you drive engagement in your app and how to build your first one quickly with Tinybird. - Published: 2024-06-06 00:00:00 - [Tinybird has joined the AWS ISV Accelerate Program](https://www.tinybird.co/blog-posts/md/tinybird-joins-aws-isv-accelerate.md) - We’re excited to be able to tap into AWS’s infrastructure and tools to deliver great real-time analytics solutions for our joint customers. - Published: 2024-06-05 00:00:00 - [JWTs for API Endpoints now in public beta!](https://www.tinybird.co/blog-posts/md/jwt-api-endpoints-public-beta.md) - We are launching JWTs for API Endpoints into public beta! With JWTs, you can call Tinybird APIs directly from within the browser, with no middleware or other backend components necessary. - Published: 2024-06-03 00:00:00 - [ClickHouse®️ JOINs... 100x faster](https://www.tinybird.co/blog-posts/md/clickhouse-joins-improvements.md) - 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-posts/md/user-facing-analytics.md) - User-facing analytics is the practice of embedding real-time data visualizations into user-facing applications. Learn more about user-facing analytics and how it's built in this definitive guide. - Published: 2024-04-23 00:00:00 - [We rebuilt our docs from scratch. It was worth it.](https://www.tinybird.co/blog-posts/md/new-docs.md) - Building modern docs begins with a modern tech stack. Here’s how we rebuilt our documentation and what it enables us to do for our customers. - Published: 2024-04-15 00:00:00 - [Real-Time Anomaly Detection: Use Cases and Code Examples](https://www.tinybird.co/blog-posts/md/real-time-anomaly-detection.md) - I've spent a decade developing anomaly detection systems. Here are some example code snippets you can use to inspire your real-time anomaly detection system. - Published: 2024-04-01 00:00:00 - [What is the best database for real-time analytics?](https://www.tinybird.co/blog-posts/md/best-database-for-real-time-analytics.md) - These are the 3 best databases for real-time analytics, and how to avoid challenges when deploying them. - Published: 2024-03-26 00:00:00 - [Export data from Tinybird to Amazon S3 with the S3 Sink](https://www.tinybird.co/blog-posts/md/s3-sink-launch.md) - 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-posts/md/clickhouse-schema-migration-while-streaming.md) - ClickHouse schema migrations can be challenging even on batch systems. But when you're streaming 100s of MB/s, it's a whole different beast. Here's how we make schema changes on a large ClickHouse table deployed across many clusters while streaming… without missing a bit. - Published: 2024-03-11 00:00:00 - [How to scale a real-time data platform](https://www.tinybird.co/blog-posts/md/how-tinybird-scales.md) - Tinybird is an enterprise-grade data platform with large customers processing huge amounts of data. Learn how we scale to support their use cases. - Published: 2024-02-16 00:00:00 - [8 example projects to master real-time data engineering](https://www.tinybird.co/blog-posts/md/real-time-data-engineering-example-projects.md) - 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-posts/md/tinybird-expands-self-service-to-amazon-web-services.md) - Starting today, our self-service customers can select Amazon Web Services as their deployment environment when creating a new Tinybird Workspace. Tinybird is already trusted by AWS customers, including FanDuel, Factorial, and Canva. - Published: 2023-11-28 00:00:00 - [Using Tinybird for real-time marketing at Tinybird](https://www.tinybird.co/blog-posts/md/tinybird-for-real-time-marketing.md) - 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-posts/md/python-real-time-dashboard.md) - 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-posts/md/what-is-a-columnar-database.md) - New to columnar databases? Read this article to learn what a columnar database is, when to use it, and popular examples of columnar databases. - Published: 2023-11-03 00:00:00 - [7 tips to make your dashboards faster](https://www.tinybird.co/blog-posts/md/7-tips-to-make-your-dashboards-faster.md) - 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-posts/md/clickhouse-lock-contention.md) - 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-posts/md/automating-data-workflows-with-git.md) - Data engineering should adopt proven software engineering principles in version control, CI/CD, and testing. Read how we're making that possible at Tinybird. - Published: 2023-10-23 00:00:00 - [Build a real-time dashboard over BigQuery](https://www.tinybird.co/blog-posts/md/bigquery-real-time-dashboard.md) - Struggling with slow or expensive dashboards over BigQuery data? Follow this tutorial to quickly build a real-time dashboard over BigQuery tables. - Published: 2023-10-20 00:00:00 - [We have released a stable version of the Tinybird CLI](https://www.tinybird.co/blog-posts/md/stable-cli-v-1-0-0.md) - 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?](https://www.tinybird.co/blog-posts/md/real-time-dashboards-are-they-worth-it.md) - Are dashboards outdated? Not if they help you make fast decisions, faster. Learn why real-time dashboards are still incredibly powerful today. - Published: 2023-10-13 00:00:00 - [How to query Google Sheets with SQL in real time](https://www.tinybird.co/blog-posts/md/query-google-sheets-with-sql-in-real-time.md) - 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-posts/md/event-sourcing-with-kafka.md) - Learn what event sourcing is, why Kafka works so well for event sourcing patterns, and how to implement event sourcing with Kafka and Tinybird. - Published: 2023-09-27 00:00:00 - [Iterate your real-time data pipelines with Git](https://www.tinybird.co/blog-posts/md/git-for-real-time-data-projects.md) - Today, we’re launching Versions, a safer, more collaborative way to work with Tinybird Data Projects. Read on to learn more about Versions and how it will change the way you work with real-time data. - Published: 2023-09-20 00:00:00 - [Why iterating real-time data pipelines is so hard](https://www.tinybird.co/blog-posts/md/why-iterating-real-time-data-pipelines-is-hard.md) - "Why can't we just use Git?" - Published: 2023-09-19 00:00:00 - [How to do Real-time Data Processing](https://www.tinybird.co/blog-posts/md/real-time-data-processing.md) - Real-time data processing is changing data analytics. Learn how to leverage real-time data processing techniques in your data stack. - Published: 2023-09-07 00:00:00 - [A step-by-step guide to build a real-time dashboard](https://www.tinybird.co/blog-posts/md/real-time-dashboard-step-by-step.md) - Want to build faster dashboards? Follow this tutorial to learn how to use Tinybird, Tremor, and Next.js to build fast, responsive dashboards for your application. - Published: 2023-09-05 00:00:00 - [Real-time Personalization: Choosing the right tools](https://www.tinybird.co/blog-posts/md/real-time-personalization.md) - Real-time personalization is the pathway to better user experiences. But it often feels like you must choose between complex DIY and expensive SaaS. Here's the happy middle path. - Published: 2023-08-25 00:00:00 - [A practical guide to real-time CDC with MySQL](https://www.tinybird.co/blog-posts/md/mysql-cdc.md) - 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: The Foundation for Real-time Analytics](https://www.tinybird.co/blog-posts/md/real-time-data-ingestion.md) - Real-time data ingestion is Step 1 for building real-time data pipelines. Read this guide to master real-time data ingestion and its underlying architecture. - Published: 2023-08-18 00:00:00 - [A practical guide to real-time CDC with Postgres](https://www.tinybird.co/blog-posts/md/postgres-cdc.md) - 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-posts/md/mongodb-cdc.md) - 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-posts/md/killing-the-processpoolexecutor.md) - 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-posts/md/real-time-change-data-capture.md) - Change Data Capture (CDC) is an important tool in real-time, event-driven architectures. Learn about CDC and its role in real-time data in this helpful overview. - Published: 2023-08-08 00:00:00 - [Real-time Data Visualization: How to build faster dashboards](https://www.tinybird.co/blog-posts/md/real-time-data-visualization.md) - Worried about slow dashboards? Don't blame your frontend. To build real-time data visualizations, focus on an effective data model using real-time data platforms. - Published: 2023-08-08 00:00:00 - [Tinybird: A ksqlDB alternative when stateful stream processing isn't enough](https://www.tinybird.co/blog-posts/md/ksqldb-alternative.md) - ksqlDB is a common stream processing choice for data engineers working in the Kafka ecosystem. Learn about ksqlDB and when to choose alternatives like Tinybird. - Published: 2023-07-27 00:00:00 - [Real-time data platforms: An introduction](https://www.tinybird.co/blog-posts/md/real-time-data-platforms.md) - Real-time data platforms combine streaming data ingestion, a real-time database, and a low-latency API layer. Get to know real-time data platforms in this informative introduction. - Published: 2023-07-27 00:00:00 - [What it takes to build a real-time recommendation system](https://www.tinybird.co/blog-posts/md/real-time-recommendation-system.md) - Real-time recommendation systems power a vast number of modern customer experiences. Learn what it takes to build a real-time recommender in this comprehensive guide. - Published: 2023-07-25 00:00:00 - [Real-time streaming data architectures that scale](https://www.tinybird.co/blog-posts/md/real-time-streaming-data-architectures-that-scale.md) - Data and engineering teams are turning to real-time data architectures to power revenue-generating data pipelines. This post provides a reference for building scalable streaming data architectures that can support multiple different use cases. - Published: 2023-07-21 00:00:00 - [Run analytics on files in Amazon S3 the easy way](https://www.tinybird.co/blog-posts/md/s3-analytics-the-easy-way-tinybird-connector.md) - So, you want to run analytics on data stored in S3 files? Here’s the easy way to do it, using the Tinybird S3 Connector. - Published: 2023-07-20 00:00:00 - [Tinybird connects with Confluent for real-time streaming analytics at scale](https://www.tinybird.co/blog-posts/md/tinybird-connect-with-confluent.md) - Today, Tinybird announces its partnership with Confluent. Read how to use Tinybird & Confluent to build powerful real-time analytics over streaming data. - Published: 2023-07-18 00:00:00 - [16 questions you need to ask about your Real-Time Data Strategy](https://www.tinybird.co/blog-posts/md/16-questions-real-time-data-strategy.md) - Considering a real-time data initiative? Answer these 16 questions and follow these recommendations to nail your real-time data strategy. - Published: 2023-07-13 00:00:00 - [Data-driven CI pipeline monitoring with pytest](https://www.tinybird.co/blog-posts/md/data-driven-ci-pipeline-monitoring-with-pytest.md) - Recently, we cut our CI pipeline execution time in half. To consummate our work, we've officially published the pytest plugin that made it possible, so you can use it, too. - Published: 2023-07-07 00:00:00 - [How to set up event-based ingestion of files in S3 for free](https://www.tinybird.co/blog-posts/md/how-to-set-up-event-based-ingestion-of-files-in-s3-for-free.md) - In this tutorial, I'll show you how to use S3 Event notifications and AWS Lambda to trigger downstream workflows when new files are uploaded to S3. - Published: 2023-06-30 00:00:00 - [Event-driven architecture best practices for databases and files](https://www.tinybird.co/blog-posts/md/event-driven-architecture-best-practices-for-databases-and-files.md) - Event-driven architectures should have largely replaced poll-based workflows and batch ETLs. Here are the common patterns (and anti-patterns) I have observed for event-driven ingestion of data from both application databases and file systems. - Published: 2023-06-29 00:00:00 - [Using Tinybird as a serverless online feature store](https://www.tinybird.co/blog-posts/md/using-tinybird-as-a-serverless-online-feature-store.md) - Machine learning can feel like a lot of hype, but feature stores are extraordinarily practical. In this post, I'll show you why Tinybird makes for an excellent online feature store for real-time inference and game-changing user experiences. - Published: 2023-06-27 00:00:00 - [Using Bloom filter indexes for real-time text search in ClickHouse®️](https://www.tinybird.co/blog-posts/md/using-bloom-filter-text-indexes-in-clickhouse.md) - A customer of ours had text-based log data and they wanted to be able to search over the text (quickly). However, in ClickHouse, text search without any special measures involves a full scan, period. And we know that full scans are not efficient. - Published: 2023-06-22 00:00:00 - [Designing and implementing a weather data API](https://www.tinybird.co/blog-posts/md/designing-and-implementing-a-weather-data-api.md) - When I first learned about Tinybird, its mission of helping developers build APIs caught my eye. I wondered what it would be like to design and implement a weather data API using Tinybird. In this post, I've documented my journey doing just that. - Published: 2023-06-20 00:00:00 - [A new way to create intermediate Data Sources in Tinybird](https://www.tinybird.co/blog-posts/md/announcing-copy-pipes.md) - We are pleased to announce the general availability release of Copy Pipes, a new way to generate snapshots of SQL results and store them in a Tinybird Data Source. - Published: 2023-06-15 00:00:00 - [5 criteria of data quality and how to test for them](https://www.tinybird.co/blog-posts/md/5-criteria-of-data-quality-and-how-to-test-for-them.md) - Data Quality Assurance is an important focus for companies seeking to advance the trustworthiness of their data pipelines. Here are 5 criteria for measurement data quality, and some sample SQL you can use to test for them. - Published: 2023-06-09 00:00:00 - [Adding JOIN support for parallel replicas on ClickHouse®️](https://www.tinybird.co/blog-posts/md/adding-join-support-for-parallel-replicas-on-clickhouse.md) - We recently introduced a pull request to ClickHouse that enables simple JOIN support for parallel replicas on ClickHouse. The solution may be simple and naive, but the ceiling for performance on distributed queries just got WAY higher. - Published: 2023-06-08 00:00:00 - [Why we just released a huge upgrade to our VS Code Extension](https://www.tinybird.co/blog-posts/md/tinybird-vs-code-extension-v100-announcement.md) - Tinybird is a powerful, performant real-time data platform. But we win the hearts of engineers through an amazing developer experience. Read how and why we recently upgraded our VS Code Extension for an even better DX. - Published: 2023-06-01 00:00:00 - [5 Snowflake struggles that every Data Engineer deals with](https://www.tinybird.co/blog-posts/md/5-snowflake-struggles-that-every-data-engineer-deals-with.md) - Snowflake is the world’s leading cloud data warehouse, but it is almost always slow and costly for application development. Tinybird makes it easy to quickly and cost-effectively build applications on top of your Snowflake data. Tinybird and Snowflake are better together. - Published: 2023-05-18 00:00:00 - [Using custom Kafka headers for advanced message processing](https://www.tinybird.co/blog-posts/md/using-custom-kafka-headers.md) - Kafka headers are key-value pairs that can be attached to Kafka messages to provide metadata and additional information about the message. Read on to learn more about the use cases headers support and how to build real-time analytics pipelines using Kafka headers. - Published: 2023-05-16 00:00:00 - [The 8 considerations for designing public data APIs](https://www.tinybird.co/blog-posts/md/8-considerations-for-designing-public-data-apis.md) - For years I developed flood warning systems built on public data APIs. From my experience, I learned that there are 8 things you must consider to build a resilient public data API. These are those 8 things, and how Tinybird can take some of them off your plate. - Published: 2023-05-15 00:00:00 - [Upgrading short link analytics by 100x with Steven Tey](https://www.tinybird.co/blog-posts/md/upgrading-short-link-analytics-by-100x-with-steven-tey.md) - We sat down with Steven Tey, Senior Developer Advocate at Vercel and creator of Dub.co, to talk about why switched Dub's analytics from Redis Sorted Sets to Tinybird. - Published: 2023-05-12 00:00:00 - [Building privacy-first native app telemetry with Guilherme Oenning](https://www.tinybird.co/blog-posts/md/dev-qa-guilherme-oenning.md) - Guilherme Oenning left his job to create Aptabase, a platform for mobile and desktop app developers to build telemetry and analytics using simple SDKs. We sat down with Guilherme to talk about building Aptabase and why he chose Tinybird over Postgres, BigQuery, and ClickHouse Cloud. - Published: 2023-05-11 00:00:00 - [How to build a real-time fraud detection system](https://www.tinybird.co/blog-posts/md/how-to-build-a-real-time-fraud-detection-system.md) - Digital fraud affects so many organizations. In this blog post, you'll learn the components of a real-time fraud detection system, and how to build one with Tinybird. - Published: 2023-05-09 00:00:00 - [The 5 rules for writing faster SQL queries](https://www.tinybird.co/blog-posts/md/5-rules-for-writing-faster-sql-queries.md) - If you're building real-time analytics, you need your SQL to be fast. Fast SQL queries improve performance and reduce cost. Here are the 5 rules to follow to write the fastest SQL queries of your life. - Published: 2023-05-08 00:00:00 - [Low-code analytics with James Devonport of UserLoop](https://www.tinybird.co/blog-posts/md/low-code-analytics-with-james-devonport-of-userloop.md) - James Devonport chose to build UserLoop on a no-code platform so he could quickly respond to customer feedback. Read how he found and implemented Tinybird on his journey to building the number one eCommerce customer intelligence software. - Published: 2023-05-05 00:00:00 - [Automating customer usage alerts with Tinybird and Make](https://www.tinybird.co/blog-posts/md/automating-customer-usage-alerts-with-tinybird-and-make.md) - 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 we're using to reduce cloud infrastructure costs in 2023](https://www.tinybird.co/blog-posts/md/7-strategies-for-reducing-cloud-infrastructure-costs-in-2023.md) - Cloud infrastructure costs are going up for everyone, but expectations to perform haven't receded. Here are 7 strategies that we use at Tinybird to keep our costs low as we innovate new ways to help our customers achieve more with less. - Published: 2023-04-27 00:00:00 - [Real-time Databases: What developers need to know](https://www.tinybird.co/blog-posts/md/real-time-databases-what-developers-need-to-know.md) - Explore the key factors in choosing a real-time database and compare MongoDB, PostgreSQL, Tinybird, ClickHouse, Snowflake, Pinot, and Druid to determine the best fit for your application's performance, scalability, and analytics needs. - Published: 2023-04-25 00:00:00 - [Chatting GraphQL with Jamie Barton of Grafbase](https://www.tinybird.co/blog-posts/md/chatting-graphql-with-jamie-barton-of-grafbase.md) - We sit down with Jamie Barton of Grafbase to talk about building a serverless platform to help developers build GraphQL backends, and how Tinybird has multiplied their development speed while supporting all their data integration needs. - Published: 2023-04-24 00:00:00 - [Generate mock data schemas with GPT](https://www.tinybird.co/blog-posts/md/generate-mock-data-schemas-with-gpt.md) - Today, we announce the release of our in-product, AI-powered demo data generator. Building off our recent release of Mockingbird, Tinybird now makes it possible to generate mock data schemas based on GPT prompts. Write your first mock data prompt today in the Tinybird UI. - Published: 2023-04-21 00:00:00 - [A free and open source mock data generator for your next data project](https://www.tinybird.co/blog-posts/md/mockingbird-announcement-mock-data-generator.md) - Mockingbird is a powerful and flexible mock streaming data generator for all of your data projects. With Mockingbird, you can define a data schema and stream mock data to Tinybird and external destinations. Use the headless library, CLI, or UI to generate data streams for any application. - Published: 2023-04-20 00:00:00 - [Building real-time solutions with Snowflake at a fraction of the cost](https://www.tinybird.co/blog-posts/md/real-time-solutions-with-snowflake.md) - Snowflake is not optimized for real-time use cases. Integrate your Snowflake datasets with Tinybird to build low-latency, high-concurrency APIs over Snowflake data. - Published: 2023-04-19 00:00:00 - [The power of real-time streaming analytics with Confluent and Tinybird](https://www.tinybird.co/blog-posts/md/real-time-streaming-analytics-confluent-connector-tinybird.md) - Today, Tinybird is excited to announce the launch of our new Confluent Connector, offering Confluent users the ability to stream their data into Tinybird in real time. With today’s announcement, Confluent users have a new way to query their streaming data and build fast APIs, faster. - Published: 2023-04-18 00:00:00 - [Tinyshop: Get Tinybird swag delivered to your doorstep](https://www.tinybird.co/blog-posts/md/tinybird-swag-store-announcement.md) - Introducing Tinyshop, a less awkward and more environmentally-friendly way to share the Tinybird love. Get custom-designed Tinybird swag delivered straight to your door, starting today. - Published: 2023-04-17 00:00:00 - [Building a faster CI pipeline with Turborepo and pnpm](https://www.tinybird.co/blog-posts/md/frontend-ci-monorepo-turborepo-pnpm.md) - 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-posts/md/dev-qa-global-api-latency-chronark.md) - We sit down with chronark, creator of Planetfall.io, to talk about global API latency monitoring, time series analytics, usage-based billing, and why being an "SQL noob" can't stop you from making something amazing with Tinybird. - Published: 2023-03-30 00:00:00 - [Developer Q&A with JR the Builder, co-creator of Beam Analytics](https://www.tinybird.co/blog-posts/md/qa-with-jr-the-builder-beam-analytics.md) - We chat with JR the Builder, 3x indie hacker and recent co-creator of Beam Analytics, about building the cheapest GDPR-compliant web analytics platform, scaling to the whole internet, and launching fast with Tinybird. - Published: 2023-03-24 00:00:00 - [Data-Driven Talk: Build fast APIs, faster, over data at scale](https://www.tinybird.co/blog-posts/md/ddnyc-talk-fast-apis-faster-at-scale.md) - Tinybird helps developers and data engineers build fast APIs, faster, over streaming data at scale. This is a partial transcript from a talk given by Jorge Gomez Sancha, Co-Founder and CEO of Tinybird, at Data Driven NYC ‘23. - Published: 2023-03-23 00:00:00 - [Real-Time Analytics: Examples, Use Cases, Tools & FAQs](https://www.tinybird.co/blog-posts/md/real-time-analytics-a-definitive-guide.md) - Real-time data analytics can be a powerful differentiator for businesses. But how should you approach it to maximize output and keep costs in check? Get answers to these questions - and many more - in this definitive guide. - Published: 2023-03-17 00:00:00 - [Build fast charts faster with the Tinybird Grafana plugin](https://www.tinybird.co/blog-posts/md/tinybird-grafana-plugin-launch.md) - Grafana is the observability tool of choice for Platform teams, so why settle for slow dashboards? Today, we announce the release of the Tinybird plugin for Grafana, so you can build fast charts, faster. - Published: 2023-03-04 00:00:00 - [Build serverless real-time analytics on Vercel with Tinybird](https://www.tinybird.co/blog-posts/md/serverless-realtime-analytics-vercel-marketplace.md) - What do Tinybird and Vercel have in common? A lot, as it turns out. Today, we announce the new Tinybird Integration available in the Vercel Integration Marketplace. Use it to sync your Tinybird Workspaces with your Vercel projects to build the real-time, serverless analytics you've always wanted. - Published: 2023-03-03 00:00:00 - [Simplifying event sourcing with scheduled data snapshots in Tinybird](https://www.tinybird.co/blog-posts/md/scheduled-copy-api-launch.md) - Tinybird has always made it possible to ingest relentless streams of data, query and shape them using SQL, and publish them as high-concurrency, low-latency APIs for use in your applications. - Published: 2023-03-02 00:00:00 - [Building an enterprise-grade real-time analytics platform](https://www.tinybird.co/blog-posts/md/enterprise-grade-real-time-analytics.md) - Tinybird is an enterprise-grade real-time analytics platform trusted by businesses of all sizes. Today, we are excited to announce Tinybird Organizations, a new feature for enterprise customers to monitor usage on multiple Workspaces and manage their projects across Tinybird in a single dashboard. - Published: 2023-03-01 00:00:00 - [Transforming real-time applications with Tinybird and Google BigQuery](https://www.tinybird.co/blog-posts/md/real-time-applications-with-bigquery-connector.md) - Today, Tinybird is excited to announce the launch of our new Google BigQuery Connector, offering Google BigQuery users an easy and reliable method to bring their data to Tinybird where they can query and shape it using SQL and publish it as low-latency APIs to be consumed by their applications. - Published: 2023-02-28 00:00:00 - [More Data, More Apps: Improving data ingestion in Tinybird](https://www.tinybird.co/blog-posts/md/more-data-more-apps.md) - Building with Tinybird all starts with data ingestion, so we're focused on making it even better. Read on for updates to our ingestion experience, plus examples of how Tinybird customers ingest, query, and publish with Tinybird. - Published: 2023-02-21 00:00:00 - [How we cut our CI pipeline execution time in half](https://www.tinybird.co/blog-posts/md/better-ci-pipeline-with-data.md) - Our GitLab CI pipeline was slow and flaky. Here’s how we used telemetry data, real-time analytics, and smart k8s configuration to fix it. - Published: 2023-02-17 00:00:00 - [Log Analytics: how to identify trends and correlations that Log Analysis tools cannot](https://www.tinybird.co/blog-posts/md/log-analytics-how-to-identify-trends-and-correlations-that-log-analysis-tools-cannot.md) - Introducing the Tinybird Log Analytics Starter Kit. It’s an open-source template to help you take your Log Analysis to the next level using analytics that help you examine your software logs to identify trends, patterns, and more. It’s free and available today. - Published: 2023-02-01 00:00:00 - [Horizontally scaling Kafka consumers with rendezvous hashing](https://www.tinybird.co/blog-posts/md/kafka-horizontal-scaling.md) - How we used rendezvous hashing to horizontally scale Kafka consumers to support hundreds of concurrent topics with fewer connections, thus lowering our infrastructure costs. - Published: 2023-01-25 00:00:00 - [The top emojis on Twitter for every hour of 2022](https://www.tinybird.co/blog-posts/md/top-emojis-of-2022.md) - I've been streaming 100 tweets/sec since the beginning of the year and using Tinybird to analyze and publish the top emoji for every hour of 2022. See what events you can find in these 8,760 emojis. - Published: 2022-12-31 00:00:00 - [Tinybird is SOC 2 Type II compliant](https://www.tinybird.co/blog-posts/md/tinybird-is-soc-2-type-ii.md) - Trust is earned, not given, and we're proud to have achieved this important certification to celebrate the trust we’ve earned from our customers. - Published: 2022-12-19 00:00:00 - [Measuring World Cup sentiment with Twitter and Tinybird](https://www.tinybird.co/blog-posts/md/world-cup-sentiment.md) - 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-posts/md/why-data-warehouses.md) - 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-posts/md/comparing-tinybird-to-aws-kinesis-s3-glue-and-athena.md) - Amazon S3, Kinesis, Glue, and Athena are often used for strategic data analysis. Learn how Tinybird fits in the AWS stack for real-time, operational analytics. - Published: 2022-10-26 00:00:00 - [Introducing a redesigned Tinybird UI for better developer productivity](https://www.tinybird.co/blog-posts/md/redesigned-tinybird-ui-developer-productivity.md) - At its core, Tinybird is a platform for developer productivity. Today, we’re releasing an updated UI experience so you can explore Data Sources and create Pipes with fewer clicks. - Published: 2022-10-20 00:00:00 - [When you should use columnar databases and not Postgres, MySQL, or MongoDB](https://www.tinybird.co/blog-posts/md/when-to-use-columnar-database.md) - Row-oriented, OLTP databases aren't ideal application DBs when you know you'll need to run analytics on lots of data. Choose a column-oriented OLAP instead. - Published: 2022-10-17 00:00:00 - [We launched an open source ClickHouse Knowledge Base](https://www.tinybird.co/blog-posts/md/we-launched-an-open-source-clickhouse-knowledge-base.md) - 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-posts/md/the-data-journey.md) - We're all in the middle of a multi-step process to consolidate, model, and operationalize our data. Here's where we're getting stuck, and what to do about it. - Published: 2022-10-06 00:00:00 - [You can now explore and analyze time series data in Tinybird](https://www.tinybird.co/blog-posts/md/announcing-time-series.md) - 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 - [Looking for an open source Google Analytics alternative? Set one up in 3 minutes.](https://www.tinybird.co/blog-posts/md/google-analytics-alternative-in-3-minutes.md) - 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 rapidly built an affordable session replay tool with Tinybird](https://www.tinybird.co/blog-posts/md/session-rewind-affordable-session-replay-with-tinybird.md) - 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-posts/md/how-i-replaced-google-analytics-with-retool-and-tinybird-part-2.md) - 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-posts/md/improved-notifications-ingestion-issues.md) - A little boost to ingestion observability in Tinybird. - Published: 2022-08-26 00:00:00 - [How an eCommerce giant replaced Google Analytics for privacy and speed](https://www.tinybird.co/blog-posts/md/ecommerce-google-analytics-alternative.md) - 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-posts/md/how-i-replaced-google-analytics-with-retool-and-tinybird-part-1.md) - 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-posts/md/privacy-first-google-analytics-alternative.md) - 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-posts/md/what-is-a-data-product.md) - 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-posts/md/definition-of-real-time-data.md) - 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-posts/md/text-search-at-scale-with-clickhouse.md) - 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-posts/md/data-rules-materialized-views-40000-dollars.md) - 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-posts/md/to-the-limits-of-sql-api-parameters.md) - 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-posts/md/soc-2-enterprise-authentication-announcement.md) - 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-posts/md/use-aws-sns-to-send-data-to-tinybird.md) - 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-posts/md/usage-based-pricing-should-you-build-or-buy.md) - 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-posts/md/how-we-recreated-r-place-with-10-lines-of-sql.md) - 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-posts/md/data-market-whitebox-replaces-4-data-stack-tools-with-tinybird.md) - 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-posts/md/thinking-in-tinybird.md) - The best way to build a data project in Tinybird is to work backwards - Published: 2022-06-17 00:00:00 - [The hard parts of building data systems with high concurrency](https://www.tinybird.co/blog-posts/md/the-hard-parts-of-building-massive-data-systems-with-high-concurrency.md) - 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-posts/md/i-built-a-tinybird-syntax-highlighter-for-vscode.md) - 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-posts/md/how-to-monitor-tinybird-using-datadog-with-vector-dev.md) - 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-posts/md/what-are-materialized-views-and-why-do-they-matter-for-realtime.md) - 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-posts/md/roll-up-data-with-materialized-views.md) - 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 - [You can now see how much data your endpoints scan in real-time](https://www.tinybird.co/blog-posts/md/see-how-much-data-your-endpoints-scan-in-real-time.md) - 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-posts/md/you-can-now-create-materialized-views-in-the-tinybird-ui.md) - Creating faster 1-click endpoints with Tinybird just became easier. - Published: 2022-05-20 00:00:00 - [How Typeform Built a Fully Functional User Dash With Tinybird](https://www.tinybird.co/blog-posts/md/typeform-utm-realtime-analytics.md) - 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-posts/md/clickhouse-query-optimization.md) - 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-posts/md/looking-ahead-to-kafka-summit-22.md) - 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-posts/md/tinybird-series-a-whats-next.md) - 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-posts/md/self-serve.md) - 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-posts/md/executives.md) - 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-posts/md/analysis-twitter-streaming.md) - 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-posts/md/rearrange-nodes-in-pipe.md) - 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-posts/md/add-data-from-csvs-with-different-column-orders.md) - 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-posts/md/spatial-indexing-aids-finding-which-polygons-contain-a-point.md) - 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-posts/md/kafka-to-api-endpoints.md) - 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-posts/md/service-data-sources-and-retool.md) - 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-posts/md/the-era-of-json-analytics.md) - 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-posts/md/simd.md) - 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-posts/md/kafka-performance-and-compression.md) - 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-posts/md/sql-and-python.md) - 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-posts/md/tips-12-how-to-apply-a-function-into-multiple-col-1call.md) - 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-posts/md/tips-11-how-to-get-the-types-returned-by-a-query.md) - 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-posts/md/new-feature-sharing-data-sources-across-workspaces.md) - From now on, Data Sources can be shared in a read-only way across multiple workspaces. Maintaining only one ingestion process, data can be made available for... - Published: 2021-08-04 00:00:00 - [ClickHouse tips #10: Null behavior with LowCardinality columns](https://www.tinybird.co/blog-posts/md/tips-10-null-behavior-with-lowcardinality-columns.md) - Does it work? What's actually inserted? Part 10. - Published: 2021-07-21 00:00:00 - [Experimental ClickHouse: Projections](https://www.tinybird.co/blog-posts/md/projections.md) - ClickHouse tags a major release around once a month, which is an order of magnitude more often than similar projects, and it does it while maintaining speed and stability. - Published: 2021-07-09 00:00:00 - [ClickHouse tips #9: Filling gaps in time-series on ClickHouse](https://www.tinybird.co/blog-posts/md/tips-9-filling-gaps-in-time-series-on-clickhouse.md) - 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-posts/md/starting-with-kafka.md) - I just want to share my thoughts on Kafka after using it for a few months, always from a practical point of view. I don’t know anything more than the basics ... - Published: 2021-06-25 00:00:00 - [Simple statistics for anomaly detection on time-series data](https://www.tinybird.co/blog-posts/md/anomaly-detection.md) - 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-posts/md/adapt-postgres-queries-to-tinybird.md) - Learn how to adapt your Postgres queries to run on Tinybird. This post shows you how to convert common Postgres operations like CTEs, data generation, joins, and statistical functions to their Tinybird equivalents. - Published: 2021-06-21 00:00:00 - [ClickHouse tips #8: Generating time-series on ClickHouse](https://www.tinybird.co/blog-posts/md/tips-8-generating-time-series-on-clickhouse.md) - 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-posts/md/analyzing-artists-streams-in-real-time-with-tinybird.md) - It's possible to ingest millions of events per minute to Tinybird via Kafka, and exploit them through real-time data products. Here is a good example of a simple data product that analyzes millions of music streams across different platforms. - Published: 2021-05-27 00:00:00 - [New feature: add column to a Data Source](https://www.tinybird.co/blog-posts/md/add-column.md) - 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-posts/md/tips-7-filling-null-values-on-clickhouse.md) - 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-posts/md/analyzing-nginx-logs-with-clickhouse-and-tinybird.md) - 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-posts/md/tips-6-faster-joins-without-joining-using-where.md) - Sometimes you can replace joins on ClickHouse using where clauses, having the same performance as with Join engines. Learn how here. Part 6. - Published: 2021-04-23 00:00:00 - [Visualize your Data Sources and Pipes dependencies on Tinybird](https://www.tinybird.co/blog-posts/md/data-lineage-graph.md) - 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-posts/md/tips-5-adding-and-subtracting-intervals.md) - 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-posts/md/coming-soon-on-clickhouse-window-functions.md) - An exploration on what's possible to do with the most recent experimental feature on ClickHouse - window functions, and an overview of other interesting features to come. - Published: 2021-03-16 00:00:00 - [ClickHouse Tips #4: Materializing UNION ALL queries](https://www.tinybird.co/blog-posts/md/clickhouse-tips-4-materializing-union-all-queries-using-simpleaggregatefunction-and-grouparrayarray-function.md) - Learn how to materialize queries on ClickHouse when there are UNION ALL operations involved, and when you can use SimpleAggregateFunction instead of AggregateFunction. Part 4. - Published: 2021-03-07 00:00:00 - [DataOps: How to Develop and Scale Data Intensive Projects](https://www.tinybird.co/blog-posts/md/dataops.md) - As we build Tinybird, we work hand in hand with many data and engineering teams. In the process we are discovering new ways to develop, maintain and scale da... - Published: 2021-02-27 00:00:00 - [DataOps: 10 principles to develop data intensive projects](https://www.tinybird.co/blog-posts/md/dataops-principles.md) - 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-posts/md/tips-3-transform.md) - 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-posts/md/tinybird-clickhouse.md) - We are hiring full-time Clickhouse Developers. Find out why we contribute to Open Source (ClickHouse) and why we want to contribute much more. - Published: 2021-02-16 00:00:00 - [Build real-time analytics APIs collaboratively using Tinybird](https://www.tinybird.co/blog-posts/md/workspaces.md) - We’ve recently implemented workspaces so Tinybird users can work with other developers and data engineers and collaborate in their real-time analytics projects. - Published: 2021-02-11 00:00:00 - [ClickHouse tips #2: Debugging ClickHouse on Visual Studio Code](https://www.tinybird.co/blog-posts/md/tinybird-tips-debugging-clickhouse-on-vscode.md) - 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-posts/md/nginx-log-analysis.md) - 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-posts/md/real-time-analytics-bigquery-dataflow.md) - BigQuery is not designed (or priced) to withstand hundreds of requests per second. Here is how you can add Tinybird to the mix to productise that data. - Published: 2021-01-28 00:00:00 - [Clickhouse Tips #1: Calculating Aggregations After a Given Date](https://www.tinybird.co/blog-posts/md/tinybird-tips-1-calculating-aggregations-after-and-before-a-date.md) - 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-posts/md/tech-product-design-how-we-integrate-with-git.md) - 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-posts/md/query-csvs-online-with-sql.md) - 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-posts/md/gain-visibility-of-async-ops-with-the-jobs-api.md) - 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-posts/md/how-we-setup-real-time-analytics-service-to-process-12-trillion-rows-during-black-friday.md) - 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-posts/md/eating-our-own-dog-food-how-we-investigate-performance-bottlenecks-using-our-product-and-google-sheets.md) - How to correlate API endpoint parameters and response times with Tinybird to find performance bottlenecks. And how to visualize and prioritize them with Google Sheets. - Published: 2020-12-15 00:00:00 - [Selective data deletion: a new feature for data quality management](https://www.tinybird.co/blog-posts/md/selective-data-deletion.md) - Selective data deletion lets you delete rows of a Tinybird datasource that match a specified delete condition. This is important for an API-first platform. - Published: 2020-08-27 00:00:00 - [Operational Analytics. Data Insights Are Great](https://www.tinybird.co/blog-posts/md/operational-analytics.md) - Traditional data warehouses are well suited for putting data together and enabling BI teams to do data exploration and analysis, but they are not a great sol... - Published: 2020-08-26 00:00:00 - [Improving the data ingestion experience: better error feedback](https://www.tinybird.co/blog-posts/md/ingestion-improvements.md) - Identifying errors when ingesting Terabytes of data can be like finding a needle in a haystack. We have improved our ingestion process to make it easier to troubleshoot ingestion problems, even if you are ingesting billions of rows. - Published: 2020-08-19 00:00:00 - [Analytics API endpoints for your developers](https://www.tinybird.co/blog-posts/md/badass-api-endpoint.md) - At Tinybird, we have put a lot of effort in ensuring that building API endpoints against large quantities of Data is as simple as possible. - Published: 2020-08-11 00:00:00 - [A new dashboard for Tinybird Analytics](https://www.tinybird.co/blog-posts/md/new-dashboard.md) - A key part of running an effective Analytics Platform within an organization is being able to keep a tight control over usage and performance, ingestion jobs... - Published: 2020-05-07 00:00:00 - [Introducing the Data Operations Log](https://www.tinybird.co/blog-posts/md/data-operations-log.md) - Problems with data ingestion are common: some data may be missing, or maybe it is in the wrong format or has the wrong encoding… it happens. - Published: 2020-04-20 00:00:00 - [Dynamic API reponses based on endpoint parameters](https://www.tinybird.co/blog-posts/md/create-a-dynamic-api.md) - 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-posts/md/share-pipes.md) - 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-posts/md/enriching-kafka-streams-in-real-time.md) - If you are using Kafka to capture large quantities of events or transactional data, you are probably also looking for ways to enrich that data in real-time. Here is how to do it with Tinybird. - Published: 2020-03-19 00:00:00 - [Create a Static Application to Analyze +50M Github Events](https://www.tinybird.co/blog-posts/md/create-analytic-static-applications.md) - Creating applications just using HTML, javascript and CSS is easier than ever with new frameworks and platforms like Zeit. Let see how to create a simple analytics application that queries 50M rows in real time without backend. - Published: 2020-03-11 00:00:00 - [How We Handle Technical Incidents and Service Disruptions](https://www.tinybird.co/blog-posts/md/how-we-handle-service-disruptions.md) - Part of providing an outstanding level of service is to react quickly and professionally when things go wrong. This is an account of a recent service disruption and how we handled it. - Published: 2020-01-09 00:00:00 - [Tinybird Changelog: New User Experience for Data Exploration](https://www.tinybird.co/blog-posts/md/redesigned-data-pipe-ui.md) - 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-posts/md/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold.md) - What do you do when your transactions table in Postgres has grown way too big to handle analytical queries? How do you answer business questions when it could take minutes to even get a `SELECT count(*) FROM transactions` going? - Published: 2019-10-14 00:00:00 - [Real-time analytics API at scale with billions of rows](https://www.tinybird.co/blog-posts/md/real-time-analytics-with-billion-rows-at-scale.md) - 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-posts/md/south-summit-madrid-2019.md) - We will be demoing Tinybird Analytics thanks to Google for Startups at South Summit Madrid, one of the best places to connect with other technology startups. - Published: 2019-09-26 00:00:00 - [Improved Support for Replacing or Appending Data](https://www.tinybird.co/blog-posts/md/replace-and-append.md) - 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-posts/md/our-focus-on-speed.md) - There is no good way to uncover new insights underlying terabytes of data unless you make the process of working with it tremendously rewarding and fast. - Published: 2019-08-08 00:00:00 - [Learnings and results of our first User Testing sessions](https://www.tinybird.co/blog-posts/md/user-testing.md) - 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-posts/md/closed-beta.md) - Working with large amounts of data is challenging, but we believe it should not be complex. Everybody is waking up to data and its possibilities. We constant... - Published: 2019-06-28 00:00:00 - [Tinybird Changelog: Faster CSV Imports](https://www.tinybird.co/blog-posts/md/faster-csv-import-and-auth-tokens-with-filters.md) - 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-posts/md/clickhouse-meetup-madrid-videos.md) - 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-posts/md/simple-time-series-prediction.md) - Time series predictions are one of the most common use cases you can find. Predicting the future, enables you to get ready for it (and act accordingly). - Published: 2019-04-21 00:00:00 - [Typical Challenges of Building Your Data Layer](https://www.tinybird.co/blog-posts/md/data-journey.md) - When you start a digital product you usually put your data in a database. It does not matter if it is a simple text file, an excel spreadsheet or a managed Postgres instance on the cloud, your data always lives somewhere. - Published: 2019-04-15 00:00:00