feature: PostgreSQL support

[r10r]

Hi there,

we want to run OpenDMARC with PostgreSQL instead of MySQL because of licensing issues.
Is anyone out there who has done this already ?

Thanks
Ruben

[tuxmaster5000]

It looks like the source code can support multiple back end's, but I only find an schema definition for MySQL/MariaDB.

[sparked435]

I also would prefer something other than MySQL. I'm already running Postgres; SQLite would be more than enough for a small site like mine (just a few hundred inbound emails/day.)

Converting the schema file to Postgres looks near trivial, I could probably do that within an hour or so. The bigger problem is the utilities: despite using the database-agnostic DBI library, they appear to stick exclusively to the MySQL dialect for the SQL calls themselves. Sorting this out is a lot heavier lift and my Perl is rusty.

[randolf]

I also would prefer something other than MySQL. I'm already running Postgres; SQLite would be more than enough for a small site like mine (just a few hundred inbound emails/day.)

Converting the schema file to Postgres looks near trivial, I could probably do that within an hour or so. The bigger problem is the utilities: despite using the database-agnostic DBI library, they appear to stick exclusively to the MySQL dialect for the SQL calls themselves. Sorting this out is a lot heavier lift and my Perl is rusty.

I may be able to help with this. I work with Perl's DBI and PostgreSQL almost every day, so please let me know what you've got so far so that I can just focus on what's left without re-inventing what you've already done.

[sparked435]

so please let me know what you've got so far so that I can just focus on what's left without re-inventing what you've already done.

I've done nothing but look at the code, don't let me stop you from proceeding.

[randolf]

I've done nothing but look at the code, don't let me stop you from proceeding.

Thanks! I just finished writing my PostgreSQL code, and I submitted it as a pull request: #251

Since you've been looking at the code, if you could take a look at what I've written I'd appreciate it -- I tried my best to get everything the way it needs to be, but I won't be surprised if improvements will be contributed by others. Also, a few columns are in need of documentation.

[randolf]

Many Pull Requests over the past 12+ months have been submitted by many different contributors, but it appears they haven't been dealt with, and I'm feeling concerned. Does anyone know if the original organizers are intending to continue work on this project?

I recently started an issue regarding my concern: #253

Hopefully further development can continue in the near future. (Thanks.)

[thegushi]

FreeBSD just pushed a commit into their ports tree to make opendmarc work with mariaDB, and I just approved a pull request to support mariadb (the perl modules are slightly different). I believe I commented on your postgres pull request as well, but I think we'd need to modify the scripts as well, as they presently use DBD::Mysql, and might need to modularize them (or perhaps, just ship a different set of scripts).

I would consider adding postgresql support to be something that would happen in a 1.5.0 branch versus a 1.4.2, but putting schema files in for people to test against is not a terrible idea.