Date: Thu, 12 Mar 2020 15:43:36 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Richard Michael <rmichael@edgeofthenet.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow ext'd query via client native implementation vs. libpq &
 simple psql
Message-ID: <20200312204336.GE29065@telsasoft.com>
References: 
 <CABR0jERv5L7U0eYyNxv3ZES9HbJj9r2KPK3_=oPMBXTbTC+oXw@mail.gmail.com>
 <20200311215921.GZ29065@telsasoft.com>
 <CABR0jEQ1WJGRuv+e5kfq3q+8YOiFUVjAdULkuFbm0D=SeAYEtw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CABR0jEQ1WJGRuv+e5kfq3q+8YOiFUVjAdULkuFbm0D=SeAYEtw@mail.gmail.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk

On Thu, Mar 12, 2020 at 04:27:54PM -0400, Richard Michael wrote:
> > psql can't do it, but pygres can do it since last year.
> 
> Thank you for mentioning it.  Do you mean this:
> https://github.com/rogamba/pygres ?

Ugh, no.  I'm referring to PyGreSQL, which was at one point a part of the
postgres source tree.
https://www.pygresql.org/

$ python -c "import pg; print(pg.DB('postgres').query('SELECT 1').getresult())"
[(1,)]

$ python -c "import pg; p=pg.DB('postgres'); p.prepare('q', 'SELECT 1'); print(p.query_prepared('q').getresult())"
[(1,)]

-- 
Justin

(I'm having trouble believe someone made a project called "pygres", which uses
python, postgres, and psycopg...  Will mail D'Arcy)