News for hackers. Stuff that matters.
Re:Using the expand and contract pattern for schema changes by vvern on Monday November 10, 2025 @11:01AM (#45877203)
It should be this way. Clients should have some protocol to communicate the schema they expect to the database probably with some versioning scheme. The database should be able to serve multiple mutually compatible views over the schema (stay robust to column renames for example). The database should manage and prevent the destruction of in use views of that schema. After an old view has been made incompatible, old clients needing that view should be locked out.
Re:Using the expand and contract pattern for schema changes by 8note on Monday November 10, 2025 @02:50PM (#45880109)
> The database should manage and prevent the destruction of in use views of that schema. After an old view has been made incompatible, old clients needing that view should be locked out.

this is the interesting part where the article's prpcess matters. how do you make incompatible changes without breaking clients?