I've looked at forum posts regarding this but I need to clarify that if I set Journaling to WAL on the database, that B4x will be able to write multiple times to the database as requests come into the server. It will not lock up the server if 100 requests come in. They will go into a queue of sorts and be written to the table in the background correct?
SQLite databases are very easy to use as they don't require any additional software or configuration. SQLite support for concurrent access is not comparable to server based databases such as MySQL and others. However they can still be perfect for small / medium solutions, especially if there...