Extend test coverage to MySQL and SQLite #745
Description
Currently our test suite and CI pipeline only exercise PostgreSQL. As a result, MySQL/MariaDB and SQLite users have no automated guarantee that the code works correctly on their platforms.
Extend automated testing to cover SQLite, MySQL/MariaDB, and keep PostgreSQL tests conditional, plus document the process so contributors can run all database tests locally and in CI.
TODO
- Add SQLite Support
- Add MySQL/MariaDB Support
- Define MySQL/MariaDB services in
docker-compose.yml - Django Multiple-Databases Configuration
- Make PostgreSQL-Specific Tests Conditional
- Support CI/CD multi databases