Hi,
I am planning an upp aplication that will have a service for running in windows xp and a GUI console to administer that service. The service will use SQLite database. During execution will be the change that service is reading from database table and console is adding or editing records.
Does SQLite database supports this?
If not, which FREE database are you using for multiuser/multiprocess?
Hi,
I am planning an upp aplication that will have a service for running in windows xp and a GUI console to administer that service. The service will use SQLite database. During execution will be the change that service is reading from database table and console is adding or editing records.
Does SQLite database supports this?
If not, which FREE database are you using for multiuser/multiprocess?
Thanks
JoseB
As long as you keep one session per one thread, I think you should be OK.
(More threads per one session are OK too, but you need to serialize then).
sergeynikitin Messages: 748 Registered: January 2008 Location: Moscow, Russia
Contributor
Yes, if use of atomic transactions, SQLite guarantees non-different threads, and data integrity. (Read the documentation on www.sqlite.org).
Also states that in the case of atomic operations is guaranteed simultaneous multi-stations work and data integrity as if the traditional transaction were used.