Page 1 of 1

SQLite; sqlite3u.dll; concurrency/locking;

Posted: Fri Oct 16, 2015 8:07 am
by HanPBF
Hello!

Found this link and some others (http://www.purebasic.fr/english/viewtop ... 13&t=57732).

Someone know some more links in this forum
- for using sqlite3u.dll directly (o.k. from my own thread http://www.purebasic.fr/english/viewtop ... 13&t=41164; maybe some newer avialable)
- checking a SQLite DB for locking state (https://www.sqlite.org/lockingv3.html)

Locking: access SQLite writing by more than one user either
- program notifies blocking and delays or
- using user id and not writing into same row (but into same table?)

Intentation is not to use SQLite in network but from two or more programs at client side.

Any help apreciated!
Thanks a lot!

Re: SQLite; sqlite3u.dll; concurrency/locking;

Posted: Fri Oct 16, 2015 1:55 pm
by HanPBF
found this one
http://www.purebasic.fr/english/viewtop ... 43#p368143

so, useSQLiteDatabase links lib into PB... very smart to use...