LiteFS
This is distributed SQLite 3, running (I assume at least partially managed?) LiteFS[5] for you. Which is pretty cool!<p>What I&#x27;d like to have seen is how this compares to things like rqlite[1] or Cloudflare&#x27;s D1[2] addressed directly in the article<p>That said, I think this is pretty good for things like read replica&#x27;s. I know the sales pitch here is as a full database, and I don&#x27;t disagree with it, and if I was starting from scratch today and could use this, I totally would give it a try and benchmark &#x2F; test accordingly, however I can&#x27;t speak to that use case directly.<p>What I find however and what I can speak to, is that most workloads already have database of some kind setup, typically not SQLite as their main database (MySQL or PostgreSQL seem most common). This is a great way to make very - insanely, really - fast read replica&#x27;s across regions of your data. You can use an independent raft[3][4] implementation to do this on write. If your database supports it, you can even trigger a replication directly from a write to the database itself (I think Aurora has this ability, and I think - don&#x27;t quote me! - PostgreSQL can do this natively via an extension to kick off a background job)<p>To that point, in my experience one thing SQLite is actually really good at is storing JSON blobs. I have successfully used it for replicating JSON representations of read only data in the past to great success, cutting down on read times significantly for APIs as the data is &quot;pre-baked&quot; and the lightweight nature of SQLite allows you to - if you wanted to naively do this - just spawn a new database for each customer and transform their data accordingly ahead of time. Its like AOT compilation for your data.<p>if you want to avoid some complexity with sharding (you can&#x27;t always avoid it outright, but this can help cap its complexity) this approach helps enormously in my experience. Do try before you buy!<p>EDIT: Looks like its running LiteFS[5] not LiteStream[0]. This is my error of understanding.<p>[0]: <a href="https:&#x2F;&#x2F;litestream.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;litestream.io&#x2F;</a><p>[1]: <a href="https:&#x2F;&#x2F;github.com&#x2F;rqlite&#x2F;rqlite" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;rqlite&#x2F;rqlite</a><p>[2]: <a href="https:&#x2F;&#x2F;blog.cloudflare.com&#x2F;introducing-d1&#x2F;" rel="nofollow">https:&#x2F;&#x2F;blog.cloudflare.com&#x2F;introducing-d1&#x2F;</a><p>[3]: <a href="https:&#x2F;&#x2F;raft.github.io&#x2F;" rel="nofollow">https:&#x2F;&#x2F;raft.github.io&#x2F;</a><p>[4]: <a href="https:&#x2F;&#x2F;raft.github.io&#x2F;#implementations" rel="nofollow">https:&#x2F;&#x2F;raft.github.io&#x2F;#implementations</a><p>[5]: <a href="https:&#x2F;&#x2F;github.com&#x2F;superfly&#x2F;litefs" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;superfly&#x2F;litefs</a>