Autor: Jakob Hirsch Data: A: W B Hacker CC: 'Exim-users', sent Assumpte: Re: [exim] dbm/dbmnz 'write' lookup?
Quoting W B Hacker:
>>> Is it possible to have Exim write to a dbm/dbmnz as part of a string
>>> expansion or are only reads possible?
> Not sure SQLLite is the best of the SQL's for 'sidestepping' the issue where
> writes may be involved. ISTR it works against a file and has rather basic or
> 'coarse grained' access locking.
So what? This is about dbm vs. sqlite, not sqlite vs. other rdbms.
FWIW, there's a configurable lock timeout for sqlite (defaults to 5s),
which should be sufficient as long as you are not excessively
updating/inserting, which is unlikely in an MTA.
I'd even say, for most single host purposes sqlite could be faster than
conventional RDBMSs.