Re: [sqlite] Terminating a query

Nuno Lucas wrote: > On Tue, Jun 9, 2009 at 1:53 AM, Jeremy Smith wrote: > >> I'm running SQLite in a thread. If the user hits 'Cancel' in my GUI, I >> want (notified by setting a flag variable) SQLite to stop the query and >> shut down gracefully. I tried closing the

Re: [sqlite] Terminating a query

On Tue, Jun 9, 2009 at 1:53 AM, Jeremy Smith wrote: > I'm running SQLite in a thread. If the user hits 'Cancel' in my GUI, I > want (notified by setting a flag variable) SQLite to stop the query and > shut down gracefully. I tried closing the thread with TerminateThread, >

[sqlite] Terminating a query

I'm running SQLite in a thread. If the user hits 'Cancel' in my GUI, I want (notified by setting a flag variable) SQLite to stop the query and shut down gracefully. I tried closing the thread with TerminateThread, but the database cannot be queried after this, and the entire program has to be

[sqlite] Lemon parser : compile error when using "%token_destructor" directive

Hi List, This is the only place I found to ask for "lemon parser" error. When trying to use the "%token_destructor" directive: %include { #include void token_dtor (struct Token * t) { fprintf(stderr, "In token_destructor: t -> value=%s\n", t -> value); } } %token_destructor {

Re: [sqlite] Working with a new DB every 5 minutes

On 8 Jun 2009, at 8:07pm, Mohit Sindhwani wrote: > I'm having a problem that I'm trying to find an elegant solution > to. I > have a database that stores real-time information - this information > is > replaced by new values every 5 minutes and has about 30,000 entries. > Once a new

Re: [sqlite] Working with a new DB every 5 minutes

Mohit Sindhwani wrote: > Hi Everyone, > > I'm having a problem that I'm trying to find an elegant solution to. I > have a database that stores real-time information - this information is > replaced by new values every 5 minutes and has about 30,000 entries. > Once a new database is made

Re: [sqlite] Working with a new DB every 5 minutes

Pavel Ivanov wrote: >> * Getting rid of the old files - I'm on Windows and would need to see >> the equivalent way of your Unix suggestion. >> > > I don't think you have good options here. One option is to make > continuous retries while remove() returns error. Another option I > believe

Re: [sqlite] Working with a new DB every 5 minutes

> * Getting rid of the old files - I'm on Windows and would need to see > the equivalent way of your Unix suggestion. I don't think you have good options here. One option is to make continuous retries while remove() returns error. Another option I believe would be to change SQLite code to open

Re: [sqlite] synchronizing sqlite local data base to a remote data base

You can use Microsoft Sync Framework if your platform is Microsoft Windows. 2009/6/8 Mohey Eldin Hamdy > Hey got a question, > > I am trying to synchronize an sqlite local data base with a remote mssql > data base. I wasn't able to find any listed function at >

Re: [sqlite] Shared binary plus static lib

Mark Constable wrote: > > > Yikes, that will hurt when I go to build on a TCL-less system. > There are stand-alone Tcl binaries for many platforms, should that ever be a problem for you and you don't want to install a full package. Both etcl and freewrap are good products. They come with

Re: [sqlite] Working with a new DB every 5 minutes

I'd create another special file (maybe even database) that will keep information about current file that your program should be working with. So separate process will create new database and then update this file. And program will just read this file and then work with database mentioned in the

Re: [sqlite] synchronizing sqlite local data base to a remote data base

Hi, What Simon is right. When solving a similar problem in the past I created special tables in both databases which i filled from triggers on the data tables. These tables contained the changed data which i then could reproduce on the other database using a special deamon process. However,

[sqlite] Working with a new DB every 5 minutes

Hi Everyone, I'm having a problem that I'm trying to find an elegant solution to. I have a database that stores real-time information - this information is replaced by new values every 5 minutes and has about 30,000 entries. Once a new database is made available, I should start using that

Re: [sqlite] synchronizing sqlite local data base to a remote data base

On 8 Jun 2009, at 7:30pm, Mohey Eldin Hamdy wrote: > I am trying to synchronize an sqlite local data base with a remote > mssql > data base. I wasn't able to find any listed function at > http://www.sqlite.org/c3ref/funclist.html to do something like that. > Any > ideas please. The sqlite3

[sqlite] synchronizing sqlite local data base to a remote data base

Hey got a question, I am trying to synchronize an sqlite local data base with a remote mssql data base. I wasn't able to find any listed function at http://www.sqlite.org/c3ref/funclist.html to do something like that. Any ideas please. Thanks, Mohy ___

Re: [sqlite] Slow Transaction Speed?

On Wed, May 27, 2009 at 08:05:00AM -0400, pyt...@bdurham.com wrote: > Dr. Hipp, > > > Your OS and filesystem configuration have a big impact too. I've notice, > > for example, that transactions are really slow on RieserFS on Linux > > compared to Ext3. > > In your experience, which Linux file

Re: [sqlite] SQLite Version 2.1

The 2.8 version should be able to read the 2.1... although it will try to convert the format first, so make a backup copy of the original. On Mon, Jun 8, 2009 at 12:35 PM, Marcus Haßmann wrote: > The empty database in an example. > I have to do an investigation for a non empty

Re: [sqlite] SQLite Version 2.1

That is not what I want. I want to develop a little tool for later investigations too, not only for this one. Marcus Haßmann Simon Slavin schrieb: > On 8 Jun 2009, at 1:50am, Shane Harrelson wrote: > > >> http://www.sqlite.org/sqlite-2.8.17.tar.gz I think is the oldest >> version still

Re: [sqlite] SQLite Version 2.1

The empty database in an example. I have to do an investigation for a non empty database... Marcus Haßmann Shane Harrelson schrieb: > http://www.sqlite.org/sqlite-2.8.17.tar.gz I think is the oldest > version still available from the SQLite website. > > BTW, I'm not certain what kind of

Re: [sqlite] large db performance considerations

Hi Simon, Thanks for your response. > You need an index, obviously. You can't have an index on a VIRTUAL > table. Yes, I did try on a regular table (not FTS3) and added the indices I described (one each on Author, Content and Category) and still did not notice any performance improvement.

Re: [sqlite] SQLite Exception: SQLite BUSY

Thanks for the reference :-). -- Thanks and Regards, Manasi Save > On 8/06/2009 8:22 PM, Manasi Save wrote: >> Hi All, >> >> I have one query regarding SQlite Busy error. >> >> Can anyone explain me in what cases this error occurs? > > Yes. You should be able to explain it to yourself after

Re: [sqlite] SQLite Exception: SQLite BUSY

On 8/06/2009 8:22 PM, Manasi Save wrote: > Hi All, > > I have one query regarding SQlite Busy error. > > Can anyone explain me in what cases this error occurs? Yes. You should be able to explain it to yourself after reading relevant parts of: http://www.sqlite.org/faq.html

[sqlite] SQLite Exception: SQLite BUSY

Hi All, I have one query regarding SQlite Busy error. Can anyone explain me in what cases this error occurs? -- Thanks in advance! Regards, Manasi Save ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Shared binary plus static lib

On Sunday 07 June 2009 14:26:07 Mark Constable wrote: > Would anyone have a clue as to how I could end up with > /usr/lib/libsqlite3.so.0 > as well as /usr/bin/sqlite3 and /usr/lib/libsqlite3.a ? Another one for the list archives. I'm not sure if this is 100% correct but the result works for me

Re: [sqlite] large db performance considerations

On 8 Jun 2009, at 4:45am, Paul Perry wrote: > The latest content I have added, has over 31,000 records. A basic > select, > such as: > > Select Content from BookContent where DocumentID = 10; > takes nearly 15 seconds. Are there any ways to optimize this? You need an index, obviously. You