B4J Question Server with SQLite multithread safety

mc73 · Jul 28, 2016

After reading this post, about setting journal_mode to val,

This mode allows multiple readers and a single writer to access the database at the same time. B4J SQL library (when initialized with InitializeSQLite) will serialize writers access.

and at the same time, reading this post, about choosing single or multi-thread handlers,

A single threaded handler will always be executed by the main thread. This means that if there are multiple requests they will be queued and executed one by one. Single threaded handlers can be useful in many cases. Some examples:
- A handler that accesses a SQLite database, which is less suitable for concurrent connections.
- A handler that writes to a specific file.
- A handler that sends a job to the printer

,

I wonder, is it safe to use multi-thread handlers, without worrying for non-queries coming from 5-10 clients?

Thank you.

Erel · Jul 29, 2016

Yes it is safe. I've updated the tutorial.

Make sure to use the same SQL object as explained in the tutorial.

B4J Question Server with SQLite multithread safety

mc73

Well-Known Member

Erel

B4X founder

Similar Threads

B4J Question Server with SQLite multithread safety

mc73

Well-Known Member

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency