Re: [sqlite] sqlite3_interrupt() for controlled interruption

This is exactly what I need. Thanks very much! Mi Chen -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Tuesday, December 03, 2013 7:46 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite]

Re: [sqlite] sqlite3_interrupt() for controlled interruption

On 12/3/2013 9:26 PM, Chen, Mi wrote: I want to use sqlite3_interrupt() to interrupt the statement that is executing sqlite3_step() for the first time in the worker. It is mutex protected so I already make sure that when sqlite3_interrupt() is called, my worker thread is running

[sqlite] sqlite3_interrupt() for controlled interruption

I run into an issue where I have a database connection that have quite a few queries that were suspended due to managed priorities... I have two threads, the control thread (UI), and a sqlite3 worker thread. I want to use sqlite3_interrupt() to interrupt the statement that is executing

Re: [sqlite] SQLite version 3.8.2 running 2.5x faster for some queries.

On Tue, 3 Dec 2013 11:29:03 -0800 Scott Hess wrote: > Probably we should add a new API that allows the application > > to state auxiliary properties about application-defined functions > > (such as whether or not it is "constant", whether or not it can > > return NULL, whether

Re: [sqlite] VB.net project using Windows CE and SQLite on a handheldPsion terminal

J Trahair wrote: > > Thank you - System.Data is of course referenced in the project already. > Does Windows CE as a target device need a different version of > System.Data? The one referenced is the one in C:\Program > Files\Microsoft.Net\SDK\Compact Framework\v2.0\Windows CE folder. > I'm

Re: [sqlite] SQLite ver: 1.0.89 issue

Nikola Boyadjiev wrote: > > We are also using SQLite Expert Personal v 3.5.5.2423 ( > http://www.sqliteexpert.com/download.html ) to view our > database. > Since the above mentioned tool no longer uses System.Data.SQLite, per their version history, it would seem to be an issue with the data in

Re: [sqlite] PHP + SQLite + NFS = No go?

On 3 Dec 2013, at 4:23pm, Scott Baker wrote: > My VPS provider mounts my /home partition via NFSv3 and it's causing me > all kinds of headaches. I have my website served from ~/html/ using > SQLite as the DB and I'm constantly seeing hung Apache processes that > are threads

Re: [sqlite] Concrete example of corruption

On 3 Dec 2013, at 4:09pm, L. Wood wrote: > Here is a cross-platform idea: > > Add a new mode where the journal is opened once for reading/writing when > first needed and left open until the database is closed (as opposed to the > default way, to repeatedly create/delete the

Re: [sqlite] Concrete example of corruption

> Metadata is not cross-platform. That would only work on a mac. Here is a cross-platform idea: Add a new mode where the journal is opened once for reading/writing when first needed and left open until the database is closed (as opposed to the default way, to repeatedly create/delete the

Re: [sqlite] SQLite ver: 1.0.89 issue

Nikola Boyadjiev wrote: > > Out App was working file until we changed the version to 1.0.89 and then we > started having weird behavior. We checked the database and out code for couple > of days trying to find where the problem is. We ran integrity check on the > database and its fine.

Re: [sqlite] VB.net project using Windows CE and SQLite on a handheldPsion terminal

Thank you - System.Data is of course referenced in the project already. Does Windows CE as a target device need a different version of System.Data? The one referenced is the one in C:\Program Files\Microsoft.Net\SDK\Compact Framework\v2.0\Windows CE folder. J Trahair On 02/12/2013 20:58, Joe