Re: Extensibility of the PostgreSQL wire protocol - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Extensibility of the PostgreSQL wire protocol
Date
Msg-id CAGBW59e2Xj_dNE5ruSZrZqz0t2kn+uj1sUMp=ttSk4tx3fqFzg@mail.gmail.com
Whole thread Raw
In response to Re: Extensibility of the PostgreSQL wire protocol  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
Hi Jonah,

On Mon, Jan 25, 2021 at 10:18 AM Jonah H. Harris <jonah.harris@gmail.com> wrote:
On Mon, Jan 25, 2021 at 10:07 AM Jan Wieck <jan@wi3ck.info> wrote:
The following is a request for discussion and comments, not a refined proposal accompanied by a working patch.

After implementing this three different ways inside the backend over the years, I landed on almost this identical approach for handling the MySQL, TDS, MongoDB, and Oracle protocols for NEXTGRES.

Could any of that be open sourced? It would be an excellent addition to add one of those as example code.


Regards, Jan

 

Initially, each was implemented as an background worker extension which had to handle its own networking, passing the fd off to new protocol-specific connections, etc. This worked, but duplicate a good amount of logic. It would be great to have a standard, loadable, way to add support for a new protocol.

--
Jonah H. Harris



--
Jan Wieck

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: ResourceOwner refactoring
Next
From: Heikki Linnakangas
Date:
Subject: Snapbuild woes followup