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?
Resource overhead when using multiple instances is negligible. But the benefit is if an app move to a nee major version of the db, then you can migrate easily. Also you don't have to worry about permissions, multi tenancy, roles, etc.
Only benefit of using a centralised db is easier back ups. But that is not enough for a centralised db IMO.