Do you have any idea how I can get a callback from SQlite for this issue? Thanks, Serdar -> http://www.iptakip.com
On Thu, Apr 29, 2010 at 2:17 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > > Our system is a real-time applcation and delivering this data to > subscribers > > is very > > important. > > When you insert infogram notify other interested parties so that they > can work with it. Each OS has a lot of different IPC mechanisms > specially designed for this purpose. If you are working in a single > process your life even easier than that. > > > Pavel > > On Thu, Apr 29, 2010 at 7:11 AM, Serdar Genc <serdar.g...@gmail.com> > wrote: > > I don't want to do this with sleep.. If there is a callback mechanism for > > sqlite then > > it is preferable to implement this by using them. We are trying to > implement > > sqlite > > in our system and this is a crucial requirement for our API that we > provide > > to the users. > > Our system is a real-time applcation and delivering this data to > subscribers > > is very > > important. > > > > On Thu, Apr 29, 2010 at 2:04 PM, Pavel Ivanov <paiva...@gmail.com> > wrote: > > > >> Database engines never worked and hopefully never will work this way. > >> You can easily implement it in your application: execute query, if no > >> new infograms found then sleep for some time, check that total time > >> passed doesn't exceed your limit, repeat everything from beginning. > >> > >> > >> Pavel > >> > >> On Thu, Apr 29, 2010 at 6:46 AM, Serdar Genc <serdar.g...@gmail.com> > >> wrote: > >> > My case is a little bit complex. Let me make a brief explanation about > >> it. > >> > Suppose you write a complex SQL query (preferably a select query) and > >> send > >> > this as a parameter > >> > and waiting for its return value.. In this case, I would like to add a > >> > defined period for the sqlite query > >> > to wait. (30 seconds for instance). If infograms are inserted into my > >> > database during this period then I > >> > would like to be notified and take it. > >> > > >> > sqlite_execute_select_query(string query, int timeout); // this call > will > >> > suspend the execution of the application > >> > > >> > if an infogram is inserted that we would like to get according to our > SQL > >> > query then we continue the execution and > >> > obtain that query. > >> > > >> > I think of creating a view for that SQL query and try to create > trigger > >> for > >> > that view bla bla but no progress till now.. > >> > > >> > Has anyone got any idea how to do so.. > >> > > >> > Thanks in advance, > >> > Serdar > >> > > >> > -> http://www.iptakip.com > >> > _______________________________________________ > >> > sqlite-users mailing list > >> > sqlite-users@sqlite.org > >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users