Re: A PGsendQuery API design for your review

On Wed, 03 Feb 2016 15:27:25 -0500
Joe Abbate <jma@freedomcircle.com> wrote:

> On 02/02/16 16:30, Karl O. Pinc wrote:
> > Thanks, but I don't think so.  Those are interactive
> > python shells.  What they want is a web-enabled psql;
> > a SQL shell.

> I haven't played much with your particular problem, but it seems that
> adminer does what you want.  You can SELECT from a table from the left
> panel, then restrict the data that you want using dropdowns, and
> you'll see the generated SQL before the results with an Edit link.
> If you click on that and then add a semicolon and another query, it
> returns two sets of results.

Thanks very much for the link.  Adminer may be very helpful at some
point.

I did glance at it long ago.  I think then maybe it did not support
Postgres.  In any case I'd forgotten about it.

I'd prefer to dispense with the whole notion of building
SQL from a GUI.  Rarely is a single table queried.  Better to go
straight to the edit window.

I don't have time to look at this now, and have no
immediate need either.  It must parse though, since
php does not have support for PQsendQuery()/PQgetResult()
as far as I know.

Gotta wonder how it will do with:

  SELECT $;$Hello World.$;$;

And thanks for help with, and thinking about, my problem.

Regards,

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein