Yes, it’s technically possible to use SQLite locally and MySQL in production, but keep in mind:
For simple projects, this setup can work fine.
For large or critical production apps, it’s safer to use the same database locally and in production (MySQL in both). This helps avoid unexpected issues or surprises with migrations, data types, or SQL behaviour.
Feel free to ask if you have any other doubts!