Hi,
Just tried this beast (FYI: compiles and works in 7.6 as well),
however there are some (minor) issues:
- There is no query() method, which is inconvenient for simple
statements like INSERT or DELETE - statement won't be executed
with big_query() unless fetch_row() in result is called, which, in
turn, makes code a bit ugly.
- When sleeping (in case of SQLITE_BUSY) - may be it makes sense
to enable threads? Even 100 ms is quite a lot. Optionally, it
might be useful to allow dynamic configuration of this interval.
- Again when sleeping - there is no limit for sleeping, and (in theory)
it could happen that we will sleep forever (buggy external lock or
so).
Regards,
/Al