Recently, I deployed a Go-powered app backed by an SQLite database on Fly.io for the first time. Here’s the process that I went through, along with some of the issues that I encountered along the way.
Do you need to have a SQLite database available in a Docker image? I did, and here’s the solution I came up with.
If you’re encountering "General error - 8 attempt to write a readonly database" when working with SQLite, and confused because the write permission’s set on the file, here’s the solution.