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.