Thread: Simple Web-based alternative to PgAdmin

Simple Web-based alternative to PgAdmin

From

AlexK

Date:

11 February 2014, 19:17:29

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.

Since too many open connections seems to be a serious problem on PostgreSql,
maybe giving everyone PgAdmin is asking for trouble. Instead, I would like
to expose the data via some simple Web-based interface, managing the
connections myself.

Can you recommend something very simple and light-weight, with only one
feature: run a query and display a result set.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Simple-Web-based-alternative-to-PgAdmin-tp5791430.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Simple Web-based alternative to PgAdmin

From

alexandros_e

Date:

11 February 2014, 19:21:36

phpPgAdmin

http://phppgadmin.sourceforge.net/doku.php



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Simple-Web-based-alternative-to-PgAdmin-tp5791430p5791431.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: Simple Web-based alternative to PgAdmin

From

Adrian Klaver

Date:

11 February 2014, 19:29:16

On 02/11/2014 08:17 AM, AlexK 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.

Trying to think why one person would need 30 connections to do simple
queries instead of running them through one connection?

>
> Since too many open connections seems to be a serious problem on PostgreSql,
> maybe giving everyone PgAdmin is asking for trouble. Instead, I would like
> to expose the data via some simple Web-based interface, managing the
> connections myself.

So have you seen a problem?

Also if you have, would it not be easier just to put a connection pooler
in front of the database? Say pgBouncer or pgpool, then you would be
covered for all methods of access.

>
> Can you recommend something very simple and light-weight, with only one
> feature: run a query and display a result set.
>
>
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Simple-Web-based-alternative-to-PgAdmin-tp5791430.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>


--
Adrian Klaver
adrian.klaver@gmail.com

Re: Simple Web-based alternative to PgAdmin

From

Pavel Stehule

Date:

11 February 2014, 19:44:01

2014-02-11 17:17 GMT+01:00 AlexK <alkuzo@gmail.com>:

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.

Since too many open connections seems to be a serious problem on PostgreSql,
maybe giving everyone PgAdmin is asking for trouble. Instead, I would like
to expose the data via some simple Web-based interface, managing the
connections myself.

Can you recommend something very simple and light-weight, with only one
feature: run a query and display a result set.

adminer

http://www.adminer.org/en/

Works with MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB

Regards

Pavel Stehule

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Simple-Web-based-alternative-to-PgAdmin-tp5791430.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: Simple Web-based alternative to PgAdmin

From

Sameer Kumar

Date:

20 February 2014, 07:32:53

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.