Skip to content

Other databases

jtpavlock edited this page Sep 3, 2020 · 5 revisions

Moe uses sqlite by default, but the underlying database code uses sqlachemy, a database abstraction layer. Therefore any database backend is, in theory, able to be used. However, there are several (known) potential issues with using another database backend that would need to be addressed:

  1. Track and album fields aren't defined with character limits.
  2. Support for the regexp operator used for regex queries.
  3. Parsing sqlalchemy IntegrityError exceptions.
    • sqlalchemy throws an IntegrityError for multiple database errors such as failed unique constraints or foreign key constraints. Moe currently parses this error to throw a more specific exception, but the IntegrityError error message is somewhat database-specific in format.
Clone this wiki locally