Re: Event recurrence - in database or in application code ???? - Mailing list pgsql-sql

From Robert Treat
Subject Re: Event recurrence - in database or in application code ????
Date
Msg-id 1029968600.19543.46.camel@camel
Whole thread Raw
In response to Re: Event recurrence - in database or in application code ????  (Mark Stosberg <mark@summersault.com>)
Responses Re: Event recurrence - in database or in application code ????
List pgsql-sql
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





pgsql-sql by date:

Previous
From: Bhuvan A
Date:
Subject: Re: Trigger/Function problem
Next
From: Mark Stosberg
Date:
Subject: Re: Event recurrence - in database or in application code ????