a curated list of database news from authoritative sources

May 11, 2023

Building privacy-first native app telemetry with Guilherme Oenning

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.

May 09, 2023

Backward compatible database changes

Learn about safely using the expand, migrate, and contract pattern to make database schema changes without downtime and data loss.

How to build a real-time fraud detection system

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.

May 08, 2023

End-to-end TypeScript with Convex

Convex provides automatic type safety all the way from your database schema to your React app. How does it work? Hint: we use some wild TypeScript.

The 5 rules for writing faster SQL queries

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.

Backup & Restore Performance

The performance of backups and restores is a business requirement for Vitess users and an ongoing concern for Vitess maintainers. For sufficiently large databases, if we can't take backups fast enough, we risk missing daily SLAs in a production context. In the event we need to perform an emergency restore, it is paramount that we can do so as fast as possible. The performance of backups and restores is driven by a number of factors:

The 5 rules for writing faster SQL queries

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.

May 07, 2023

How to Learn: Philosophy of How to Learn

The background and context on why the groupings exist the way they do, and thedifferent sorts of pages you’ll find in this section. But, this is allphilosophical waxing, so quite skippable.

May 05, 2023

Intro to Migrations

There are as many ways to migrate data as there are databases, but here’s some basic information to set the stage.

Low-code analytics with James Devonport of UserLoop

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.

May 04, 2023

Why isn’t MySQL using my index?

There are several reasons why MySQL might not consider your index, and in this article we’ll explore some of the most common ones.