Re: [sqlite] lockfile but using db table row instead of file

2019-09-04 Thread Peng Yu
On 9/4/19, Keith Medcalf wrote: > > On Wednesday, 4 September, 2019 04:40, Peng Yu wrote: > >>The command line program `lockfile` locks based on files. I wants to do the >>same thing but based on a row in a table. For example (this is just one >>example feature, but all other features should

Re: [sqlite] lockfile but using db table row instead of file

2019-09-04 Thread Stephen Chrzanowski
What Keith said, plus, SQLite does not do row locking, period. It's a full file lock when required. SQLite has some embedded functionality to deal with locking things like this, and your program will need to be written to be aware of how to deal with locking. If you're attempting to fix race

Re: [sqlite] lockfile but using db table row instead of file

2019-09-04 Thread Keith Medcalf
On Wednesday, 4 September, 2019 04:40, Peng Yu wrote: >The command line program `lockfile` locks based on files. I wants to do the >same thing but based on a row in a table. For example (this is just one >example feature, but all other features should also be preserved), if a >given row is

[sqlite] lockfile but using db table row instead of file

2019-09-04 Thread Peng Yu
The command line program `lockfile` locks based on files. I wants to do the same thing but based on a row in a table. For example (this is just one example feature, but all other features should also be preserved), if a given row is there, the process will hang unless some other process delete the