Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7UEiBf42461 for ; Thu, 30 Aug 2001 10:44:11 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7NIXNP61216 for ; Thu, 23 Aug 2001 14:33:23 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f7NI6af89664 for pgsql-sql@postgresql.org; Thu, 23 Aug 2001 14:06:36 -0400 (EDT) (envelope-from news) From: "Jason Charette" X-Newsgroups: comp.databases.postgresql.sql Subject: HELP: Trend reporting Date: Thu, 23 Aug 2001 14:05:49 -0400 Organization: Cadlink Technology Lines: 26 Message-ID: <3b8545fd$1@freya.cadlink.com> X-Complaints-To: abuse@storm.ca X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Original-NNTP-Posting-Host: jasonc.ottawa.cadlink.com X-Original-Trace: 23 Aug 2001 14:05:49 -0400, jasonc.ottawa.cadlink.com To: pgsql-sql@postgresql.org X-Archive-Number: 200108/366 X-Sequence-Number: 4618 Hello newsgroup buddies, I am looking for information on trend reporting. We run Linux, PostreSQL, Apache and PHP4. We have a series of scripts that track customer usage through our sites, and give us similar information to what is found in the Apache logs, but with more data. I now find myself in the position of having to create "trend reports" or "common routes through our site". Any search I have done has yielded many commercial products that will do this for me, but, unfortunately, I am looking more for a tutorial on how to do this, rather than a product that will do it for me. Essentially, I would like a tutorial(s) or article(s) that discusses this topic, preferably something along the lines of my afforementioned setup (I would like to minimize the amount of converting I have to do). If anyone can help, in any way, shape or form, it would be greatly appreciated. Thanks in advance, Jason