So guys here is some update from my deployment setup.
I had huge issues on render.com with my setup. I got the knex issue, after some idle time the server lost connection to the database and needed to reboot, … So I increased database and node ressources to very high specs. Without any improvement.
So I switched to digitalocean app platform to check if this an issue of render. (Setup is as easy as with render)
… Well, yes, it is an issue with render… (At least for me)
I am using the following setup now on digitalocean:
- Web service: $20.00/mo – Basic 2 GB RAM | 1 vCPU x 1
- Dev Database: 7$/mo 512 MB RAM, Shared CPU, 1 GB Disk
Even with this “low specs” (I bought a lot bigger package on render) I am not facing any of the above mentioned issues.
- Changing database models → no knex issues
- No idle connection issues
I have no idea what the issue is at render.com.
But I wasted a lot of time trying to fix the render hosting with pool settings and stuff and it only caused frustration.
TLDR: If anyone has the same issues i highly recommend to benefit of my painful experience, skip render and just use digitalocean (or some other hosting provider)