Perhaps I've missed something, but in all this discussion no one has
asked what it is you're trying to do. All I know is that you want to
schedule something in a database and then check that database every
minute (or so) and process the scheduled somethings.
Generally speaking, 'at' is the simplest alternative. I've used 'at'
in similar circumstances (though never from the web). However, this
does not meet your needs of using a cached database connection.
Another possibility is to write a daemon yourself and use some type
of IPC or RPC to schedule events to that daemon. As the daemon runs,
it just forks off and processes the scheduled jobs as those times
pass. This requires some crafty work with sig alarm or other
mechanism. I once remember seeing an alarm lib somewhere that would
allow you to set more than one alarm.
Without knowing what it is you're trying to implement, I think we've
just about exhausted the possibilities for a scheduler within
mod_perl/apache.
Robert Landrum
--
"Only two things are infinite: The universe, and human stupidity. And I'm not
sure about the former." --Albert Einstein
