SQLite Forum

Extension Wraping functions with ability to throw error and abort query
Login
Does anyone know of a wrapper extension which has a function wrapping other functions to monitor the time that has passed and if it exceeds an argument value it throws an error or interrupt and aborts the query? I am using the JSON1 extension and periodically I write a bad query and the database freezes and stops working. Something like select watcher_function(json_extracts(arguments), 30) from table.. where 30 would be the number of seconds the json_extract function could run or abort. On the desktop you can use cmd-c, however, I am not using the command-line tools.

Thanks for the input