[ciapug] calendars

Chris Van Cleve ciapug@cialug.org
Thu, 5 May 2005 13:11:25 -0500


I do precisely what Tony is talking about. I'm a firm believer (comes 
from years as a DBA) of storing actual data and creating calculated 
data on-the-fly as needed.

Chris VC

On May 5, 2005, at 12:37 PM, Tony Bibbs wrote:

> Depends on your business requirements.
>
> Frankly, I'm a fan of storing the start and end dates because most 
> calendar related use cases need to know the end date.  In the off 
> chance you need the duration I think you are best to calculate it.  
> However if you have some uses cases where you need duration you may 
> consider using that.  However, it is worth noting that a two day event 
> running from 8am-4pm would give the duration method a bit of a fit.  
> Whereas if you calculate the duration it can handle that scenario.
>
> --Tony
>
>
>
> Scott Phillips wrote:
>> Last night we talked about online calendars.  Looking for opinions...
>> Do you think it's better to store both the start and end times or 
>> simply the start time and duration?  (I assume the first, but just 
>> found a couple examples of people doing the latter.)
>> Scott Phillips
>> Web Developer
>> Cowles Library, Drake University
>> (515) 271-2975
>> _______________________________________________
>> ciapug mailing list
>> ciapug@cialug.org
>> http://cialug.org/mailman/listinfo/ciapug
> _______________________________________________
> ciapug mailing list
> ciapug@cialug.org
> http://cialug.org/mailman/listinfo/ciapug
>
>