SQLite und konkurrierender Zugriff mit FireDAC

[Der schöne Günther]

(Hervorhebung durch mich)

Zitat:

SQLite assumes that these system calls all work as advertised. If that is not the case, then database corruption can result. One should note that POSIX advisory locking is known to be buggy or even unimplemented on many NFS implementations (including recent versions of Mac OS X) and that there are reports of locking problems for network filesystems under Windows. Your best defense is to not use SQLite for files on a network filesystem.

Quelle: https://www.sqlite.org/lockingv3.html


und

Zitat:

A good rule of thumb is to avoid using SQLite in situations where the same database will be accessed directly (without an intervening application server) and simultaneously from many computers over a network.

Quelle: https://www.sqlite.org/whentouse.html