Fellow tooters: What's the best way these days to deploy a simple Python app with a simple writeable database (bonus if it works with sqlite, which I know you can't use with eg Vercel or Heroku)?
The use case is a classroom environment. Ideally not a Docker setup, because I don't think at this stage you'd want to explain containerization to people.
The answer to this used to be Heroku's free tier, but without it they're a bit pricey I think.
Any ideas?
@ken I recently ported a free heroku app to Fly.io. I'm happy to share my experience, but I'm not sure I can recommend it for your use case. I could only get it to work with Docker.
I specifically had trouble using the buildpacks and SQLite, but I had a lot of trouble finding any docs on the open buildpack ecosystem to track down the issue.
@JoeGermuska @ken @palewire Fly.io does have support for persistent volumes so you could store a writable SQLite DB there. I got it to work before I realized my DB was read-only and could be packaged with the app instead.
I think the main challenge with setting up a template repo is that the mechanism for creating a volume is manual and not part of the config definition. https://fly.io/docs/reference/volumes/#creating-volumes
But once it exists it could work!
Ken Schwencke
Joe Germuska
Ben Welsh
ryan