Ah, great, thank you very much for this information. ----- Original Message ----- From: Barry Smith <smith.bar...@gmail.com> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Sent: Friday, March 22, 2019, 21:38:10 Subject: [sqlite] Row locking sqlite3
You might be interested in the BEGIN CONCURRENT branch. It does page level locking (not quite as granular as row level). https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begin_concurrent.md > On 22 Mar 2019, at 11:48 am, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote: > This sounds interesting. I have some questions about: >> Row lock information is shared with processes. If a process finished >> unexpectedly, unnecessary lock information might be stayed. In order to >> unlock them, please use sqlumdash_cleaner.exe which clears all record >> information. If there is a process which is in a transaction, >> sqlumdash_cleaner.exe should be called after end the transaction. > - Where is row lock information stored? In database file, in journal file, in > WAL file, or in memory? > - Why should the cleaner be called after the end of a transaction? > - I don't like the idea of calling an external exe in case of problems (and > more than that, after every transaction??). Couldn't you introduce a PRAGMA > for unlocking rows? > ----- Original Message ----- > From: Peng Yu <pengyu...@gmail.com> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Sent: Friday, March 22, 2019, 15:25:24 > Subject: [sqlite] Row locking sqlite3 > Hi, > I see that sqlite3 still does not support row locking. This package > tries to resolve this problem. But it does not have a standard build > process for Linux. > https://github.com/sqlumdash/sqlumdash/ > Are there other packages similar to sqlite3 but support row locking? Thanks. > -- > Regards, > Peng > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
