Skip site navigation (1) Skip section navigation (2)

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

From: "Darrin Domoney" <ddomoney(at)emergingfrontiers(dot)ca>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>,<pgsql-admin(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>,<pgsql-php(at)postgresql(dot)org>
Subject: Event recurrence - in database or in application code ????
Date: 2002-08-20 13:15:48
Message-ID: FEEFJMJKKPINIKCCCCBJCEGACAAA.ddomoney@emergingfrontiers.ca (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-novicepgsql-phppgsql-sql
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



Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-08-20 14:50:49
Subject: Re: index is not used
Previous:From: mila boldarevaDate: 2002-08-20 11:17:33
Subject: index is not used

pgsql-general by date

Next:From: Jan WieckDate: 2002-08-20 13:22:04
Subject: Re: PostgreSQL and MySQL in ZDNet article...
Previous:From: scott.marloweDate: 2002-08-20 08:21:48
Subject: Re: Multiple selects versus join

pgsql-admin by date

Next:From: JaiDate: 2002-08-20 13:50:55
Subject: Users ip
Previous:From: Stefan FielDate: 2002-08-20 09:58:01
Subject: password encryption

pgsql-php by date

Next:From: Sub Director Sistemas InformaticosDate: 2002-08-20 15:47:39
Subject: Can I get the users list straight from the system ?
Previous:From: Bruce MomjianDate: 2002-08-20 01:44:33
Subject: Re: About to update the PostgreSQL-Functions in the PHP Manual

pgsql-sql by date

Next:From: Stephan SzaboDate: 2002-08-20 14:43:39
Subject: Re: sql subqueries problem
Previous:From: Dan LangilleDate: 2002-08-20 12:00:28
Subject: Re: bulk imports with sequence

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group