Re: [sqlite] How lock is implemented upon write?

2019-07-05 Thread Jens Alfke
> On Jul 4, 2019, at 6:57 AM, Peng Yu wrote: > > So the fundamental C API that unix_os.c is based on is the only > following but nothing else? > > - fcntl: http://pubs.opengroup.org/onlinepubs/9699919799/functions/fcntl.html > - flock: https://www.freebsd.org/cgi/man.cgi?query=flock=2 I

Re: [sqlite] How lock is implemented upon write?

2019-07-05 Thread Keith Medcalf
On Friday, 5 July, 2019 12:26, Peng Yu : >There is something shown below that uses SQLite3, but it still does >not go deeper into reimplementing using the raw code available from >SQLite3. This implementation merely calls SQLite3.

Re: [sqlite] json_group_array( json_object())

2019-07-05 Thread ingo
On 5-7-2019 20:14, Richard Hipp wrote: > Can you please send a complete example? While preparing that the problem was resolved. A search showed that a wrong concatenation || further down caused this result. Something I noticed before when working with json is that my errors in the code result

Re: [sqlite] How lock is implemented upon write?

2019-07-05 Thread Peng Yu
> Here's my guess. OP is trying to implement locking in Python. OP sees that > SQLite does locking and wants to copy code. > > Obviously, that's beyond the range of this mailing list, but just to be > helpful, here's some stackoverflow: > >

Re: [sqlite] json_group_array( json_object())

2019-07-05 Thread Richard Hipp
On 7/5/19, ingo wrote: > The following: > > json_object ( > 'data', json_group_array( > json_object( >'type', type, >'id', notebook_id, >'attributes', json_object( > 'book', book, > 'total_notes', total_notes >), ...etc > > results in: >

[sqlite] json_group_array( json_object())

2019-07-05 Thread ingo
The following: json_object ( 'data', json_group_array( json_object( 'type', type, 'id', notebook_id, 'attributes', json_object( 'book', book, 'total_notes', total_notes ), ...etc results in: