I'm looking to add a feature to a mobile app that lets its users schedule events (including recurring ones). An example of an event could be Event A repeats every month on the 3rd of the month starting on March 3, 2011
.
To be honest I don't know where to begin. After searching SO for a while I came across this answer to a question about representing and detecting recurring events in a relational DB. Briefly, the answer suggests creating two SQL tables (events & meta) where meta holds onto the repeat information for each record inside the events table. Using a join statement and a given date the provided SQL query will return those events that match the given date.
My question is, in relation to a mobile app, what are some meaningful approaches to implementing a scheduling system with support for recurring events? is the answer from the above link the right way to do this?