B4J Question SQLite Block Write or Read

[Diego Roman]

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]

Maybe this article could help.

 

[Erel]

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]

Okay, thanks for your explanations, now I understand better.