Software dev by day and software dev by night. Work life balance achieved by working on separate projects. Currently working on [REDACTED] for work and video game restoration as a hobby.

I also self-host a lot of stuff. That includes a Forgejo instance for my projects and for mirroring projects that should never disappear.

  • 2 Posts
  • 7 Comments
Joined 1 year ago
cake
Cake day: July 14th, 2025

help-circle







  • I too spin up a new DB for every service that needs one. It makes maintenance less intrusive since I only have to shut down one service at a time to update or do a full file backup and I can safely tweak the DB config to best suit the service without worrying about negatively impacting other services on the same DB. I also like the flexibility to choose the best DB for the service, e.g. I use Postgres for a lot of the services I develop but they do also support MySQL/MariaDB, but I have other services that are more tested on MariaDB.

    I’d imagine having one database for everything could eventually cause performance problems across all services if the database gets too big or clunky or queries get too complex, even if just one service is causing the problem.

    I also run a lot of physical servers (I have about 10 low power computers I use as servers right now) so having a dedicated DB per service allows me to get better performance since the DB can be on the same machine as the service. Not that they need high performance, but it also helps with the efficiency.