LiteFS author here. I’d love to compare and contrast D1 with how LiteFS works but there’s not enough technical details at the moment. I’m looking forward to future technical blog posts from Cloudflare or perhaps they could open source their implementation.

There are a lot of ways to approach SQLite replication and one isn’t better than another necessarily. They simply have different trade-offs.