Hi Joe,
I'm going to try and build my own version of basex with the option to turn off all locking. If I get something acceptable I will send a pull request for it to be merged in.
did you already have to look at the code?
My impression is that we could quite easily add a QUERYLOCKING that, when disabled, only considers manual locking flag, which can e.g. be seat via the query:read-lock and query:write-lock options. But I dont’ know if that would help, as you mentioned you’d have to choose the database dynamically.
You mentioned that you are expecting the database to be locked for 1-2 seconds. Maybe there is some chance to speed up your write operations?
Best, Christian