[vindin]

Neat idea but you could build this with a fraction of the complexity by ditching sqlite and duckdb for your native file system and rg/grep/gawk with equivalent performance

[avtar]

There’s also notmuch with various frontends which will let you index and search colossal mail accounts

https://notmuchmail.org/frontends/

[em-bee]

grep with equivalent performance? i highly doubt that. my mailbox has 2.6M emails: running grep through millions of files if you use maildir or a similar format takes forever. likewise running grep on a 7.6GB large mbox file takes more than a minute.

on the other hand in supmua (which inspired notmuch) the same search takes seconds.