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 <[email protected]> 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 <[email protected]> > 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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
