Company
Date Published
Author
Charlie Custer
Word count
1897
Language
English
Hacker News points
None

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.