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
