mbox-to-sqlite

Load email from .mbox files into SQLite

Installation

Install this tool using pip:

pip install mbox-to-sqlite

Usage

Use the mbox command to import a .mbox file into a SQLite database:

mbox-to-sqlite mbox emails.db path/to/messages.mbox

You can try this out against an example containing a sample of 3,266 emails from the Enron corpus like this:

curl -O https://raw.githubusercontent.com/ivanhb/EMA/master/server/data/mbox/enron/mbox-enron-white-s-all.mbox
mbox-to-sqlite mbox enron.db mbox-enron-white-s-all.mbox

You can then explore the resulting database using Datasette:

datasette enron.db

Development

To contribute to this tool, first checkout the code. Then create a new virtual environment:

cd mbox-to-sqlite
python -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest