Re: Event recurrence - in database or in application code ????

On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote:
>
> Hello Darrin,
>
<snip>
>
> I've been happy with this solution. I think the Perl turned out to be
> fairly easy to understand and maintain, the SQL that needs to be used
> ends up being fairly straightforward, and the performance is good
> because the selects to view the calendar are fairly simple. The one
> drawback is that sometime before 2028, I have to remember to add some
> rows to the calendar table. :)
>

You need to add rows as well as re-populate a bunch of info for
recurring dates that are not listed forward right?

> -mark
>
> http://mark.stosberg.com/
>
>
> On Tue, 20 Aug 2002, Darrin Domoney wrote:
>
> > One of the features that I am attempting to implement in the system that I
> > am building is
> > the capability to schedule events (with recurrence). My question to those of
> > you that are
> > more experienced in postgresql is whether you would implement this
> > functionality in the
> > database level using triggers or at the application code level (PHP).
> >
<snip>
> >
> > Any suggestions, etc gratefully appreciated.
> >

I would strongly recommend you look at the "WebCalendar" project on
sourceforge.

Robert Treat