Diego Roman Member Licensed User Apr 10, 2017 #1 Hi, How can I block an SQLite Database to prevent concurrent access of two applications, generating erroneous data. Many thanks in advance for your help.
Hi, How can I block an SQLite Database to prevent concurrent access of two applications, generating erroneous data. Many thanks in advance for your help.
Lahksman Active Member Licensed User Longtime User Apr 11, 2017 #2 Maybe this article could help. Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Apr 12, 2017 #3 I think that it is worth using a different database such as MariaDB or MySQL. SQLite is less suitable for concurrent access by different processes. You can access it concurrently in wal mode however it will not work without external synchronization. Upvote 0
I think that it is worth using a different database such as MariaDB or MySQL. SQLite is less suitable for concurrent access by different processes. You can access it concurrently in wal mode however it will not work without external synchronization.
Diego Roman Member Licensed User Apr 12, 2017 #4 Okay, thanks for your explanations, now I understand better. Upvote 0