Database branching: three-way merge for schema changes
Learn how PlanetScale uses Git-like three-way diff to resolve schema change conflicts across database branches.
April 26, 2023
The Part of PostgreSQL We Hate the Most
As much as Andy loves PostgreSQL, there is one part that is terrible and causes many headaches for people. Learn what it is and why it sucks.
April 25, 2023
Real-time Databases: What developers need to know
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.
April 24, 2023
Launch Week 7 Hackathon Winners
Announcing the winners of the Launch Week 7 Hackathon!
Chatting GraphQL with Jamie Barton of Grafbase
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.
schemadiff: Vitess In-memory Schema Diffing, Normalization, Validation and Manipulation
Introducing schemadiff, an internal library in Vitess that has been one of its best-kept secrets until now. At its core, schemadiff is a declarative, programmatic library that can produce a diff in SQL format of two entities: tables, views, or full blown database schemas. But it then goes beyond that to normalize, validate, export, and even apply schema changes, all declaratively and without having to use a MySQL server. Let's dive in to understand its functionality and capabilities.
April 21, 2023
What's New in pg_graphql v1.2
New Features in the v1.2 release of pg_graphql
Generate mock data schemas with GPT
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.
April 20, 2023
Errata in Hekaton MVCC paper
Hekaton MVCC Paper contains a publication error. After reviewing the paper, I confirmed the error with one of the authors. This blog post explains the mistake, the implications and the fix.
Internet is wholesome: MVCC edition
This is a short story about how I hit a wall while implementing a database research paper, found a publication error and how people on the internet helped me.
Query performance analysis with Insights
You can now use Insights to view time-series performance data on a per-query pattern basis.
MySQL for application developers
Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples.
A free and open source mock data generator for your next data project
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.
April 19, 2023
Building real-time solutions with Snowflake at a fraction of the cost
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.
April 18, 2023
Pagination in MySQL
An overview of the different ways to paginate in MySQL including limit/offset pagination and cursor pagination plus the pros and cons of each.
The power of real-time streaming analytics with Confluent and Tinybird
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.