Re: [Firebird-devel] Planning the post v3 development

[Alex <pes...@ma...>]

On 04/28/2014 09:59 PM, Dmitry Yemanov wrote:

>> A scheduler for firebird would totally eliminate my own use of custom
>> applications tied to database events/time events.
> Architecturally, Firebird database is not active without user
> connections. This slightly changes with the LINGER support, but not so
> much. So the question is who should be waiting for the timer events when
> nobody is connected. And if it should be the server's (not the engine's)
> feature, then what to do with the embedded setup?

We may use OS native scheduler as timer with firebird implementing SQL 
interface to control it. This will work for any kind of setup, including 
embedded.  The disadvantages are that timers get out of transaction 
control and we will need 2 absolutely different implementations - posix 
and windows.