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

I not sure how to use os_unix.c. Are there any easy to follow examples in python? On Mon, Jul 1, 2019 at 9:08 PM Simon Slavin wrote: > You might want to take a look at the standard VFSen: > > > > At a low level, SQLite depends on the

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

I don't have good answers for you as I'm not familiar with locking, but I'd suggest reading the comments in SQLite's os.h file (starting around line 91 at the moment) which I found interesting. For Python it looks like it'd be something involving the fcntl module for Unix or the msvcrt module

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

On Tuesday, 2 July, 2019 13:26, Peng Yu : >I not sure how to use os_unix.c. Are there any easy to follow >examples in python? YOU do not use os_unix.c. Perhaps you can state what it is that you are trying to accomplish. For example: I would like to know how I drive a car to the

Re: [sqlite] modify table (again)

On 7/1/19, Thomas Kurz wrote: > > I really followed the 12-step ALTER TABLE schema and stumbled upon the > following problem: Step 3 and Step 8 need to be modified to also record the content of VIEWs in addition to INDEXes and TRIGGERs. I am working on the revised text now. -- D. Richard Hipp