OK, this is a project I can stand behind: download YOUR OWN data locally, query it in n different ways quickly, delete / sync up with Gmail, all from your TUI.
Would love to see something similar for Google Photos, and Apple Photos.
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
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.