Repeating Events Question

Posted At : June 25, 2007 12:51 PM
Related Categories: Web Dev

Just started looking into setting up recurring events in a calendar for an application of mine. I haven't had to deal with this before and to be honest I don't want to invent something that must have a standard out there. I would rather use the established methodology. I searched around the ColdFusion world a bit, but haven't found anything. I then started searching around for anything relating to it. I found lots of wiki's with info like "we need to do x" but not much that gave me a sense that there is a tried and true way to do store and search them.

I can easily enough make a schema for storing recurring events (monthly, weekly, every x days, etc). The tough part comes in doing proper searches. Ideally there is only one query result. Do people make temp tables of actual records for events, populated by the recurring event record? It would work, but seems wasteful. How far out would you populate?

What have you done to deal with repeating events?

Comments (1) |

Print |

del.icio.us |

Digg It! | 1592 Views

TweetBacks

Comments

[Add Comment] [Subscribe to Comments]

Yes, there is a standard already in place. The iCal specification already has a well formed standard for the description of events, their recurrence, etc. It's a lot to wade through, and at my last check their wasn't a good db schema anywhere I could get my hands on, but there used to be quite a few people working with it for Mozilla's Sunbird project.

The Developer's Guide on the Mozilla site states that both the Sunbird and Lightning projects utilize SQLite for it's underlying storage engine, and even have links into the code used to store events, etc.

http://wiki.mozilla.org/Calendar:Dev_Guide

# Posted By Cutter | 6/26/07 7:30 AM

[Add Comment]