> Evgeniy Berdnikov via Exim-users <exim-users@???> hat am 25.01.2024 09:09 CET geschrieben:
>
>
> On Thu, Jan 25, 2024 at 08:36:04AM +0100, Niels Kobschätzki via Exim-users wrote:
> > The only solution so far I come up with that I can put singular
> > senders and domains in tables and have multiple ACLs and routers.
> > And then have an extra file for those cases where I need a regexp
> > but then someone who needs to debug things, needs to look into
> > several places (even though I could for example add some info into
> > the log-messages, so that the debugging person has a better clue
> > where to look).
>
> That's right approach, in common.
>
> The first question should be raised is "Why you want to use SQL database?"
> May be to speed up lookups. It implies some technology, namely indexing.
> But indexing has its own limitations, and is almost incompatible with
> regex-like lookups. So you have to look for some algorithmic combinations
> of different lookup types, to achieve speedup and limit complexity of code.
There are several reasons:
1) multiple servers and I have to keep the files in sync (yes, shared storage but I want to omit this)
2) There is another backend-application which can easily access the database but not the files and there are informations in that database that is useful for other users.
Niels
--
## subscription configuration (requires account):
##
https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## exim-users-unsubscribe@???
## Exim details at
http://www.exim.org/
## Please use the Wiki with this list -
http://wiki.exim.org/
