Database Compatibility Issues

I was initially excited about this project due to its promise of supporting MySQL and SQLite. However, I've encountered several issues that have forced me to consider alternative solutions. The project claims to support MySQL and SQLite, but in my experience, this support is not functional.

Issues Encountered

1. Database Selection Ignored:

   • Regardless of what is specified for the database in the .env file, the project always defaults to using PostgreSQL. Manual changes in the schema file are required to specify a different database.

2. SQLite Configuration Errors:

   • When setting the database to sqlite with file:./main.db, the application encounters errors and fails to connect.

3. MySQL Port Issue:

   • The .env file contains a hardcoded port for the MySQL connection string that does not match the default MySQL port. This requires manual modification of the connection string.

4. Database Specification Issues:

   • There is no direct method to specify the desired database without modifying the connection string manually.

5. Migration Problems:

   • After successfully connecting to the desired database, the application fails to migrate schemas properly. Adding a migration command to the package.json file results in errors indicating mismatches with migration_lock.toml. After adjusting this, SQL errors occur, as the migrations seem to be designed exclusively for PostgreSQL.

Screenshots

Request

Please address these issues or update the documentation to clarify the actual database support. The current state of the project does not align with the claim of supporting MySQL and SQLite.

Thank you for your attention to these matters.