Thread: Novice Presentation and Company Project
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>
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
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>