←back to thread

What If OpenDocument Used SQLite?

(www.sqlite.org)
275 points whatisabcdefgh | 1 comments | 04 Sep 25 21:36 UTC | HN request time: 0.203s | source
Show context
lifthrasiir ◴[05 Sep 25 02:21 UTC] No.45134401[source]▶
SQLite can't be reliably used in networked file systems because it heavily relies on locking to be correctly implemented. I recently had to add a check for such file systems in my application [1] because I noticed a related corruption firsthand. Simpler file formats do not demand such requirements. SQLite is certainly good, but not for this use.

[1] https://github.com/lifthrasiir/angel/commit/50a15e703ef2c1af...

replies(4): >>45134413 #>>45135134 #>>45135346 #>>45135619 #
chungy ◴[05 Sep 25 05:48 UTC] No.45135346[source]▶
That's pretty broad and over-generalized. Networking file systems without good lock support is almost always a bad setup by an administrator. Both NFS and CIFS can work with network-wide locks just fine.

SQLite advises against using a networking file system to avoid potential issues, but you can successfully do it.

replies(2): >>45135607 #>>45136892 #
1. lifthrasiir ◴[05 Sep 25 10:09 UTC] No.45136892[source]▶
As noted in my other comment, those "potential" issues are real and do happen from time to time. Unless SQLite gives some set of configurations to avoid such issues, I can't agree that it's over-generalized.