Re: Apache james guice Microsoft sql

"[email protected]" <[email protected]> Wed, 29 Jan 2025 13:55:56 +0100
Newsgroups gmane.comp.jakarta.james.user
Message-ID <[email protected]>
 > 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:[email protected]  <[email protected]>:
>
>> 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:[email protected]  <[email protected]
>>> :
>>>
>>>> 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<[email protected]>:
>>>>>
>>>>>> 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:[email protected]
>>>>>> For additional commands, e-mail:[email protected]
>>>>>>
>>>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail:[email protected]
>>>> For additional commands, e-mail:[email protected]
>>>>
>>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail:[email protected]
>> For additional commands, e-mail:[email protected]
>>
>>