Has anyone done any work on this?
Basically, I'd like to be able to store these in a way that makes queries like "all the entries for a given month" reasonably efficient.
I've come up with a few thoughts:
- Store each occurrence as a separate entry, and then store the recurrence in a separate table. Generate occurrences as needed and store them. This is somewhat complicated, and not terribly efficient for queries that cause new occurrence generation out into the future. The plus is that it's fairly simple to implement.
- Allow only a fairly limited set of recurrences, store them as iCal strings, and query based on string contents. This limits the flexibility of the system, but is potentially quite efficient.
- ???
What I'd really like to see is some way to query both single events and recurring events within a given timeframe, all in one query that returns a sorted array of occurrences.
This is quite possible with Flavio's cool modules, but how to do this with a SQL backend?
-dave
/*=================================================== VegGuide.Org www.BookIRead.com Your guide to all that's veg. My book blog ===================================================*/
