Turso SQLite Offline Sync Public Beta

It'd be nice if the post went into how conflict resolution will (?) work because that's the hard part here and the main selling point imo.

This sounds great, but I have some questions regarding data integrity and security.<p>If I build an offline first app using Turso, will my client directly exchange data with the database, without a layer of backend APIs to guarantee data integrity and security? For example, certain db write is only permitted for certain users, but when the db API is exposed, will that cause problems? A concrete example would be a forum where only moderators can remove users and posts. Say if I build an offline first forum, can a hacker hack the database on the filesystem and utilize the syncing feature to propagate the hacked data to the server?

Since enough comments seem to focus on consolidating writes and security issues, please see the post. They explicitly state this as something they&#x27;re working on.<p>&gt; we&#x27;re working hard on the following features: &gt; &gt; Automatic and manual conflict resolution<p>As such everything within this thread is conjecture unless otherwise informed by their work.

I just wrote a post about this kind of stuff and why it&#x27;s (almost always) nonsense. You will spend more time and effort trying to shoe-horn SQLite into a server database than you will ever get any benefits from.<p><a href="https:&#x2F;&#x2F;benwilber.github.io&#x2F;programming&#x2F;2025&#x2F;03&#x2F;31&#x2F;sqlite-is-great-for-what-it-is.html" rel="nofollow">https:&#x2F;&#x2F;benwilber.github.io&#x2F;programming&#x2F;2025&#x2F;03&#x2F;31&#x2F;sqlite-is...</a>

I would like to test it with a large database to see how it handles a 3–5 GB database sync.<p>In the example, it shows syncing returning a promise. Is there no way to track the progress of the sync?

What is the realtime and reactivity support in Turso? It’s starting to look attractive but do updates propagate automatically without polling?

I really admire Turso. This Offline Sync is probably like ELectric offering but if it will work as anticipated , lot of read only data can be closed to the frontend and can improve performance and save cost.

&gt; Point-of-Sale Systems — process transactions regardless of internet connectivity<p>Mentioning this as an example use case is simply untrue, right?

Is Turso open-source? is libSQL open-source?

Does it support type safety? Or exists an add &#x2F; module on top of turso that support it?

Does Turso have any plans to support streaming queries for real time applications?

how about gun.js with sqlite3 storage adapter <a href="https:&#x2F;&#x2F;github.com&#x2F;gundb&#x2F;sqlite" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;gundb&#x2F;sqlite</a>

What are some of the differences from Electric SQL?

LOL &quot;[conflict] resolution is not yet implemented&quot;

Looks good, but i am fine with midas.dll