iCalendar database schema

Question

Where can I find the iCalendar database schema? The best I can find is the xml schema.

I could use that I suppose but that's a lot of work and I am hoping someone has done it already.

Answer 1

Summarizing the comments and adding my own two cents:

• There is no such thing as the iCalendar database schema.
• Since iCalendar is just some BLOB, in the easiest case you might just store it as a single string field.
• Since you want to query by time-range, you'll probably want at least separate fields for that.
• Recurring events are tricky to get right, because many complicated things can be constructed with iCalendar's RRULEs
  • Calendar Recurring/Repeating Events - Best Storage Method
  • For khal, we decided to simply generate a cache for the next X decades. That means a separate table that maps each event from the event table to a lot of datetime-ranges, which are generated according to the RRULES.