See also http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/2017-August/074060.html - this branch has been around for a while and I think it was mentioned elsewhere that it definitely is being considered for mainline inclusion at some not immediate point.
Wout. On Tue, Mar 26, 2019 at 4:37 PM Joshua Wise <[email protected]> wrote: > I’ve seen the server mode < > https://sqlite.org/src/raw/README-server-edition.html?name=0c6bc6f55191b6900595fe37470bbe5772953ab5c64dae967d07a5d58a0c3508> > branch, but to me it’s a deal-breaker that it requires SYNCHRONOUS = OFF. > > This BEGIN CONCURRENT idea really interests me. By using WAL mode, where I > can have synchronous commits, the feature becomes much more valuable. > > Any word from Mr. Hipp on the status of this branch? Will it ever make it > into the official version of SQLite3, perhaps under a compile-time option? > > > On Mar 22, 2019, at 5:07 PM, Jens Alfke <[email protected]> wrote: > > > > > > > >> On Mar 22, 2019, at 1:38 PM, Barry Smith <[email protected]> > wrote: > >> > >> 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 > < > https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begin_concurrent.md > > > > > > Oh, this is interesting. Is this a feature in development that will be > released soon? > > > > [And to be pedantic: according to those docs, this feature does not do > page level locking; it’s optimistic not pessimistic concurrency.] > > > > —Jens > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
