I somehow messed up my email config and the following message never reached the list (but never got a nack either so it took me a week and 2 emails without response to detect the problem)
---- Hello Benoit I think having a postgresql backed mailbox server sounds great 👍 It should not come as a surprise since Matthieu and I already play with deploying the pulsar+postgresql+s3 server for SMTP Mailbox is a next step once we get SMTP up and running with a reasonable level of stability. But at our place it will take some time :) So I (we) would definitely contribute, not very fast as our free time dictates but still contribute. Le ven. 6 oct. 2023 à 23:49, Benoit TELLIER <btell...@linagora.com> a écrit : > Hey there! > > The goal: deliver James "stateless email server" concept to smaller > deployments than those addressable with the Distributed server. > > Why Postgres? Rock solid. And more options than other SQL stores (see > below) > > The requirements would be: > - Leverage the blobStore for binary storage (email bodies + > attachements). Those big binaries are not meant to be stored into SQL rows > - blaming you, JPA! > - Bring choice on blob store : PGSQL native solution ( > https://www.postgresql.org/docs/7.4/jdbc-binary-data.html ) for small > deployments OR S3 > - Bring choice on search: PGSQL native solution ( > https://www.postgresql.org/docs/current/textsearch.html ) for small > deployments OR OpenSearch > - Bring choice on PubSub: PGSQL native solution ( > https://www.postgresql.org/docs/current/plpgsql-trigger.html ) OR > RabbitMQ > - Enforce strict tenant isolation: domain A won't access domain B data > even if we screw up James access control layer. This can be done with Row > security https://www.postgresql.org/docs/current/ddl-rowsecurity.html . > - Be reactive. This can be achieved by using a reactive firendly driver > like r2dbc... > - Ensure that we can easily run on some largely scaling postgres... > CitusData ? > > An other outcome might be to drop JPA implementation, ideally... (we > provide something similar but waaaay better) > > Ideally I would like to deliver this before september 2024... > > Thoughts? > Would this be something interesting people in here? > Would some people be interested contributing to this effort? > Would some people desire sponsoring this effort? > > If this is non consensual, I can also contribute this into > https://github.com/linagora/tmail-backend/ without annoying people in > here... > > > > -- > > Best regards, > > Benoit TELLIER > > General manager of Linagora VIETNAM. > Product owner for Team-Mail product. > Chairman of the Apache James project. > > Mail: btell...@linagora.com > Tel: (0033) 6 77 26 04 58 (WhatsApp, Signal) > > > > >
