←back to thread

Turso SQLite Offline Sync Public Beta

(turso.tech)
222 points charlieirish | 2 comments | 31 Mar 25 15:10 UTC | HN request time: 0.445s | source
Show context
benwilber0 ◴[01 Apr 25 00:05 UTC] No.43541401[source]▶
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.

https://benwilber.github.io/programming/2025/03/31/sqlite-is...

replies(2): >>43541581 #>>43541628 #
1. GrumpyCat42 ◴[01 Apr 25 00:39 UTC] No.43541628[source]▶
Yup - I just recently learned this lesson the hard way with Turso's LibSQL server. While some of the features (like s3 replication) are cool and interesting, the amount of time working around multiple writers and foreign key shenanigans was not worth it when Postgres would have just gotten the job done.
replies(1): >>43541696 #
2. NathanFlurry ◴[01 Apr 25 00:52 UTC] No.43541696[source]▶
Can you elaborate on both of these issues?

Vanilla SQLite solved multiple writers a long time ago when they introduced WAL in 2010. Does Turso not support this?

Is the issue with foreign keys that they're not enabled by default?