MIME-Version: 1.0
References: 
 <CA+mi_8ZH-feQP0+k_j7_joygE=hMZCFnaNMv8Z1KCLKB9YLb0w@mail.gmail.com>
In-Reply-To: 
 <CA+mi_8ZH-feQP0+k_j7_joygE=hMZCFnaNMv8Z1KCLKB9YLb0w@mail.gmail.com>
From: Stefan Knecht <knecht.stefan@gmail.com>
Date: Mon, 30 Mar 2020 11:27:13 +0700
Message-ID: 
 <CAP50yQ_Mt=RtR0sXYoazJTuarphR1Kv8A6YTevCMiv+xZeD9=Q@mail.gmail.com>
Subject: Re: psycopg3: a first report
To: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Cc: psycopg@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000017d89e05a20ade7f"
Precedence: bulk

--00000000000017d89e05a20ade7f
Content-Type: text/plain; charset="UTF-8"

Ciao Daniele

Glad to see progress being made! Well written blog!

If I may, one thing that has been a constant troublemaker for us - running
primarily on AWS - is timeouts. I would love to see a fundamental
implementation of timeouts at the connection level, regardless of activity
- e.g. in the middle of a query, between queries, etc.. If the connection
hangs (because the server disappeared or failed over) or does not respond
(particularly in the weird cases like when the destination IP just vanishes
and the tcp timeout kicks in) - I'd like to know about it within a
reasonable time and be able to react to that.

Stefan


On Fri, Mar 27, 2020 at 5:46 PM Daniele Varrazzo <daniele.varrazzo@gmail.com>
wrote:

> Hello,
>
> I have started working on psycopg3. Database communication is up and
> running, sync and asyncio, and now I'm busy with the definition of the
> adaptation layer.
>
> You can read more at
> https://www.varrazzo.com/blog/2020/03/26/psycopg3-first-report/
>
> Comments are welcome. Cheers!
>
> -- Daniele
>
>
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | @zztat_oracle | fb.me/zztat | zztat.net/blog/

--00000000000017d89e05a20ade7f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Ciao Daniele</div><div><br></div><div>Glad to see pro=
gress being made! Well written blog!<br></div><div><br></div><div>If I may,=
 one thing that has been a constant troublemaker for us - running primarily=
 on AWS - is timeouts. I would love to see a fundamental implementation of =
timeouts at the connection level, regardless of activity - e.g. in the midd=
le of a query, between queries, etc.. If the connection hangs (because the =
server disappeared or failed over) or does not respond (particularly in the=
 weird cases like when the destination IP just vanishes and the tcp timeout=
 kicks in) - I&#39;d like to know about it within a reasonable time and be =
able to react to that.<br></div><div><br></div><div>Stefan</div><div><br></=
div><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cl=
ass=3D"gmail_attr">On Fri, Mar 27, 2020 at 5:46 PM Daniele Varrazzo &lt;<a =
href=3D"mailto:daniele.varrazzo@gmail.com">daniele.varrazzo@gmail.com</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,=
<br>
<br>
I have started working on psycopg3. Database communication is up and<br>
running, sync and asyncio, and now I&#39;m busy with the definition of the<=
br>
adaptation layer.<br>
<br>
You can read more at<br>
<a href=3D"https://www.varrazzo.com/blog/2020/03/26/psycopg3-first-report/"=
 rel=3D"noreferrer" target=3D"_blank">https://www.varrazzo.com/blog/2020/03=
/26/psycopg3-first-report/</a><br>
<br>
Comments are welcome. Cheers!<br>
<br>
-- Daniele<br>
<br>
<br>
</blockquote></div><br clear=3D"all"><br>-- <br><div dir=3D"ltr" class=3D"g=
mail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>//</div><span s=
tyle=3D"font-size:small">zztat - The Next-Gen Oracle Performance Monitoring=
 and Reaction Framework!</span><div style=3D"font-size:small">Visit us at=
=C2=A0<a href=3D"http://zztat.net/" style=3D"color:rgb(17,85,204)" target=
=3D"_blank">zztat.net</a>=C2=A0| @zztat_oracle | <a href=3D"http://fb.me/zz=
tat" target=3D"_blank">fb.me/zztat</a> | <a href=3D"http://zztat.net/blog/"=
 target=3D"_blank">zztat.net/blog/</a></div></div></div></div></div>

--00000000000017d89e05a20ade7f--