Turso SQLite Offline Sync Public Beta

Summary

We're excited to announce that Turso Offline Sync is now available in public beta! Your applications can continue functioning seamlessly, even when disconnected from the internet. Local database operations can proceed normally, with automatic sync occurring once connectivity is restored. Historically, SQLite has been a database that excels at running local, embedded databases, because the database is just a file. For mobile devices, this means on-device databases. Turso takes advantage of this with Embedded Replicas — your local embedded databases, on-device or server can now be kept in sync with your Turso Cloud database, and any changes are propagated to all replicas. Until today, our sync was unidirectional: while you can always read from the database, even if offline, writes happen directly to the Cloud, and are propagated later. This has two consequences: Writes were always network-slow, since they have to contact the server for every request Writes could not work offline With today's announcement, the local database will be able to accept writes that are as fast as a file, work offline, and later sync to Turso Cloud. #Use Cases That Just Got Easier One of the things Offline Sync unlocks is the ability to create on-device local-first applications (in-browser is planned for the future, with "the Limbo Project"). Local-first architectures allow for fast and responsive applications that are resilient to network failures. Compared to other local-first applications, Turso's architecture allows for a simpler solution because it always syncs the full database. With Turso's multitenant architecture, you can control which data goes into which database (e.g., per user or per tenant), and then transfer the entire database to the device. As well as on-device local-first applications, Offline Sync also simplifies many other use cases: Mobile Apps — create truly offline-capable mobile experiences, including Expo-based React Native applications. Point-of-Sale Systems — proces...