Phalcode / gamevault-backend

Backend for the self-hosted gaming platform for drm-free games
https://gamevau.lt
Other
161 stars 13 forks source link

It would be awesome if gamevault could support MariaDB #211

Closed MichelM279 closed 8 months ago

MichelM279 commented 10 months ago

Is your feature request related to a problem? Please describe. I would love if gamevault could support MariaDB. It's not a problem per se, but I have a personal preference for MariaDB, as I have one setup with auto backups, access mgmt, etc.. And if I setup a postgres container, I'd have to jump through all those hoops again to get the container to as high quality as my MariaDB. I'm hoping to find similar-minded people who also would like MariaDB. If I am alone in this request, I'll kindly accept that gamevault stays on one DB.

Describe the solution you'd like Be able to use MariaDB, knowing that it will be included in tests, etc. to work today and in the future.

Describe alternatives you've considered Setting up postgres :)

Alfagun74 commented 9 months ago

I get your point, but even though our ORM, TypeORM, seamlessly integrates with MariaDB, managing an additional set of database migrations seems like a significant challenge to me. I'd only consider it if there's a strong demand from the community, because, i would need to write/generate migrations and test them thrice.

MichelM279 commented 9 months ago

I fully respect that

Alfagun74 commented 8 months ago

Thank you for understanding. Perhaps we will revisit this in the future.

However, with your particular use case, it is generally a better idea to have separate databases for each application that you self-host. This approach helps prevent one application from inadvertently affecting or damaging another when restoring backups or performing similar critical operations.