Skip to content

Change database backend from MySQL (MariaDB) to PostgresQL

Created on November 16, 2017. Copied from redmine (https://bugs.ligo.org/redmine/issues/5986)

PostgreSQL seems to the the preferred RDBMS for much of the Django community. A comparison here: https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems.

Making the switch would likely be complicated. But if we can make the argument that it would significantly improve performance (speed and/or reliability), it may be worth it.

One point of note: the abstract base AutoIncrementModel would need to be reworked since it executes raw MySQL queries, which likely wouldn't be compatible.

Edited by Tanner Prestegard
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information