Dear SQLite,
I have been using SQLite for a few weeks now, and enjoy using the product.
I am experiencing problems with the locking. Because SQLite uses database locking this forces two major problems:
- I can't read through a record set and use the data to execute updates. For instance, some parsing exercise which cannot be completed using a single SQL command. I have to store all the data locally, get to the end of the query, then execute and update statements.
- I sometimes get SQL_BUSY when heavy loading on database. This exception is hard to handle, forcing a check on every execution or restart of program. This is a bigger problem as this is unpredictable and limiting to the loading I can apply to the DB.
I see in the manual there are plans use Row Locking. This would solve my problems. Allowing me to load the database from multiple processes to a far greater amount without fear of SQL_BUSY. As well as simplifying my programs.
I would be very interested in knowing how this is progressing, as this would allow me to plan my future work.
Thanks for the excellent product,
Ben Clewett.
