SQLite doesn't provide callbacks of this type. As well as any other RDBMS. Pavel
On Thu, Apr 29, 2010 at 7:21 AM, Serdar Genc <serdar.g...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
