WHY LOCAL-FIRST APPS HAVEN'T BECOME POPULAR?

Summary from the TLDR newsletter

Very few apps get offline support right because syncing is hard. Building a local-first app means effectively creating a distributed system where multiple devices can mutate data independently, sometimes offline, while still converging to the exact same state without losing data. This involves solving the challenges of unreliable ordering and conflicts. SQLite is a battle-tested, lightweight, and readily available solution for local-first apps that guarantees convergence across devices, regardless of the sync order.