flyctl VS litestream

Once we finished playing around with the model locally, let’s cast our final spell for the day 🧙‍♂️ and deploy the model to fly.io:

If you dockerize your .net app you can run it on https://fly.io free tier with a Postgres database! You don’t need IIS or MSSQL.

checkout https://render.com/ or https://fly.io for free plans. as of deploy, you need to provide more info about your project. Do you use docker? How do you want to deploy? Etc.

Better yet, pick a few shades of grey ranging from white to black and a few shades of _one_ other colour. https://fly.io/ comes to mind. Also, here is a great video on choosing colour: https://www.youtube.com/watch?v=mq8LYj6kRyE

Hmmmm. I've had some trouble recently where (I think) the Strapi app crashed, when uploading some files (due to the fly.io machines having rather limited resources, where my media would still be listed in the library but, for example the images wouldn't show up - file missing, basically).

fly.io for laravel/mysql. Vue with netlify

This is what my github action is doing currently. Its reading the repo to see if there are any changes, then recreates the docker container and sends it to fly.io. - Then it also creates another container and sends it to dockerhub. When it sends to Fly.io, the website is automatically updated. So any changes on the repo are reflected on the website immediately. Its the same as having a firewall in a linux instance that is guided by the githubaction. Anytime someone makes a change to the file that is in the repo, the firewall gets updates when the instance is recreated. Also if someone deleted the instance the instance would reappear the moment anyone made a change to the repo.

what app? you mean the github action? It doesn't run on a local server, it's hosted on fly.io

These services are the most similar https://fly.io/ https://render.com/ https://railway.app/ If you can pay for hosting you can choose one and stick with it. If not, you'll have to use a combination of the limited free tiers each offer.

- Ben is developing https://github.com/superfly/litefs at Fly after stopping the streaming replication effort https://github.com/benbjohnson/litestream/issues/8

- And, of course, SQLite has announced a new backend that hopes to support concurrent writes and streaming replication: https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html

What a time for SQLite

I guess you can always use https://litestream.io

then there is https://github.com/benbjohnson/litestream

Beginning with Litestream may be an option.

https://litestream.io/

Yes https://litestream.io

The very problem of SQLite: Single user only. Although SQLite does have WAL but it still doesn't allow you to do concurrent write unless you want to see file corruption.

This means SQLite is very much locked to things that works with one specific purpose and almost nothing else.

Another problem (although without solving the single user mindset this wouldn't be a problem at all) is high availability. You want to make sure that your database won't get lost do you.

Things like Litestream [1] attempts to solve the SQLite backup problem it by continuously saving the database state and pack t up to S3-compatibles or file system but its just half the story. You want to make sure your operation not stopping. This is where HA comes in to save you from an emergency fixup when you are enjoying your holiday.

[1]: https://litestream.io/

I'm using Syncthing with NotePlan and Caddy in a similar way, it should be doable as long as Joplin can sure individual files.

Here's how I do it: https://notes.alinpanaitiu.com/How%20I%20write%20this%20blog...

If you want to sync an SQLite DB of articles instead, you can also do that with Litestream: https://litestream.io

Was just reminded of https://litestream.io/ which may be the best fit if you don't need to scale beyond one container.

This hasn't made the front page of HN (maybe someone should post it), but Litestream actually doesn't do replication that way any more -- I stumbled upon this commit like 2 days ago:

https://github.com/benbjohnson/litestream/pull/411