#1 2022-03-16 01:46:47

amsdev
Member
Registered: 2011-09-16
Posts: 23

Abort long running sqlite query

Hi,

Please can you add support of sqlite function: sqlite3_interrupt
https://www.sqlite.org/c3ref/interrupt.html

Without this function it's not possible to abort long queries performed in threads via TSQLDBSQLite3ConnectionProperties.

Or maybe I missing something ?

Offline

#2 2022-03-16 05:24:19

edwinsn
Member
Registered: 2010-07-02
Posts: 1,218

Re: Abort long running sqlite query

First time heard of the `sqlite3_interrupt` function, it seems to be very helpful!


Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

Offline

#3 2022-03-16 07:42:57

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,659
Website

Re: Abort long running sqlite query

It is included in mORMot 2.

Upgrade to mORMot 2 if you can.

Offline

#4 2022-03-16 12:30:28

amsdev
Member
Registered: 2011-09-16
Posts: 23

Re: Abort long running sqlite query

I can't (

I use parts of your great framwork in C++Builder (after some changes I have to build most sqlite related parts for BCB), but I can't build moromot2 because of to many compiler issues. I will try to port sqlite3_interrupt from mormot2 to mormot1 myself...

Offline

Board footer

Powered by FluxBB