Hacker News Reader

Comment by skybrian | Hacker News Reader

I went through this presentation looking for "how do you do backups" and it glosses over it. But the author blogged about that separately [1].

It seems he uses Litestream with DigitalOcean Spaces for this. Looks like they start at $5 per month for 250 GB [2]. Would that be the best way for a hobbyist to get started?

[1] https://fractaledmind.github.io/2023/09/09/enhancing-rails-s... [2] https://www.digitalocean.com/pricing/spaces-object-storage

View on HN

Fwiw, I've been using hosted LiteFS Cloud[0] (written by the same person who wrote litestream) on fly.io. The pricing starts at $5/mo for the first 10GB (kind of steep) but it's been working out so far.

(no affiliation to fly/litefs, just a fan)

[0]: https://fly.io/blog/litefs-cloud/

Maybe I'm crazy but I just have a cron job that does .backup during a time with little activity. My db is only 40GB or so and stored on an NVMe so it finishes quickly.

Nowadays you're considered crazy if you don't pay rent-seekers for every simple thing.

this comments seems to say, that you could corrupt your copy, if you copy it while it is in use https://news.ycombinator.com/item?id=39838753

The ".backup" mechanism is safe - it's directly copying the file with "cp" that doesn't work.

Here's how to use .backup:

    sqlite3 data.db ".backup 'backup.db'"

You can also do this:

   sqlite3 data.db 'VACUUM INTO "backup.db";'

That's slower, but results in a smaller backup file: https://www.sqlite.org/lang_vacuum.html

thanks!

For my project I've been using Litestream to Cloudflare's R2, which is compatible with Amazon S3, and has a very generous free tier.

It seems that the R2 free tier is "Available on Workers Paid plan" which is being replaced by the "Standard plan" [1].

I interpret this as saying that you can't get R2 literally for free. Looks like Cloudflare KV could work, with values that go up to a bit over 25MB.

$5 per month is very reasonable if you're using it for real, though.

[1] https://blog.cloudflare.com/workers-pricing-scale-to-zero/

I use Litestream for my production web app and stream to Backblaze B2. It's S3 compatible and literally free!

Wasabi should give you a lot more storage for almost the same price

I checked your blog and I am impressed you are still very curious to learn things which didn't exist before you retired (generative AI).

Thanks! Just tinkering, though. I skim AI papers sometimes, but don’t do the homework.

Reply on news.ycombinator.com