Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 50347475B67
	for <pgsql-sql@postgresql.org>; Wed, 21 Aug 2002 18:24:18 -0400 (EDT)
Received: from briar.mmrd.com (unknown [208.255.226.182])
	by postgresql.org (Postfix) with ESMTP id A6507475974
	for <pgsql-sql@postgresql.org>; Wed, 21 Aug 2002 18:24:17 -0400 (EDT)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by briar.mmrd.com (8.11.2/8.11.2) with ESMTP id g7LNMiF03156;
	Wed, 21 Aug 2002 19:22:44 -0400
Received: from [172.25.1.55] ([172.25.1.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id g7LMOIx01263;
	Wed, 21 Aug 2002 18:24:19 -0400
Subject: Re: Event recurrence - in database or in application code ????
From: Robert Treat <xzilla@users.sourceforge.net>
To: Mark Stosberg <mark@summersault.com>
Cc: Darrin Domoney <ddomoney@emergingfrontiers.ca>,
	pgsql-sql@postgresql.org
In-Reply-To: <Pine.BSF.4.44.0208202054450.80293-100000@nollie.summersault.com>
References: <Pine.BSF.4.44.0208202054450.80293-100000@nollie.summersault.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 21 Aug 2002 18:23:19 -0400
Message-Id: <1029968600.19543.46.camel@camel>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/305
X-Sequence-Number: 9151

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