So I am developing a Discord bot that will be hosted on Heroku, however since Heroku doesn’t provide SQL, I decided to use InfinityFree’s SQL service. The problem is when I inserted the login information to Sequelize, it throws a timeout error. I’d be glad if you guys could help me out here
Note that all of the config.X constants are environmental variables defined in a config.json file, and their values were CTRL+C CTRL+V’d from the InfinityFree account main page MySQL table.
Note that InfinityFree is website hosting, not database hosting. Because of this, you can only use your database in your InfinityFree website, and nowhere else.
Heroku provides their own PostgreSQL service, and last time I checked JawsDB provides a free MySQL tier. They are both services designed to be used as database hosting on Heroku.
Seeing how database connections are quite sensitive to latency, you’ll get garbage performance if you use some random database hosting provider. You should really look for database hosting in the same datacenter.
Yeah currently I am trying to make it work with Heroku with the free 5 MB database, but sadly, the app just doesn’t want to start with auto deploy set to GitHub repository main branch, even though all files are set as it’s in their documentation (Procfile has worker set, package.json has engine versions set, env variables set etc), and the log is literally empty, and they don’t provide support for free users.
And on StackOverflow, nobody replies to anything sadly.