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
Date: Thu, 12 Mar 2020 15:43:36 -0500
Message-ID: <20200312204336.GE29065@telsasoft.com> (raw)
In-Reply-To: <CABR0jEQ1WJGRuv+e5kfq3q+8YOiFUVjAdULkuFbm0D=SeAYEtw@mail.gmail.com>
References: <CABR0jERv5L7U0eYyNxv3ZES9HbJj9r2KPK3_=oPMBXTbTC+oXw@mail.gmail.com>
<20200311215921.GZ29065@telsasoft.com>
<CABR0jEQ1WJGRuv+e5kfq3q+8YOiFUVjAdULkuFbm0D=SeAYEtw@mail.gmail.com>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, rmichael@edgeofthenet.org
Subject: Re: Slow ext'd query via client native implementation vs. libpq & simple psql
In-Reply-To: <20200312204336.GE29065@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox