U++ framework: U++ SQL » Does SQLite is thread safe?

Home » U++ Library support » U++ SQL » Does SQLite is thread safe?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Does SQLite is thread safe? [message #20875]

Wed, 15 April 2009 17:30

JoseB
Messages: 37
Registered: March 2009

Member

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

Report message to a moderator

Re: Does SQLite is thread safe? [message #20878 is a reply to message #20875]

Wed, 15 April 2009 18:22

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

JoseB wrote on Wed, 15 April 2009 11:30

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).

Mirek

Report message to a moderator

Re: Does SQLite is thread safe? [message #20879 is a reply to message #20875]

Wed, 15 April 2009 18:35

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.

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

Re: Does SQLite is thread safe? [message #20884 is a reply to message #20879]

Wed, 15 April 2009 20:12

JoseB
Messages: 37
Registered: March 2009

Member

in my case is not multi-thread but multi-process on the same OS, but i think it is the same for this matter.

JoseB

Report message to a moderator

Previous Topic:	'?' make errors
Next Topic:	Application error under WindowsXP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 04 18:19:20 GMT+1 2026

Total time taken to generate the page: 0.28601 seconds