Local mail agent suggestions (gmail -> local postgres -> {local IMAP+SMTP} <-> mutt)?

[Ben Boeckel]

On Mon, Jan 21, 2019 at 17:26:31 -0800, Jonathan Gold wrote:
> I currently use the mbox format, fetchmail, procmail, and msmtp, but it
> is a bit unwieldy and doesn't give me the SQL search interface I'd like.

It isn't postgres, but have you looked at notmuch? It has mail-oriented
search tools built-in for outside-of-mutt searching. Example output
here:

    % notmuch search mutt-dev
    thread:0000000000013927   2015-02-25 [1/1] Mutt; [Mutt] #3740: multi-byte characters not handled in query window (inbox)
    thread:00000000000138f4   2015-01-22 [5/5] Ben Boeckel, David Champion, Vincent Lefevre; mutt: Fix the hcache type punning warning. (inbox)
    thread:000000000001387d   2014-08-23 [1/1] Mutt; [Mutt] #3699: Enable %a for pgp_encrypt_only_command (inbox)
    thread:000000000001312a   2014-06-22 [2/2] Mutt; [Mutt] #3695: OpenPGP: use fingerprint instead of key ID (inbox)
    thread:0000000000013129   2014-06-22 [1/1] Mutt; [Mutt] #3175: mutt should display keyid for which it wants the password (inbox)
    thread:0000000000013116   2014-05-25 [4/4] Mutt; [Mutt] #3665: Encrypting postponed messages (flagged inbox)
    thread:00000000000130fb   2014-05-07 [1/1] Mutt; [Mutt] #3687: Threads expand when other IMAP clients access IMAP folder (inbox)

https://notmuchmail.org/

--Ben