On Wed, Feb 12, 2014 at 12:17 AM, AlexK <alkuzo@gmail.com> wrote:
I would like to give my users the ability to invoke read-only functions and select statements, so that they can easily see the data. Both me and the users have experience mostly with SQL Server, so anyone can keep like 30 connections without much thinking.
Configure connection pooling at statement level (since you are only using read only queries) using pgbouncer and it would be a good idea to use a read-only user.
Can you recommend something very simple and light-weight, with only one feature: run a query and display a result set.