Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7MAH-0001yQ-8b for psycopg@arkaria.postgresql.org; Wed, 03 Feb 2021 17:42:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l7MAG-0002t1-5g for psycopg@arkaria.postgresql.org; Wed, 03 Feb 2021 17:42:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7MAF-0002st-VX; Wed, 03 Feb 2021 17:42:04 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7MAD-0006HH-CN; Wed, 03 Feb 2021 17:42:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1612374118; bh=0drNxtkH70+JfM77DsBX4UZbI/NLjHvv/Hol7dMOPrM=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=PCT3Oc31euAlATi6QSxjQIZGodQguasrRWDVeD2U8NraurwGCUiW+AmswCsbkIgxv OzVNGtX3E/nFxCiflPzB+aXMyw2fkKsoen5/4MdxkfQkXpWJAwZ2HZ7rvRG+pv++d5 wfxkbgaKeAHdkpBGk1Jp4IlqQkE6XZrzspWczJ0s= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([89.12.24.142]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Mqb1c-1lkne130qm-00mYu4; Wed, 03 Feb 2021 18:41:58 +0100 Received: from ncq by hermes with local (Exim 4.94) (envelope-from ) id 1l7MA8-0006XO-0p; Wed, 03 Feb 2021 18:41:56 +0100 Date: Wed, 3 Feb 2021 18:41:56 +0100 From: Karsten Hilbert To: psycopg@lists.postgresql.org, psycopg@postgresql.org Subject: Re: about client-side cursors Message-ID: Mail-Followup-To: psycopg@lists.postgresql.org, psycopg@postgresql.org References: <20210203161548.vkhu3qkpvmgvyhik@dalibo.com> <8E9B3B86-4691-4F09-B853-EA1F4CB86CF4@thebuild.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8E9B3B86-4691-4F09-B853-EA1F4CB86CF4@thebuild.com> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:UgiC0hnPvwvyXdhMXO9Gj4EnKWqhBMb6O9fzcX0BCw769+JgUxU bJPz2GU4DGNRTv+hksh4vEODpE35oTITFogDGbaUZBSGalPNP3tDpyULztQGGX2By7qQhiP 5fn2o2c1olLL08WXN42os1VMysUUGCGVj7ELyME2sUcBOzHb6gaME56S9lliFFGzgKuPeNj aWK732HgX20/IL1L8WZjw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:7RkRJ5153xU=:qtrhi5rtRnGPHgLh2I9wo1 SAKOaOU+z+SKA27vpxcTanPjwBfxAVtt7hkUA0DR2j3qG5626EqswtXCFNVf9zkeCxAMdxWkC FQ64b+EVm6UdH32LhKBAPvnArkhEYdZi+qy2+PGo/ktp2hwxKX72G1/Ihy1ZzTgiLGHY7/C/2 Z24pXXCqxuRybURJouwLp2+emi4G/ra/hxcnWSI/agAJx8qqfZyT37iiIEUiAh+7sNHZNMIVF gqV1DArL2qNJKnRiCw4mT2pFUyxaxozjxATUOt91mzXDB3vR8Num9tsGBPdgoYU4rRBlUbKLC 9lHA/1TzSKZAGNn2TqMvAbj+BRtJpR/Qsht31NKKKfRKdPIiC2tIRwStrvEZps/0jh6WPbhzm wAcgxPIt6NsP/iAYN08wQk+4GBoSkqdZDgdnkz+xyk3u0gQKhS9IEbJpOnatVMt3hH3qoKLnW bz56nTYampW+eyE0/6foiMhaJDSduAwbe/VUSp2KbuGbuykGvrXEwqTwHEVxxpaZ8fbgiCqGV D3YI3wUefJH7ycd3RKrEczC4lMD0qECFqf7jx5WSLBLl+CU4XmciQcGveZEsI22pR9vZTRHPG 38H5FamoypHFPD8cKJ9HNlpZP0y7I92rBdgi+f+2n666HUeJOKVwe0CCLBOlnl7uL/9y7Npth l2hUoSsV2xWGYEhywyOZwbl8jI6Ta/57leFmAkzr6lj7GyPwMhNkC00Uuar/aOTQrhRtNidiy YXpD+F+7SxF6Lo/+3O8beEoM0yS+phepZkAHJV1PIys0CLHQ3Oz/QnuzJd9yYSHcq8P+7dJdo St7yowXi72aX8EI7LWQHNqYgiPMcDeoyDVVLHkwhLOmDmZC8sTNVkxbq1M+HVF5d3NwglJqkv 2rEQNdzuakRoW7B5jv7A== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Am Wed, Feb 03, 2021 at 08:27:49AM -0800 schrieb Christophe Pettus: > > All in all, my main point is: (why) do we need client-side cursors? > > Well, the original source is: > > https://www.python.org/dev/peps/pep-0249/ > > There are many arguments that can be made against this API, but I think = we're a bit stuck at this point. Perhaps client-side cursors were invented to make it possible to code to the same API regardless of whether real (server-side) cursors are used or not ? Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B