[...]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.
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.
Build one table for each data type: RECURRENCES - populated with ICal strings DATES - populated with SQL native datetimes SPANS - populated with SQL native datetime spans
- Slurp all RECURRENCES using DT::Format::ICal; query the recurrences using Perl.
- Query DATES and SPANS using SQL.
DateTime::Event::Spreadsheet (still experimental) could be used to aggregate all these into a single object.
- Flavio S. Glock
