Error when using MySQL

[bwlynch]

The following error occurs when using a MySQL database (5.7 or 8), and running the export command ./ap.py datapublish publication --producer <producer_id> --processed-at today

/root/.local/share/virtualenvs/ArticleParser-eaOGpC12/lib/python3.7/site-packages/pymysql/cursors.py:170: Warning: (1235, "This version of MySQL doesn't yet support 'comparison of JSON in the BETWEEN operator'")
  result = self._query(query)

In the documentation I saw that MariaDB is the recommended database, so it may just be that MySQL simply doesn't have the needed functionality here, and that MariaDB should be the recommended database to use across this project.

[pm5]

It seems like MySQL does not support some of the SQL features we are using, judging from the error message. Maybe we can workaround this by replacing BETWEEN expressions with plain old comparisons.

[blynchNDI]

@pm5 That would be great. Do you have a recommended database for running the whole application? I saw MariaDB recommended in the documentation for the ArticleParser and got this issue here when using MySQL, but was also getting the error in disinfoRG/ZeroScraper#124 when using MariaDB for the ZeroScraper