From: Kumar <sgnerd@yahoo.com.sg>
To: josh@agliodbs.com
To: Peter Eisentraut <peter_e@gmx.net>
To: psql <pgsql-sql@postgresql.org>
Subject: Re: Calendar Scripts - Quite a complex one
Date: Wed, 7 Jan 2004 11:36:16 +0530
Message-ID: <001701c3d4e4$62fc4dc0$7502a8c0@hdsc.com> (raw)
References: <00a501c3d41b$2dc9a0e0$7502a8c0@hdsc.com>
<200401061956.57063.peter_e@gmx.net>
<200401061413.12096.josh@agliodbs.com>
Hi,
The complexity comes while scheduling the appointments. Let us say, I have
scheduled so many meetings in my calendar of various schedules like daily, 3
days once, weekly, bi weekly. monthly, bi monthly, etc.
While I open the calendar for end of this year (say Dec 2004), I need to
show those meetings in my calendar, but I have data until Jan 2004.
What is the best way to show it. Populating the records from Jan 2004 to Dec
2004 in the pgsql function and display it in the calendar, or just write a
query to generate temporary records only for that Dec 2004 and not storing
them at the database.
Please shed some idea.
Regards
Kumar
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Peter Eisentraut" <peter_e@gmx.net>; "Kumar" <sgnerd@yahoo.com.sg>;
"psql" <pgsql-sql@postgresql.org>
Sent: Wednesday, January 07, 2004 3:43 AM
Subject: Re: [SQL] Calendar Scripts - Quite a complex one
Peter,
> You can probably lift out the complete calendar functionality from an
> existing groupware solution, say, www.egroupware.org. I'm not sure
> whether it's practical to do the calendar things in the database, since
> you will also need a significant amount of intelligence in the client
> to display reasonable calendar graphics, for instance.
But all of the appointments, holidays, etc can and should be stored in the
database, and by using function programming one can automate generating all
of the raw data for the calendar graphics. We do this with our legal
calendaring app.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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: sgnerd@yahoo.com.sg, josh@agliodbs.com, peter_e@gmx.net
Subject: Re: Calendar Scripts - Quite a complex one
In-Reply-To: <001701c3d4e4$62fc4dc0$7502a8c0@hdsc.com>
* 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