Hosting on Fly.io with SQLite as DB - ist start from stopped fast enough for app installation?

Hi all,

I have just finished my first tiny nearly extension only app. As it’s using the db only for the session table and the embedded app page is just a HOWTO use the admin extension, the Remix server does nothing as dealing with auth and storing the sessions.

Hence, the SQLite db is more than enough. Just doing regular backups, not to lose the installation information.

As I will give away the app for free for a certain time, I am tempted to let Fly.io let the server container sleep if not used. I tested to install when the container was sleeping, but the loading of the default page wakes up the server. Hence, I can’t simulate how the flow would behave when triggered from the Shopify app store.

Has anybody experience with the Fly / Remix / SQLite setup with a fly.toml like mine:

...

[http_service]
internal_port = 3000
force_https = true
auto_stop_machines = 'stop'
auto_start_machines = true
min_machines_running = 0
processes = ['app']

...

Thanks for your input!

Should be fine. But the poor soul whose subscription wakes up fly will have a lovely loading screen for ~X seconds (guesstimate).

What is your SQLite setup?

2 Likes

Yes, you are right. I decided to have it up and running because of this.

Still, nobody installed my app :smiley:
Sorry for the late reply. Didn’t come around sooner.
To many online places …