Add PostgreSQL as database option

[cfanoulis]

Description

Is your feature request related to a problem?

Yes. I have a PGSQL cluster running on my (fairly limited) VPS and I really find a big hassle on setting up a 2nd DB cluster of anything (when I do so, everything running on it turns sluggish as hell, I've even been billed for burst usage once)

Describe the solution you'd like us to implement.

I'd love to see PostgreSQL as a DB supported by BentoBox

Describe alternatives you've considered.

• Getting a new VPS: The priciest of them all, outside of my budget
• Running MySQL on Docker: Never got it to work
• Running MongoDB: apt repository shoots a khajhilion of errors

Additional context

https://feedback.techsco.de/d/124-support-for-more-dbs

[BONNe]

I think a better alternative would be to use json filesystem :) until we implement pgsql.

[cfanoulis]

@BONNe currently doing that, but I want something more reliable than JSON :P

[Poslovitch]

Well, another database type to learn how to implement ! 🙂

[Poslovitch]

I did some search and PostgreSQL looks pretty much similar to MySQL, at least the queries.
Implementing it should be an easy job (definitely easier than SQLite ahah).

[Poslovitch]

@cfanoulis Done !
I suggest you try this out on your side using a dev build. I could run some tests and it looked like it all worked fine, but as I'm quite new to all of this database stuff, it's better to check twice.