I love using SQLITE, but I need to develop on glitch, then host a production version of the app on heroku (for reasons beyond my control). Heroku specifically does not allow SQLITE - only MySQL or Postgres.
I’d like to develop against MySQL on Glitch mainly so I don’t have to switch SQL syntax between development and production.
I know mysqld is in the Glitch container - is there a reason why it can’t be used ? Or has anyone got it working so I can use mysql on the command line ?
Glitch support recommend connecting to an external MySQL database, due to limitations of the Glitch project container (external ports, disk, cpu, memory, uptime).
Finding an external MySQL database that allows incoming external connections can be a challenge
If you’re determined to try to get it to work inside a Glitch project, here’s a starting point …
…but… how do I now know what user and port to use etc…? So that I can connect my django app to it and then migrate the data into it, rather than sqlite …