[Discuss] Stalwart E-mail; Was: Re: SSH options

[Ron]

Rich Pieri wrote on 2026-01-24 06:20:

> Stream objects [x-rays & PDFs] can be stored in global nodes but the
> typical use and best practice is to store these data as files on the
> filesystem.

Sounds good, attachments as files isn't a Bad Idea.

Of course, neither is email as database records.


I'd have some hesitation with bifurcating the storage between a DB and 
the file system do to the possibility (inevitability?) of the 2 storage 
systems going out of sync.

It's fine for web apps, but email messages (and medical records!) are a 
bit more important.



If a file gets deleted, how does the DB know to update its index? Is all 
file access through the one software? That's reasonable to expect, but 
also one would want occasional re-indexing probably, should such a 
situation arise.


For example, NextCloud runs a cron job to look for changes in the users' 
directories in the  file system and re-index folders with changes.


> Why? Because storing them in the database fills the in-memory index 
> with unneeded bloat which slows down the process of data retrieval.
Mime-types to exclude indexing the contents of several formats of 
attachments should alleviate this, no?