[Feature Request] Add PostgreSQL Compatibility

[fabianfrz]

No description provided.

[mrschyte]

It would be awesome to have compatibility with CockroachDB as well. CockroachDB uses the PostgreSQL wire protocol, but some expressions are not compatible and have to be changed, see: https://www.cockroachlabs.com/docs/stable/porting-postgres.html
This would allow magma to be easily deployed in a cloud environment with fault tolerance and load balancing.

[brokep]

I think a SQLite option/port/fork would make cloud and smaller raspberry pi implementations possible and easier to deploy than a fork of postgres.
My .002

[fabianfrz]

@klosnet it's no problem to run PostgreSQL on a raspberry pi as it runs pretty well - you just cannot hold so many data in memory. Email is something really complex so you probably don't get around a good optimizing database server (if you have many datasets in your database).

[ladar]

Someday, I'd like to create a standalone magma variant, which doesn't need a MySQL/memcached server. My plan was to simply build magma with MySQL embedded.

If someone wants to submit a patch, which adds support for Postgres, I'm all for it. The SQL interface is thoroughly abstracted via the providers layer, so it would be an isolated change.