MariaDB Support (Formerly: MySQL Support) about airship HOT 9 OPEN

We can expect MySQL 8 to support WITH RECURSIVE queries.

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

from airship.

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?

from airship.

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.

from airship.

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.

from airship.

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.

from airship.

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

from airship.

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

from airship.

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

from airship.

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

from airship.