[sf-perl] Bay Area Tech Gnus [ot]

David Fetter david at fetter.org
Fri Jun 12 15:15:58 PDT 2009

On Fri, Jun 12, 2009 at 01:56:33PM -0700, Rick Moen wrote:
> Quoting David Fetter (david at fetter.org):
> > Is the raw data available?  I'd like to see about munging it into
> > an iCal feed, preferably without scraping your page :)
> I keep thinking of iCal (and RSS), myself.  Just haven't gotten to
> it, and not sure how best to do it.

There's a Data::ICal which can create such files. :)

Also cool, even though it's PHP, is PHP iCalendar, which brings iCal
feeds together on a web page.

> The raw data are in MySQL tables, queryable only from localhost, and
> of course maintained on an ongoing basis by yrs truly.  What you're
> seeing in the calendar portion of the (PHP) page is rows drawn from
> table "events".  The group descriptions below the calendar are in
> table "groups".  Once a month, a cronjob runs that populates a new
> month of "events" rows, based on data parsed from table
> "eventtemplate".

Interesting :)


    o/` JOIN us now() and share the Postgres o/` ;)
David Fetter <david at fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter at gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

More information about the SanFrancisco-pm mailing list