News for hackers. Stuff that matters.
Re:Show HN: Mathesar – open-source collaborative UI for Post... by TeeWEE on Friday March 03, 2023 @12:31AM (#35006179)
You’re actually right. You don’t want people to edit the DB or schema in this manner.

Schema migrations should go via CI/CD and data changes via your app.

Otherwise it’s gets messy indeed.

Re:Show HN: Mathesar – open-source collaborative UI for Post... by kgodey on Friday March 03, 2023 @11:56AM (#35012103)
Mathesar is designed to be used for a bunch of different types of use cases.

I agree you shouldn't allow users to change the schema if you're connecting Mathesar to a production database (that would mess a lot of things up!) We've designed our user roles to account for this – you would assign "Editor" permissions to users, and they can only edit data, but not change anything related to the structure.

On the other hand, if you're using Mathesar as your primary tool to work with your data, it's really nice to be able to change the schema to align with changes in your mental models or workflows.