I am using the Scheduler for scheduling upcoming events, some of which could be recurring. I understand that the standard RRULE format is used to denote recurrences, and that 3rd party libraries, like DDay.ical, can be used to expand those events once they're pulled down from the database. However, in the interest of efficiency, I would prefer to be able to return recurring events for a given date range via a SQL query.
The reason for this is that a web API service will be used to return these recurring events, so there should be no reliance on the Scheduler calendar when being consumed by this service. I want to avoid having to retrieve all recurring events, then looping through them, parsing/expanding one-by-one in order to throw out the ones that do not apply.
All said, does anyone have a good method for querying these events, based on their RRULE definitions, within the database? I imagine something like this is going on within the Scheduler components, but I'm not completely sure.