2 ms·
Also cool is that you can bind mount the same sqlite backing db file into multiple containers.
by sneak 6y ago
Also cool is that you can bind mount the same sqlite backing db file into multiple containers.
- nawgszy 6y agoThat seems dangerous? How can it be so? Surely multiple instances of SQLite shouldn't read the same backing file..
- sneak 6y agoThe whole job of sqlite is to handle the locking to keep such accesses safe.
- nawgszy 6y agoOk, I see. I did some reading and it looks like this to me: * the DB is supported by a backing file * this backing file supports multiple read threads simultaneously but writes are locked via filesystem locks * write performance with multiple writers is therefore dangerous * read performance is good if no one is writing and consistent even if someone is