Has anyone used DuckDB (or anything else) to create an open source way to publish a mailbox so that a regular person can browse it and search it?
I'm aware of jmail.world, but they haven't (yet?) published the source code.
I had Claude hack something together recently: https://healdsburg-youcubed-emails.vercel.app/
It works fine for this small set of emails, although the search isn't great, and there was more preprocessing that I would have liked. (I would prefer to be able to point a single binary at a pst or mbox file, and have it magically serve it like this, even if it means I need a VPS to serve it.)
Maybe https://github.com/wesm/msgvault will do what you need?
Simon Willison wonderful Datasette plus the mbox-to-sqlite extension is exactly what you want.
https://datasette.io/
https://github.com/simonw/mbox-to-sqlite