Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glr5O-0007Tn-4F for pgsql-interfaces@arkaria.postgresql.org; Tue, 22 Jan 2019 08:07:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glr5L-0004qb-PJ for pgsql-interfaces@arkaria.postgresql.org; Tue, 22 Jan 2019 08:07:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glr5L-0004qU-Bq for pgsql-interfaces@lists.postgresql.org; Tue, 22 Jan 2019 08:07:03 +0000 Received: from mail-it1-x144.google.com ([2607:f8b0:4864:20::144]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glr5D-0007Fj-KD for pgsql-interfaces@lists.postgresql.org; Tue, 22 Jan 2019 08:07:01 +0000 Received: by mail-it1-x144.google.com with SMTP id w18so20123516ite.1 for ; Tue, 22 Jan 2019 00:06:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tlocke-org-uk.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=VgXBdm0cewFHjwKUHz/VBU8/RVCm0JTXH2IVLRLdZF8=; b=YtQ2uTsHHTzwXSf8M6OQfbEb15QK0FzibZa/wjs2aI8LhdDQxzEEBOj1BKEQR6xxrA KHmgpOofdGMtilhrsi1IvxbLB6bG4TgfPjJTs1Zdq4zk814xBHqd0IhGYmnzsk7014MY 2csUhTP1mThBjvYPe7nkG4CAEaPiIOraLzVG+zggO34JkkYn6XAAVqx50N+r7Jf+N9kf ganesPW3kyoKEYinQZMsnd/Z6GTM16v+ePhv5G72s26xY+i2lR+IDqbY0IxE6Vgqd5S8 71w2JbyCuNNkWyDNbU3pxQWthLac8ntLRyerLDSiRCGLHA3kVOOc3Aw/FUK6OVNtu26b DaWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=VgXBdm0cewFHjwKUHz/VBU8/RVCm0JTXH2IVLRLdZF8=; b=GPryP3mTos+j3TtacxaqmKxKVQHVTO5TsPfr/7BYEXsQqxH2hMGRz4joH+8ynADdV6 XZ2Uf7amq+bRIgwqL//YS3gWWdhL3Jf4v56IVwXhS6PZ4ig7rySeha07n2tdDzu7IJnj uc64eFTEF9gtr7B4y39c3zaCgTtyhvFAgl8cDFPqyXN2Y0NEmF4uOuh/Zi1eTDLQk6kZ obGg7CkVD/BSjgCYi22DLAx/WKl3H65PGfKo6DTnFN7kU5G7ORFeiU6zhxxp/ZxXswDA /4s0blDlmqvnm+DqNkz898XDMvQTxYe2lfQn0Qx2NKmaqD5pmRjPzsvKOfVWzfubNyzz FkCw== X-Gm-Message-State: AJcUukc+UE27RI0JGsNYlAeqElgO+NWjg+CpN4NuoBjJjwArofHw2jXC 4+5CFyGdd+fUZHeh5YURsnD9Du9Xucsoz1d7TKuuuQ== X-Google-Smtp-Source: ALg8bN4tF4tyWC1CCl6CCWdgY/NlbCnlnamCh0sRgTqY/OwRZ92dDAAondbHZw/FfFQEeTd+iiPXXHt9IgQinboecXU= X-Received: by 2002:a02:152:: with SMTP id c79mr19804881jad.138.1548144414566; Tue, 22 Jan 2019 00:06:54 -0800 (PST) MIME-Version: 1.0 References: <5478B796-D5AE-453D-A71C-19A433FBDC1F@pgedit.com> In-Reply-To: <5478B796-D5AE-453D-A71C-19A433FBDC1F@pgedit.com> From: Tony Locke Date: Tue, 22 Jan 2019 08:06:41 +0000 Message-ID: Subject: Re: the wire protocol To: John DeSoi Cc: Catonano , pgsql-interfaces@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e4409b05800775b6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000e4409b05800775b6 Content-Type: text/plain; charset="UTF-8" Hi, pg8000 is a pure-python implementation of the wire protocol: https://github.com/tlocke/pg8000 Might be of help. -Tony On Tue, 22 Jan 2019, 03:25 John DeSoi > > On Jan 19, 2019, at 7:56 AM, Catonano wrote: > > > > there's this Python project using the so called wire protocol (as far as > I understand) > > > > https://github.com/MagicStack/asyncpg > > > > I'm caressing the idea to create a GNU Guile based project that does the > same thing > > > > But I don't understand how they manage to get the connection to > Postgresql, their code is too complicated for me > > > Here is a Common Lisp library that uses sockets and the wire protocol to > work with Postgres. > > https://github.com/marijnh/Postmodern > > Should be very close to what you want to do with Guile/Scheme. > > John DeSoi, Ph.D. > > > --000000000000e4409b05800775b6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi, pg8000 is a pure-python implementat= ion of the wire protocol:

https://github.com/tlocke/pg8000

Might be of help.

-Tony

On Tue, 22 Jan 2019, 03:25 John DeSoi &= lt;desoi@pgedit.com wrote:

> On Jan 19, 2019, at 7:56 AM, Catonano <catonano@gmail.com> w= rote:
>
> there's this Python project using the so called wire protocol (as = far as I understand)
>
> https://github.com/MagicStack/asyncpg
>
> I'm caressing the idea to create a GNU Guile based project that do= es the same thing
>
> But I don't understand how they manage to get the connection to Po= stgresql, their code is too complicated for me


Here is a Common Lisp library that uses sockets and the wire protocol to wo= rk with Postgres.

https://github.com/marijnh/Postmodern

Should be very close to what you want to do with Guile/Scheme.

John DeSoi, Ph.D.


--000000000000e4409b05800775b6--