-
Notifications
You must be signed in to change notification settings - Fork 4
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:
- Track and album fields aren't defined with character limits.
- Support for the
regexp
operator used for regex queries. - 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 theIntegrityError
error message is somewhat database-specific in format.
- sqlalchemy throws an