Re: Visual query builder for PosgreSQL?

(2013/02/09 0:41), Adrian Klaver wrote:
> On 02/08/2013 07:33 AM, Kevin Grittner wrote:
>> Satoshi Nagayasu <snaga(at)uptime(dot)jp> 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(at)uptime(dot)jp>
Uptime Technologies, LLC. http://www.uptime.jp