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