I'm self hosting a lot of small apps that require databases to function. So far, each stack has its own database, but I'm wondering if it would be better to centralise the data into one single database instance
All the apps are low traffic (it's just me), and security concerns are minimal (no sensitive data)
Does anyone have any advice on this?
You will most probably hit the problem that I had: one app moved to a new (major) version of postgres and some other apps didn't support it. So in the end I'm using a DB for each service/app.