Re: [sqlite] An issue about using ORDER and GROUP

I know sum() is work. This issue occurs only for TEXT. When I use a user-defined aggregate CONCAT() it led to a stange result. suppose the length of original text is 1 length of output text via GROUP+concat() is 5 while via ORDER, the length of final text is 1 (should be 5) ps1. run on winxp,

Re: [sqlite] sqlite3_exec function error:database is locked

Have you raised indices on the keys you use in your queries? varunkumar wrote: i have 40 columns table in my database. now my database size is 23MB . untill now my database has 78752 rows(records). when i am query database it is taking 10 seconds of time . my database performance is

Re: [sqlite] An issue about using ORDER and GROUP

Wakka <[EMAIL PROTECTED]> wrote: > I get into trouble about using GROUP and ORDER. > > When I use GROUP and ORDER together, aggregate function > can't work, could someone explain it? Works OK when I try it. I don't have your custom concat() function, so I had to use sum() instead. Here is my

[sqlite] An issue about using ORDER and GROUP

I get into trouble about using GROUP and ORDER. When I use GROUP and ORDER together, aggregate function can't work, could someone explain it? ### create two table CREATE TABLE book (id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE); INSERT INTO book VALUES (0); INSERT INTO book VALUES (0); INSERT

Re: [sqlite] sqlite3_exec function error:database is locked

i have 40 columns table in my database. now my database size is 23MB . untill now my database has 78752 rows(records). when i am query database it is taking 10 seconds of time . my database performance is degrading. i want to improve my database performance what should i do to improve

Re: [sqlite] Accessing external applications from within SQLite triggers

Your trigger can record the change notification in a separate table. So long as the system processing the change notifications cleans them up as it goes, this can be reasonably efficient. -scott On 10/13/07, Vladimir Stokic <[EMAIL PROTECTED]> wrote: > > Spot on! I could monitor the change of

Re: [sqlite] Accessing external applications from within SQLite triggers

Spot on! I could monitor the change of the file, but, like you said, that does not tell me _what_ changed, so I would still have to poll the database. And yes, I would be looking for a single row change in a database of 30+ tables with 75000+ rows each. Trevor Talbot-2 wrote: > > A couple

Re: [sqlite] Accessing external applications from within SQLite triggers

A couple other things come to mind here, that might be relevant to what you're doing: * A trigger that has a "final" side effect, like signaling another process, will both have that effect early (before the transaction is committed), and will have that effect even if the transaction is later

Re: [sqlite] Accessing external applications from within SQLite triggers

Thanks! Something like that has already crossed my mind, but I was just wondering if there was a way to achieve that goal using the existing interfaces. Now, it looks like this solution is the only one to my problem. Vladimir Stokic John Stanton-3 wrote: > > If you have access to the Sqlite

Re: [sqlite] Accessing external applications from within SQLite triggers

Vladimir Stokic wrote: I agree that the solution with the semaphore is a very elegant one, but that still does not solve the problem of having to define the custom function to be called from the trigger over and over again. On the other hand, if the function is not going to be called from the

Re: [sqlite] Accessing external applications from within SQLite triggers

I agree that the solution with the semaphore is a very elegant one, but that still does not solve the problem of having to define the custom function to be called from the trigger over and over again. On the other hand, if the function is not going to be called from the trigger, but from the app

Re: [sqlite] Accessing external applications from within SQLite triggers

If you use a semaphore it is independent of the processes currently running and has nothing to do with a Sqlite connection. Your custom function is called, signals the semaphore and exits. When the semaphore is signalled the process waiting on it is activated. In your example myfunc

Re: [sqlite] Accessing external applications from within SQLite triggers

On 10/13/07, Vladimir Stokic <[EMAIL PROTECTED]> wrote: > I tried to do what you and Igor said, but I found out that it does not really > work that way. I can make a user-defined function, but it stays active only > while the current connection is open. It is not persisted in the "database". >

Re: [sqlite] Accessing external applications from within SQLite triggers

I tried to do what you and Igor said, but I found out that it does not really work that way. I can make a user-defined function, but it stays active only while the current connection is open. It is not persisted in the "database". It does not work even if I try it from the same application. Here

Re: [sqlite] Accessing external applications from within SQLite triggers

You could achieve your result by defining a semaphore. A custom function in A would signal the semaphore and activate a thread in B when the DB changed. The thread in B would be waiting on the semaphore Both Unix and Windows implement semaphores in a similar manner. A slightly higher level

RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question

Hallo Odekirk Shawn, SQLite use up to an 64Bit signed Integer for Primary Keys, even on non 64Bit-Systems! Integer PrimaryKeys are always autoincrementing. When you don't specify it it uses after (2^63)-1 a random free positiv value. When you write autoincrement for your create table it never

Re: [sqlite] Accessing external applications from within SQLite triggers

Thanks for the advice. I appreciate it. However, I am rather new at IPC, so I would like to ask you for a bit more detailed explanation. Is there some c/c++ library that would make sending and IPC package over to app B possible? I do not want to do anything exotic here. A simple string sent over