|Do you know where your variables are?
storing and 'understanding' complex calendar events (including recurring events)by schweini (Friar)
|on May 26, 2006 at 19:58 UTC
schweini has asked for the wisdom of the Perl Monks concerning the following question:
I'm playing around with programming a little community-driven 'night life' website, and the core functionality is planned to be the listing of current and upcoming events.
My question is what the most efficient and elegant way of storing events in a database(mysql) would be - including recurring events of different types ('every 2nd tuesday', 'every 3rd monday of a month', 'every 15th of a month'). My main problem is how to store this information in a database in a way that would allow me to efficiently find out if an event applies to a given date. I thought about pre-calculating actual event-dates, but this strikes me as very 'ugly'.
I tried a couple of searches, but maybe i used the wrong keywords or something, because i didn't find anything regarding the efficancy of storing and retrieving this kind of information.
Thanks in advance for any help or pointers to modules, and stuff like that,