2009/12/16 Su, Alan <[email protected]>: > 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 <[email protected]> > To: Su, Alan > Cc: [email protected] <[email protected]> > 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 <[email protected]>: >> 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:[email protected]] >> Sent: Friday, December 11, 2009 3:09 PM >> To: Su, Alan >> Cc: [email protected] >> Subject: Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool >> >> 2009/12/11 Su, Alan <[email protected]>: >>> 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" <[email protected]> >> >>> >>> >>> 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/ -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
