fefferkorn
Joined 2 years ago
Joined 2 years ago
What made it work best (and rock stable) was using LTE only, or ADSL only connections having same ping to aggregator (VPS) and have the VPS as near as possible. (latency wise)
I did not had the time to set up multiple redundant aggregators, so my SPOF was the VPS some times. Maybe there is a solution out there.
So far my experience a year ago. Our provider then offered a way cheaper managed solution, thats why we stopped using it.
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.