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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-novice pgsql-php pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Jai | 2002-08-20 13:50:55 | Users ip |
Previous Message | Stefan Fiel | 2002-08-20 09:58:01 | password encryption |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-08-20 13:22:04 | Re: PostgreSQL and MySQL in ZDNet article... |
Previous Message | scott.marlowe | 2002-08-20 08:21:48 | Re: Multiple selects versus join |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-08-20 14:50:49 | Re: index is not used |
Previous Message | mila boldareva | 2002-08-20 11:17:33 | index is not used |
From | Date | Subject | |
---|---|---|---|
Next Message | Sub Director Sistemas Informaticos | 2002-08-20 15:47:39 | Can I get the users list straight from the system ? |
Previous Message | Bruce Momjian | 2002-08-20 01:44:33 | Re: About to update the PostgreSQL-Functions in the PHP Manual |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-08-20 14:43:39 | Re: sql subqueries problem |
Previous Message | Dan Langille | 2002-08-20 12:00:28 | Re: bulk imports with sequence |