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're working on.<p>> we're working hard on the following features:
>
> 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'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://benwilber.github.io/programming/2025/03/31/sqlite-is-great-for-what-it-is.html" rel="nofollow">https://benwilber.github.io/programming/2025/03/31/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?
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.
> Point-of-Sale Systems — process transactions regardless of internet connectivity<p>Mentioning this as an example use case is simply untrue, right?
how about gun.js with sqlite3 storage adapter <a href="https://github.com/gundb/sqlite" rel="nofollow">https://github.com/gundb/sqlite</a>