Feature Request: Postgres database driver

[kasefuchs]

Hello,

It would be nice to add support for postgres database driver as an alernative for sqlite.

[thomiceli]

Hi, in what case would you use Postgres over Sqlite for Opengist ?

[kasefuchs]

In my server architecture, I prefer to centralize all data in one RDBMS such as Postgres. This makes it possible to store the data itself separately from the application, edit data quite easily through pgadmin and visualize it using grafana.

[ahgraber]

+1 for postgres support. I have a much more robust backup / restore solution through postgres than I do with filesystem snapshots / copies.

[maltegrosse]

Would be nice to have Postgres implemented. As I can see you are using gorm, so should be straight forward: https://gorm.io/docs/connecting_to_the_database.html

EDIT: seems PR #231 is already working on it

[thomiceli]

I will review the PR soon enough, i might add mysql aswell

[maltegrosse]

@thomiceli is there anything how I can support this PR/feature ?

[spectrapulse]

This definitely would be a nice feature as I already have existing tools to easily backup postgres and/or mariadb in an incremental way.

This is way harder and way more tedious to do with sqlite.