Dear God... I really dont like PostgreSQL. Have rough time with it as backend for zabbix, after i change to mysql was happy. I have bug on 15.2 as i remember which corrupted whole Database and make it unusable. For me PostgreSQL too unstable. If Microsoft sql and mysql realization good in james i always prefer them.
ср, 29 янв. 2025 г., 19:56 btell...@linagora.com <btell...@linagora.com>: > > So derby is rock solid? That's not what I said. I just said it's > better than the previously existing maildir... If you want rock solid > performance at scale with minimal dependencies please check the proposed > new PostgreSQL backend: > https://github.com/apache/james-project/pull/2587 It is on par quality > wise with the distributed version of APache James but runs with less > dependencies (those are mostly optional in order to ease single node > deployments) > How about degradation after alot of eMails in base? True > for all implementations not leveraging mail content storage on dedicated > solutions, like S3 object stores to be honnest. Which the PG implem > leverages... If retaining performance at scale is a concern of you, > maybe you should get a serious look to the PG application. If so, I > would happily prvide assistance doing so. Best regards, Benoit TELLIER > > On 29/01/2025 12:45, Ilya Terskov wrote: > > So derby is rock solid? How about degradation after alot of eMails in > base? > > > > ср, 29 янв. 2025 г., 18:16btell...@linagora.com <btell...@linagora.com > >: > > > >> Reindexing is only for the search index, handled with Lucene > >> Not for the Derby DB itself that leverages SQL transactions to remain > >> strongly consistant. > >> Best regards > >> Benoit > >> > >> On 29/01/2025 12:13, Ilya Terskov wrote: > >>> Ah so its Derby database which also file method? Its good? As i > >> understand > >>> its can be reindexed and other stuff to manage its consistent state? > >>> > >>> ср, 29 янв. 2025 г., 18:09btell...@linagora.com < > btell...@linagora.com > >>> : > >>> > >>>> Hello Ilya > >>>> Maildir implementation for James was unsecure, unmaintained, and was a > >>>> pain for the entire project. JPA implem is more prformant than it so > it > >>>> had been removed. > >>>> I discourage its usage. > >>>> JPA for you shall work fine. > >>>> Best regards > >>>> Benoit > >>>> > >>>> On 29/01/2025 12:05, Ilya Terskov wrote: > >>>>> Thanks for info about jdbc, for small office like 100-150 mails per > >> weak > >>>>> maildir mailbox file method is fine solution? > >>>>> Ah already see 3.8.2 binaries on > >>>>> https://dlcdn.apache.org/james/server/3.8.2/ > >>>>> > >>>>> ср, 29 янв. 2025 г., 15:56 Benoit TELLIER<btell...@apache.org>: > >>>>> > >>>>>> Hello, > >>>>>> > >>>>>> jpa-guice should be working decently with Microsoft SQL server. > >>>>>> > >>>>>> We would anyway be happy of feedback regarding this. > >>>>>> > >>>>>> Note that it's the same JPA implem than the Spring one, nothing > >> specific > >>>>>> to Guice. > >>>>>> > >>>>>> Here is how to customize the JDBC driver: > >>>>>> > >>>>>> > >> > https://github.com/apache/james-project/blob/master/server/apps/jpa-app/README.adoc#using-alternative-jdbc-drivers > >>>>>> Hope it helps, > >>>>>> > >>>>>> Warm regards, > >>>>>> > >>>>>> Benoit > >>>>>> > >>>>>> On 29/01/2025 02:04, Ilya Terskov wrote: > >>>>>>> Hi there guys. Can you tell me guice working just fine with > Microsoft > >>>> sql > >>>>>>> server? I need odbc driver and other stuff as i understand? Can > >> someone > >>>>>>> tell me also about creating db in mssql and full checklist if > someone > >>>>>> have > >>>>>>> experience with such installations? > >>>>>>> > >>>>>> > --------------------------------------------------------------------- > >>>>>> To unsubscribe, e-mail:server-user-unsubscr...@james.apache.org > >>>>>> For additional commands, e-mail:server-user-h...@james.apache.org > >>>>>> > >>>>>> > >>>> --------------------------------------------------------------------- > >>>> To unsubscribe, e-mail:server-user-unsubscr...@james.apache.org > >>>> For additional commands, e-mail:server-user-h...@james.apache.org > >>>> > >>>> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail:server-user-unsubscr...@james.apache.org > >> For additional commands, e-mail:server-user-h...@james.apache.org > >> > >>
