Home / Companies / Cockroach Labs / Blog / Post Details
Content Deep Dive

How to Update Your Database Schema With No Downtime

Blog post from Cockroach Labs

Post Details
Company
Date Published
Author
Charlie Custer
Word Count
1,897
Language
English
Hacker News Points
-
Summary

This article discusses how to update a database schema with no downtime. It highlights the challenges faced when updating traditional relational databases (RDBMS) and NoSQL document-store alternatives, such as MySQL and MongoDB respectively. The author introduces CockroachDB, a next-gen distributed SQL database that offers live schema updates without any downtime or impact on users. It also provides an example of altering the database schema for a Node.js app using CockroachDB's SQL syntax.