Re: Extensibility of the PostgreSQL wire protocol
Jan Wieck <jan@wi3ck.info>
From: Jan Wieck <jan@wi3ck.info>
To: "Jonah H. Harris" <jonah.harris@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2021-01-25T17:17:58Z
Lists: 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