mbox-to-sqlite
mbox-to-sqlite copied to clipboard
simonw
Load email from .mbox files into SQLite
The --tracer option will now print out the SQL commands that the SQLite engine executes. This is helpful in trying to determine why some .mbox file cannot be loaded. For...
Hey, interesting project! I tried to give it a spin, but the mbox file I'm trying to analyze throws me this error: ``` Traceback (most recent call last): File "/usr/local/bin/mbox-to-sqlite",...
https://github.com/simonw/mbox-to-sqlite/blob/9c1e65a1c353572c4b0262236537559c548723cd/tests/test_mbox_to_sqlite.py#L33 If this was converted to ISO 8601 this column could be sorted by date. Need to decide how to handle timezones too.
The `To:` and `Cc:` headers are currently stored as text: https://github.com/simonw/mbox-to-sqlite/blob/9c1e65a1c353572c4b0262236537559c548723cd/tests/test_mbox_to_sqlite.py#L35-L37 Maybe normalize these and extract them out nto many-to-many tables? This would also need to handle `Name ` formatted...
This has only been tested against plain text emails so far. I think HTML emails should have the HTML stashed in a separate column. Not sure how best to handle...
Hey everybody, I've been spending some time over the past week trying to use `mbox-to-sqlite` to import my 57gb mbox from GMail. After a bunch of tinkering I've created an...
Hiya, This is a very rough first stab at dealing with #2 . It only makes sense if all the parts of the email are plain text, but that happens...
