dear monks,

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,

-schweini

In reply to storing and 'understanding' complex calendar events (including recurring events) by schweini

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.