I have had similar issues with Railway and even fly.io. I was really hoping Fly would work because it’s like having Strapi on the edge. Only Digital Ocean seems to work well for me.
It happens when there is no activity for a while. If I make a call to the API from my front end every hour or so, it never happens.
Also, I did try connecting to the Digital Ocean postgres database from my fly deployment and it still had problems.
When Strapi is deployed to Digital Ocean, I can use almost any database service and have no issues.
Maybe I will try using PlanetScale for my database (MySQL).
I really want this to work on Fly. My experience with it has been great so far, besides this.