Обсуждение: Novice Presentation and Company Project

Поиск
Список
Период
Сортировка

Novice Presentation and Company Project

От
Eduardo Morras
Дата:
Hello everyone, I'm Eduardo Morras from Spain.

My company is developing code for Postgresql for another company and want to communicate, debate and share the results
withthe community.
 

The objetives are upgrade the network backend and frontend of Postgresql:

a) Add support for LibreSSL in it 2 flavors, OpenSSL compatibility mode and own API,
b) Add support for sctp protocol,
c) Add support for dtls with LibreSSL, with udp/udplite and sctp datagrams,
d) Add support to them in makefiles/configure and postgresql configuration.

I have read the FAQ entry [1] and company contributions document [2] and as first step I had search Postgresql
mailinglistsfor similar topics and found nothing. I think this is the second step, share the plan. If you need more
informationon any topic or has more ideas or howtos or.. reply mail.
 


[1] https://wiki.postgresql.org/wiki/So,_you_want_to_be_a_developer%3F
[2] http://momjian.us/main/writings/pgsql/company_contributions/

---   ---
Eduardo Morras <emorrasg@yahoo.es>



Re: Novice Presentation and Company Project

От
Noah Misch
Дата:
On Thu, Mar 03, 2016 at 12:04:56PM +0100, Eduardo Morras wrote:
> My company is developing code for Postgresql for another company and want to communicate, debate and share the
resultswith the community.
 
> 
> The objetives are upgrade the network backend and frontend of Postgresql:
> 
> a) Add support for LibreSSL in it 2 flavors, OpenSSL compatibility mode and own API,
> b) Add support for sctp protocol,
> c) Add support for dtls with LibreSSL, with udp/udplite and sctp datagrams,
> d) Add support to them in makefiles/configure and postgresql configuration.
> 
> I have read the FAQ entry [1] and company contributions document [2] and as first step I had search Postgresql
mailinglistsfor similar topics and found nothing. I think this is the second step, share the plan. If you need more
informationon any topic or has more ideas or howtos or.. reply mail.
 

Thanks for sharing these goals, which was an ideal first step.  I think your
next step is to pick a self-contained subset of those goals to implement as a
first project.  Then, start a thread describing a planned design for that
particular subset.  I recommend starting either with support for the OpenSSL
compatibility mode of LibreSSL or with SCTP.

When you send a design proposal for SCTP support, please explain why a person
should choose to reach PostgreSQL over SCTP in lieu of TCP.  The topic of SCTP
support in PostgreSQL has never come up before.

nm



Re: Novice Presentation and Company Project

От
Eduardo Morras
Дата:
On Wed, 9 Mar 2016 00:06:43 -0500
Noah Misch <noah@leadboat.com> wrote:

> On Thu, Mar 03, 2016 at 12:04:56PM +0100, Eduardo Morras wrote:
> > My company is developing code for Postgresql for another company
> > and want to communicate, debate and share the results with the
> > community.
> > 
> > The objetives are upgrade the network backend and frontend of
> > Postgresql:
> > 
> > a) Add support for LibreSSL in it 2 flavors, OpenSSL compatibility
> > mode and own API, b) Add support for sctp protocol,
> > c) Add support for dtls with LibreSSL, with udp/udplite and sctp
> > datagrams, d) Add support to them in makefiles/configure and
> > postgresql configuration.
> > 
> > I have read the FAQ entry [1] and company contributions document
> > [2] and as first step I had search Postgresql mailinglists for
> > similar topics and found nothing. I think this is the second step,
> > share the plan. If you need more information on any topic or has
> > more ideas or howtos or.. reply mail.
> 
> Thanks for sharing these goals, which was an ideal first step.  I
> think your next step is to pick a self-contained subset of those
> goals to implement as a first project.  Then, start a thread
> describing a planned design for that particular subset.  I recommend
> starting either with support for the OpenSSL compatibility mode of
> LibreSSL or with SCTP.

Compile with OpenSSL compatibility mode of LibreSSL is a makefile change, not code. Under FreeBSD 10, it's a two line
onport configuration and passes all postgresql tests.
 

> When you send a design proposal for SCTP support, please explain why
> a person should choose to reach PostgreSQL over SCTP in lieu of TCP.
> The topic of SCTP support in PostgreSQL has never come up before.

Oks, as a fast hack and preface, SCTP has a tcp compatibility code mode, changing the socket call to 'socket(AF_INET,
SOCK_STREAM,and IPPROTO_SCTP)' in frontend and backend code, uses some of the sctp features (multihoming, 4way
handshake)but not others (multistreaming, only one message per stream, like tcp). SCTP is in Linux 2.4+, FreeBSD7+ and
otherUNIX systems.
 

Both patchhacks are easy, but I'm still fighting with autotools and studying postgresql developer howtos.

> nm
> -- 

---   ---
Eduardo Morras <emorrasg@yahoo.es>