Re: psycopg3 transactions

From: Daniel Fortunov <postgresql(at)danielfortunov(dot)com>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: Psycopg <psycopg(at)postgresql(dot)org>, Paolo De Stefani <paolo(at)paolodestefani(dot)it>
Subject: Re: psycopg3 transactions
Date: 2021-10-15 21:43:37
Message-ID: CAH1rg6aoUAOwrw6Osc4iCExckAXLL+wkJH4mAk7o29KsNYE1CQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Looks good to me too.

I like the progression from basic use, to connection context, to
transaction context. Really nice logical progression into
progressive levels of granular control.

One thing I didn't understand was the wording of this suggestion:

>
> -
>
> use an autocommit connection: conn.autocommit = True, eventually as
> connect() parameter too;
>
>
Is this meant to convey:

>
> -
>
> use an autocommit connection: Set conn.autocommit = True (or you can
> provide this as a connect() parameter);
>
>
Or have I misunderstood?

Dani

On Fri, 15 Oct 2021 at 21:59, Paolo De Stefani <paolo(at)paolodestefani(dot)it>
wrote:

> It seems much clearer to me now
> This makes me think that maybe it's worth trying to use an autocommit
> connection...
>
> Il 15/10/2021 12:56 Daniele Varrazzo ha scritto:
> > On Wed, 13 Oct 2021 at 19:28, Daniele Varrazzo
> > <daniele(dot)varrazzo(at)gmail(dot)com> wrote:
> >
> >> Pretty much everyone comes from psycopg2, so we should definitely
> >> improve the docs :D
> >
> > I have expanded the documentation about transaction behaviour.
> > Feedback is welcome.
> >
> > https://www.psycopg.org/psycopg3/docs/basic/transactions.html
> >
> > Paolo, Daniel: I am especially keen to have your feedback as one
> > newcomer and the other pretty much the authority in transaction
> > management :)
> >
> > Cheers,
> >
> > -- Daniele
>
> --
> Paolo De Stefani
>
>
>

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2021-10-16 09:59:33 Re: psycopg3 transactions
Previous Message Paolo De Stefani 2021-10-15 20:59:38 Re: psycopg3 transactions