Re: [sqlite] what is server-process-edition?

On 26 Mar 2018, at 9:26am, Olivier Mascia wrote: > Simon, if this discussion is really around the branch > 'server-process-edition', it was my (possibly wrong) understanding that this > is not really true. This branch does apply page-level locking, or I got it > all wrong.

Re: [sqlite] what is server-process-edition?

> Le 26 mars 2018 à 10:20, Simon Slavin a écrit : > > On 26 Mar 2018, at 8:57am, Marco Bambini wrote: > >> So it has nothing to do with which table/row the transaction is modifying? > > Correct. SQLite does not have table-locking or row-locking. Any

Re: [sqlite] what is server-process-edition?

On 26 Mar 2018, at 8:57am, Marco Bambini wrote: > So it has nothing to do with which table/row the transaction is modifying? Correct. SQLite does not have table-locking or row-locking. Any locks in a SQLite database lock the entire database. This is a fundamental aspect of

Re: [sqlite] what is server-process-edition?

So it has nothing to do with which table/row the transaction is modifying? In your example connection 2 always returns with an error on COMMIT? Seems like the improvement is only on when the error occurs and not on concurrency or am I missing something? -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] what is server-process-edition?

On 26 Mar 2018, at 8:09am, Marco Bambini wrote: > Is there a better formal description about the "transactions may not overlap" > sentence? > Is there any example about overlapping transactions? Overlapping transactions occur when a second connection does a BEGIN before the

Re: [sqlite] what is server-process-edition?

Is there a better formal description about the "transactions may not overlap" sentence? Is there any example about overlapping transactions? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs >> The begin-concurrent branch >>

Re: [sqlite] what is server-process-edition?

> Le 22 août 2017 à 12:05, Gelin Yan a écrit : > > Hi Rowan > > Thanks for your hints. The README also mentions begin-concurrent. Do you > know what it is? > > Regards > > gelin yan The recent post by Richard Hipp to this mailing-list (August, 4th), covers this. Copy

Re: [sqlite] what is server-process-edition?

Hi Rowan Thanks for your hints. The README also mentions begin-concurrent. Do you know what it is? Regards gelin yan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] what is server-process-edition?

https://sqlite.org/src/artifact/0c6bc6f55191b690 (it was linked recently by Richard Hipp in another thread, to pre-empt questions of "how did you find that" :) ) -Rowan On 22 August 2017 at 10:22, Gelin Yan wrote: > Hi All > >I noticed there is a tag called

[sqlite] what is server-process-edition?

Hi All I noticed there is a tag called server-process-edition in the timeline but failed to find any related documents. I am curious what it is. Regards gelin yan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org