gaseous-project / gaseous-server

A game ROM manager, with a built in web based emulator using multiple sources to identify and provide metadata
GNU Affero General Public License v3.0
259 stars 12 forks source link

[Feature] PostgreSQL support #287

Open pyrox0 opened 7 months ago

pyrox0 commented 7 months ago

Is your feature request related to a problem? Please describe. I only have the Postgres SQL server installed on my server, and I would like to not host another database server on my server.

Describe the solution you'd like Add support for Postgres.

Describe alternatives you've considered

Additional context I don't know how deeply MySQL/MariaDB is integrated into this application, so I don't know how easy it would be to add this. I know that the DotNET Entity Framework Core(EFCore) makes connecting to different SQL servers very easy, but if this app isn't using it already, I understand that it would most likely be a lot of work to integrate it.

michael-j-green commented 7 months ago

Thanks for your request.

Gaseous uses plain ADO.NET rather than EF.

Postgres is definitely something I want to look at though.

MegaShinySnivy commented 5 months ago

Not to bump this, but I would be another user who would appreciate Postgres support, as the tooling in my existing lab is already in place for postgres backups, restores, monitoring, etc, via CNPG.