Re^3: storing and 'understanding' complex calendar events (including recurring events)

so this would mean that pre-calculating dates would be my only real option, i guess? Assuming that i have a couple of hundred events, there would be no other way to simply call something like
@events = showEvents( $date );
?

Comment on Re^3: storing and 'understanding' complex calendar events (including recurring events)

Replies are listed 'Best First'.
Re^4: storing and 'understanding' complex calendar events (including recurring events) by Tobin Cataldo (Monk) on May 26, 2006 at 20:54 UTC
The events would still need to be tied to a date though. I am not sure how to model this data exactly but I would approach it as event 1->N date property. Then you would calculate your date ranges for each date property once and connect events to dates. I am assuming some sort of relational db. Date:Manip is slower than some of the other options. But it is super powerful.	[reply]
Re^4: storing and 'understanding' complex calendar events (including recurring events) by socketdave (Curate) on May 26, 2006 at 20:59 UTC
Well, you either need to store the definition for the event or the complete list of events. Storing the definition and expanding it to the full list when needed keeps the database of events simple and easy to work on. On the other hand, it's probably going to be pretty slow when you need to go through the list and calculate if each event matches a given day. The opposite is true of storing an expanded list of dates for each event. It's a trade like everything else.	[reply]