Re: Safe handling of an SQL query

Bruce Johnson <[email protected]>
Newsgroups gmane.comp.apache.mod-perl
Message-ID <[email protected]>
I'm going to suggest going another direction...what you (and they) want are a BI system. You can present a set of reports and the system provides for their ability to do ad hoc reporting and such like.

<http://www.softwareforenterprise.us/2009/12/21/list-of-top-open-source-business-intelligence-bi-software-solutions/>

<http://www.pentaho.com/>
<http://www.jaspersoft.com/>
<http://www.icCube.com/>

These sorts of things let the end user have at the data, but not in ways they can mess anythign up, and with the proper DB design they won't get the wrong answers from their data...


-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.