From: Robert Treat <xzilla@users.sourceforge.net>
To: Mark Stosberg <mark@summersault.com>
Cc: Darrin Domoney <ddomoney@emergingfrontiers.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Event recurrence - in database or in application code ????
Date: 21 Aug 2002 18:23:19 -0400
Message-ID: <1029968600.19543.46.camel@camel> (raw)
In-Reply-To: <Pine.BSF.4.44.0208202054450.80293-100000@nollie.summersault.com>
References: <Pine.BSF.4.44.0208202054450.80293-100000@nollie.summersault.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: xzilla@users.sourceforge.net, mark@summersault.com, ddomoney@emergingfrontiers.ca
Subject: Re: Event recurrence - in database or in application code ????
In-Reply-To: <1029968600.19543.46.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox