(2013/02/09 0:41), Adrian Klaver wrote:
On 02/08/2013 07:33 AM, Kevin Grittner wrote:
Satoshi Nagayasu <snaga@xxxxxxxxx> wrote:
Of course, I can write ad-hoc queries by myself. However, I'd
like to allow non-tech people to issue ad-hoc queries with using
some visual query builder.
You should probably take a look at http://htsql.org/
It is free open source software intended for "accidental
programmers" -- people who want to pull summarized data from a
database without learning SQL or needing rigorous training. Its
development was partially funded by grants from foundations,
including the National Science Foundation. It does support
PostgreSQL and most definitely support counts, sums, etc. In fact,
it can automagically give you pretty summary graphs with the
ability to drill down to supporting detail.
I second this. I have been trying it out and it is proving quite useful.
The interesting part is that if you use the HTML interface you can get
the SQL sent to the server, helps you learn that also.
Very interesting.
If non-tech people can learn a simple query language for their analytics
purpose, it would be worth trying.
I think some "abstraction layer" is needed between non-tech users
and DBMS to allow them to issue queries themselves.
I think some query builder could be one of the solutions, and
also some simple query language could be another solution.
I will look into it.
Regards,
--
Satoshi Nagayasu <snaga@xxxxxxxxx>
Uptime Technologies, LLC. http://www.uptime.jp
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
