Been working for quite sometime in a financial startup (5 years). My company uses postgres heavily. The system is getting overly complex, and every dev likes to add tables and columns however they want.
Are there any best practices around db design that you follow?
I mean u can put layers on top, like ORMs or graphql stuff like hasura tonabstract access to DBs,or use external managed systems like neondb, supabase or aws/azure own stuff.. to enable restriction on tables and DBs. but this things make management worse if there is no discipline.
Im no DB engineer, just a sysadmin also dealing with same issues, but there is no holy grail. In the company i work for, one Dev who really was into DB engineering took the Owner role and he is discussing engineering, giving access to them and rolling out changes with the the DEVs, when they need something, but not the devs itselfs. He also writes migrations. But he is also a very skilled Dev.