Date: Mon, 8 Feb 2021 16:50:14 +0000
From: Rory Campbell-Lange <rory@campbell-lange.net>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Daniele Varrazzo <daniele.varrazzo@gmail.com>,
	Denis Laxalde <denis.laxalde@dalibo.com>, psycopg@postgresql.org
Subject: Re: Latest developments in psycopg3
Message-ID: <20210208165014.GA8138@campbell-lange.net>
References: 
 <CA+mi_8btbC_-0KheQ3WYZW81fS4B0MyPyuALihmqHTvqq=6VyA@mail.gmail.com>
 <4eb4e86a-c813-bb8f-ae93-4f1b9fd46b6b@dalibo.com>
 <CA+mi_8YZnEuO=GAJiWnv_0Bx7_6DsL9jUcwhMxtXGqeSBgSp0A@mail.gmail.com>
 <34c98d4f-b26a-bc79-09e4-6567c38e92fa@aklaver.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <34c98d4f-b26a-bc79-09e4-6567c38e92fa@aklaver.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

On 08/02/21, Adrian Klaver (adrian.klaver@aklaver.com) wrote:
> On 2/8/21 4:16 AM, Daniele Varrazzo wrote:

> > 1) We can provide a feature to select the type of cursor that is not
> > much dissimilar from psycopg2
> > 2) Do we need DictCursor/RealDictCursor? ISTM that one of the two
> > would be sufficient? Possibly an object inheriting from a Python dict
> > instead of emulating it so that e.g. json.dumps()
> 
> RealDictCursor is what I use primarily as it plays well with json.*. I have
> used NamedTupleCursor for those things that play better with dot notation. I
> very rarely use DictCursor anymore as it's dual nature seemed to get in the
> way more then it helped.

Your comments also suggests the possibility of having a convenience
method, something like ._asjson() perhaps to allow rows or entire result
sets json encoded.