Schema Versioning for a Live-Updating Product Catalogue
#architecture #backend #database #webdev A product catalogue that changes hourly — new items added, old ones retired, prices adjusted — needs a schema that supports reads during writes without locking the table or serving half-updated rows. Immutable rows, versioned views Instead of UPDATE-ing a row in place, insert a new…