From: Darrin Domoney <ddomoney@emergingfrontiers.ca>
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
To: pgsql-admin@postgresql.org
To: pgsql-novice@postgresql.org
To: pgsql-php@postgresql.org
Subject: Event recurrence - in database or in application code ????
Date: Tue, 20 Aug 2002 08:15:48 -0500
Message-ID: <FEEFJMJKKPINIKCCCCBJCEGACAAA.ddomoney@emergingfrontiers.ca> (raw)
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).
Ideally I would like to be able to generate an event off a template
appointment (initial appt)
and have it schedule identical appointments hourly, daily, weekly, monthly,
or by selectable
range (ie: first tuesday every month). I would also like to have the
capability to remove an
appointment and leave others (much like using C pointers - I think)or to
remove all
(cascading delete).
Any suggestions, etc gratefully appreciated.
Darrin
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: ddomoney@emergingfrontiers.ca, pgsql-general@postgresql.org, pgsql-admin@postgresql.org, pgsql-novice@postgresql.org, pgsql-php@postgresql.org
Subject: Re: Event recurrence - in database or in application code ????
In-Reply-To: <FEEFJMJKKPINIKCCCCBJCEGACAAA.ddomoney@emergingfrontiers.ca>
* 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