From: | Mark Stosberg <mark(at)summersault(dot)com> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | Darrin Domoney <ddomoney(at)emergingfrontiers(dot)ca>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Event recurrence - in database or in application code ???? |
Date: | 2002-08-22 02:20:54 |
Message-ID: | Pine.BSF.4.44.0208212114500.57753-100000@nollie.summersault.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-novice pgsql-php pgsql-sql |
On 21 Aug 2002, Robert Treat wrote:
> 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?
Perhaps this will answer your question Robert-- one point I didn't
mention before is that I don't allow events events to recur forever,
they have end after some finite number of times. You could add a
birthday and tell it to repeat it once a year for the next 100 years for
example. I wouldn't have to go and add rows for these later though-- the
rows needed for the next 100 years would already be generated in the
events_calendar table.
The only thing that "expires" with my solution is the dates in the
calendar table. I could make the dates run for the next 100 years just
as easy as 28 years, I just figured the system would probably get a significant
revamp sometime in the next quarter century. :)
-mark
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-22 02:21:44 | Re: OT: password encryption (salt theory) |
Previous Message | David F. Skoll | 2002-08-22 02:19:17 | Re: OT: password encryption (salt theory) |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-22 03:23:51 | Re: [HACKERS] [GENERAL] workaround for lack of REPLACE() |
Previous Message | Alvaro Herrera | 2002-08-22 01:15:33 | Re: lower/upper on latin2 encoding |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Ray | 2002-08-22 13:07:53 | Permissions for system tables |
Previous Message | simran | 2002-08-22 02:20:42 | Searching the Database |
From | Date | Subject | |
---|---|---|---|
Next Message | Keary Suska | 2002-08-22 05:06:44 | Re: Nextval Problems |
Previous Message | Tom Haddon | 2002-08-22 00:33:45 | Nextval Problems |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2002-08-22 06:10:27 | Re: [ADMIN] How to execute my trigger when update certain columns |
Previous Message | Robert Treat | 2002-08-21 22:23:19 | Re: Event recurrence - in database or in application code ???? |