Re: Looking for Good and Easy-to-use Reporting Tool

2009/12/16 Su, Alan <Alan(dot)Su(at)daiwausa(dot)com>:
> GUI front end is nice to have but not required. We. have a system that collects network speed information in mill seconds from different hubs and this infor is stored on various Postgre tables. Throughout the day or at end of the day, I need to run a process/job that will summarize these speed data from the tables, and when the number exceeds certain threshold, say 50 ms, I want to generate an alert email to support staff for investigation.
>
> I may expand the requirements further down the road, but main processing logic should stay similar to what I described above. So what's the good tool to use for this background job?
>

Alan, as Kevin Grittner suggested, maybe you could just write a script
using bash. Otherwise, if you need more than that, and don't want to
do the coding yourself, do you have a budget?

>
> Alan.  (sent from my BlackBerry Wireless Handheld)
>
> ----- Original Message -----
> From: Brian Modra <epailty(at)googlemail(dot)com>
> To: Su, Alan
> Cc: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>
> Sent: Wed Dec 16 02:43:46 2009
> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
>
> 2009/12/15 Su, Alan <Alan(dot)Su(at)daiwausa(dot)com>:
>> Brian,
>>
>> What you mentioned below is more sophisticated than what I am capable of doing now. Could you or anyone on this email recommend other tool that meets the following requirements:
>>
>> 1. Require less programming effort. I am trying to stay away from having to
>> write sophisticate programming language, such as Java or .Net
>> 2. Allow to bundle SQL commands in store procedure like style.
>> 3. Allow to evaluate conditions of SQL result set and trigger alert email based
>> on a preset threshold.
>
> Please describe the application in more detail. Do you need any sort
> of GUI front end to the application?
> Or is it just reporting via email?
>
>>
>>
>> -----Original Message-----
>> From: Brian Modra [mailto:epailty(at)googlemail(dot)com]
>> Sent: Friday, December 11, 2009 3:09 PM
>> To: Su, Alan
>> Cc: pgsql-admin(at)postgresql(dot)org
>> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool
>>
>> 2009/12/11 Su, Alan <Alan(dot)Su(at)daiwausa(dot)com>:
>>> Can anyone recommend a good, easy to ease and inexpensive reporting tool for
>>> accessing and manipulating Postgre database/table? The key features I am
>>> looking for with this tool are as follows:
>>>
>>>
>>>
>>> Require less programming effort. I am trying to stay away from having to
>>> write sophisticate programming language, such as Java or .Net
>>> Allow to bundle SQL commands in store procedure like style.
>>> Allow to evaluate conditions of SQL result set and trigger alert email based
>>> on preset threshold.
>>
>>
>> Have you seen this:
>> http://www.zwartberg.com/surf.html
>>
>> You can write SQLs or calls to PLPGSQL (stored procedure) directly
>> into the XML configuration file, then generate a web front end. No
>> Java or C++ required, though you can make complex features in C++. But
>> for more complex GUI logic, you'll need Javascript. There is no
>> escaping writing programs to describe logic, but the straight-forward
>> front-end is all auto-generated from your XML configuration and HTML.
>>
>> To do email from triggers will require extra coding, but talk to me about it...
>>
>> The Karoo Project is new, and the documentation is a bit lacking, but
>> you can email me your questions "Brian Modra" <brian(at)zwartberg(dot)com>
>>
>>>
>>>
>>> Thanks.
>>>
>>> Alan
>>>
>>> This email and all files and information transmitted with it are
>>> confidential and intended solely for the use of the individual or entity to
>>> whom the email is addressed. If you are not the intended recipient or the
>>> person responsible for delivering the email to the intended recipient(s),
>>> you have received this email in error, and use of it is strictly prohibited.
>>> Opinions expressed herein are those of the individual sender and not of the
>>> company unless specifically so indicated. If you have received this
>>> communication in error, please immediately notify the sender, delete this
>>> message, and do not print, copy, or disclose the content of this message.
>>> Inadvertent disclosure of this message does not waive any privilege or claim
>>> of confidentiality.
>>>
>>> For important conflict disclosures, please visit
>>> http://www.daiwausa.com/report_disclosure.html
>>>
>>> If your settings do not permit you to access this link directly, please use
>>> your internet browser to visit this website address.
>>>
>>
>>
>>
>> --
>> Brian Modra   Land line: +27 23 5411 462
>> Mobile: +27 79 69 77 082
>> 5 Jan Louw Str, Prince Albert, 6930
>> Postal: P.O. Box 2, Prince Albert 6930
>> South Africa
>> http://www.zwartberg.com/
>>
>> This email and all files and information transmitted with it are confidential and intended solely for the use of the individual or entity to whom the email is addressed.  If you are not the intended recipient or the person responsible for delivering the email to the intended recipient(s), you have received this email in error, and use of it is strictly prohibited.  Opinions expressed herein are those of the individual sender and not of the company unless specifically so indicated.  If you have received this communication in error, please immediately notify the sender, delete this message, and do not print, copy, or disclose the content of this message.  Inadvertent disclosure of this message does not waive any privilege or claim of confidentiality.
>>
>> For important conflict disclosures, please visit http://www.daiwausa.com/report_disclosure.html
>>
>> If your settings do not permit you to access this link directly, please use your internet browser to visit this website address.
>>
>
>
>
> --
> Brian Modra   Land line: +27 23 5411 462
> Mobile: +27 79 69 77 082
> 5 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Albert 6930
> South Africa
> http://www.zwartberg.com/
>
> This email and all files and information transmitted with it are confidential and intended solely for the use of the individual or entity to whom the email is addressed.  If you are not the intended recipient or the person responsible for delivering the email to the intended recipient(s), you have received this email in error, and use of it is strictly prohibited.  Opinions expressed herein are those of the individual sender and not of the company unless specifically so indicated.  If you have received this communication in error, please immediately notify the sender, delete this message, and do not print, copy, or disclose the content of this message.  Inadvertent disclosure of this message does not waive any privilege or claim of confidentiality.
>
> For important conflict disclosures, please visit http://www.daiwausa.com/report_disclosure.html
>
> If your settings do not permit you to access this link directly, please use your internet browser to visit this website address.
>

--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/