[Feature] Drop SQLite support
-
I have summed up the feature in concise words in the Summary section. -
I have completely described the feature in the Description section.
Summary
Remove support for the sqlite
backend.
Description
The sqlite
backend has been proving to be a nuisance within our SQLAlchemy-utilized code-base.
It comes with multiple downsides:
- SQLite does not cohere with some more performant methods used with MySQL, requiring that we branch off based on
sqlite
being used or not. - SQLite requires that we write more complicated Alembic migrations, as it cannot modify tables in the same way.
- Supporting SQLite requires that we run specific test suites for SQLite to gain coverage over its SQLite-branched paths.
To sum it up: supporting SQLite requires us to babysit it, and this comes with the downside of accounting for SQLite in the production path, which does technically make the entire website less performing and unified than it could be.