2 years ago

Can your database do this? Ep 3: Zero-downtime, type-safe migrations

Convex's migrations component makes it easy and safe to run complex database migrations without causing any interruption to live traffic.

In this video, Jamie Turner walks through a migration on his "Fancy Movie Database" project. Fancy roman numerals were added to fancy movie copyrights effortlessly!

All gas, no breakages

Convex is the reactive backend platform that keeps up with you and your agents. Database, functions, workflow, sync, search, file storage, and more. All TypeScript, zero glue.

Get started

Patterns

Join the Convex Community

Ask the team questions, learn from others, and stay up-to-date on the latest with Convex.

Join the Discord community

Share this video

Read next

Translate SQL into Convex Queries

Here’s a cheatsheet with examples of conversions between SQL queries and Convex queries. This article is geared towards developers (and LLMs) who have familiarity with SQL and want to translate those familiar patterns into Convex queries. You'll learn how to `UNION`, `JOIN`, `DISTINCT`, do `WHERE` clauses, and `SELECT` fields.

Lee Danilek

Optimize Transaction Throughput: 3 Patterns for Scaling with Convex and ACID Databases

Explore techniques to improve transaction throughput and concurrency in ACID databases by reducing conflicts and optimizing database reads. This guide covers patterns like Queue, Hot and Cold Tables, and Predicate Locking with clear examples using Convex, providing developers with tools to handle high-throughput workflows effectively.

Lee Danilek

CRUD APIs: Functional, but Inefficient

The term CRUD, or CRUD API, is often tossed around when interacting with databases or building backend APIs. This article will examine what CRUD is, what it’s suitable for, and its shortcomings. Finally, we’ll explore how to quickly implement a CRUD API using a modern backend like Convex.

Jamie Turner