MariaDB Support (Formerly: MySQL Support)

[paragonie-scott]

Right now, I've only written support for PostgreSQL. Before v1.0.0, we should also support MySQL backends.

[paragonie-scott]

Questions:

1. Does MySQL support all of the features we use from PostgreSQL here? https://github.com/paragonie/airship/tree/master/src/Installer/sql/pgsql
2. Do we need to rewrite a substantial amount of queries?

[paragonie-scott]

This is actually a very low priority for us, as no one seems to want it (and we're more than comfortable sticking to PostgreSQL).

Leaving it open in case I'm wrong, but might just close it if we reach the v1.0.0 milestone and there's no interest in MySQL/MariaDB.

[kmark]

MySQL support would probably help adoption considering how closely coupled PHP and MySQL tend to be. As long as we're not doing too much (any?) PostgreSQL specific stuff it shouldn't be a huge hassle to add MySQL support later on.

[paragonie-scott]

Yeah, especially the latest version of MySQL with JSON support.

Does anyone else want to try to jump on creating the appropriate .sql files for MySQL after we get 0.2.0 out? I don't use MySQL much these days.

[paragonie-scott]

Debating punting this to 2.0.0, because widespread adoption will require libsodium anyway.

[paragonie-scott]

Okay, after reading this, I'm going to just say NO to MySQL and instead pivot for MariaDB support in 2.0

[co60ca]

+1 for MariaDB but database side checks are apparently slow anyway iirc

[paragonie-scott]

Bumping off v2.0.0 because there's no telling when MariaDB will allow WITH RECURSIVE queries.

[paragonie-scott]

We can expect MySQL 8 to support WITH RECURSIVE queries.

When that is released and generally available, we can seriously consider MySQL support.