This is a proposal for using JSON data type in the SQUASH QA database.
SQUASH uses MySQL/MariaDB for the development and production databases, it is implemented through the Django-MySQL package to add specific features of MySQL/MariaDB to Django.
In particular, we are interested in the JSON data type to store QA outputs from validate_drp. That seems very convenient as these outputs can vary widely and we don’t want to turn all the details into a relational model.
If you are interested in the details of this implementation check sqr-009.