Hello,
I'm looking for suggestions on how to store and retrieve events for a
calendering system in SQlite.
For each user there must be:
1) All day events on a specific day.
2) All day events that are repeated over a given date range.
3) All day events that are repeat each day from until canceled.
4) Time specific events on a specific day.
5) Time specific events that repeat daily over a given date range.
6) Time specific events that repeat each day from now until canceled.
("Day-of-week" repeating logic may need to be added well.)
So the questions:
1) How should I be structuring the DB so to store this data sanely.
2) How should I query the DB for a list of events that are scheduled at any
given moment. (across all users.)
3) How should I query the DB for a list of events that are scheduled in any
given time interval? (across all users.)
Thank you,
:)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
