#Litestream now does compaction. Using s3 condition writes. 😎

#consul is good, but complex when not in infra. Especially for #litefs. Too many moving parts. 😅

Very happy litestream is getting some love. Makes #sqlite even more of a no brainer choice. 😏
https://fly.io/blog/litestream-revamped/

Litestream: Revamped

Bringing in what we learned from LiteFS

Fly

@markus I'm sorry for be the bearer of bad news friend, but here 😭: https://community.fly.io/t/sunsetting-litefs-cloud/20829?u=ab1

On the plus side, #litefs is still being developed. Just not as a service anymore and more as utility. 🫠

Sunsetting LiteFS Cloud

Last year we released a managed service called LiteFS Cloud that continuously backs up LiteFS clusters. We’ve decided to wind it down. LiteFS Cloud will continue to be available until October 15, 2024. LiteFS Will Keep Working LiteFS is an open-source project that runs directly in your own instances. We’re not sunsetting LiteFS itself! LiteFS is great; we use it extensively ourselves. But most LiteFS users don’t use LiteFS Cloud, so we’re going to stop running it. Disconnecting from LiteFS Clo...

Fly.io

And now I found out about #turso, an #sqlite service provider. 😅 They're using #libsql fork to make this doable.

The premise on the service is simple. They build a distributed sqlite set up. You as a user can then use that.

Knowing full well how to make a distributed sqlite and with backup control, this can take a lot of time. I can see value in that. 😅

And considering #litefs cloud is deprecated... It may be a good try. 🫠

https://turso.tech/

Turso — SQLite for Production

Turso is SQLite for production: great developer experience and efficiency with essential quality of life improvements for modern applications.

Turso
🌗 跳過API,直接發送您的數據庫 · The Fly Blog
➤ 跳過API,直接發送您的數據庫
https://fly.io/blog/skip-the-api/
本文介紹了使用LiteFS作為API層的替代方案,並將數據庫直接發送到客戶端。這種方法可以提高靈活性和效率,但也有一些限制。
+ 這是一種非常有趣的方法,可以提高效率和靈活性。
+ 這種方法的限制是什麼?
#數據庫 #API #LiteFS
Skip the API, Ship Your Database

The best code is the code unwritten. Avoid building a complex API layer by sharing your database between services.

Fly

@chrisg If you had to rank them in order, which aspects are most/least important to your vision?

- storage engine
- replication protocol(s)
- backup / resilience mechanisms
- query / indexing modes
- primary means of access (web, SQL, ...)
- license

Do you see this falling somewhere on the #SQLite / #Litestream / #LiteFS spectrum, or are you envisioning a new greenfield project?

Well, this sure is neat. https://fly.io/blog/litefs-cloud/

I’ll be very curious to see how much it ends up costing.

#SQLite #Litestream #LiteFS

LiteFS Cloud: Distributed SQLite with Managed Backups

News, tips, and tricks from the team at Fly.

Fly
#litefs 0.4.0 for distributed #sqlite is out, and I’m really looking forward to trying it out! https://community.fly.io/t/litefs-v0-4-0-released/12278
LiteFS v0.4.0 Released

We’ve just released a new version of LiteFS! If you haven’t seen LiteFS before, it’s a distributed file system for automatically replicating SQLite databases around world. It’s great for read-heavy applications that need low latency. This release focused on making LiteFS-based applications easier to run by making LiteFS more transparent. Improving request redirection Previously, your application needed to handle write request redirection and track consistency between requests so users could r...

Fly.io

I've started building my public-data-enrichment-platform using #flyio, #SQLite and #LiteFS, and #Golang. Fly is just such a breeze to work with.

Not only do I now deploy to Amsterdam, Stockholm, and Frankfurt all at once (the platform is for Danish customers) for redundancy, but since by Grafana cloud setup automatically picks up the new app from Fly's Prometheus, I've got monitoring working right after deploy.

Works so much easier than anything AWS ever offered!

@polarcoder Nice article, but it's aged a bit. #LiteFS and #rqlite are doing some really interesting things with distributed SQLite. I wrote up an article about LiteFS (using Go, but usable in all languages) if you're curious. 😊 https://www.golang.dk/articles/distributed-sqlite-with-litefs
Distributed SQLite with LiteFS

Using distributed SQLite and Go in the cloud with LiteFS.

@serge The Litestream website has a nice overview of similar alternatives: https://litestream.io/alternatives/

Quite nice selection for various priorities and trade-offs.

TL;DR:
- #Litestream is primarily for disaster recovery
- #LiteFS is a distributed file system from the same authors for "high availability and low global latency"
- #rqlite (and #dqlite) "trades higher durability for lower write throughput"

Alternatives - Litestream

Litestream replicates SQLite databases in real-time to S3.