[FH #5] Big Data Email with Mailsteward

Reading time ~1 minute

Today’s hack is Mac specific. We look into solving a big data problem: email search. More specifically, we will use Mac’s Mailsteward application to download and archive emails from different accounts.

Archiving emails is a good strategy, you never know when you would need an specific email. Mailsteward allows to archive emails into a MySQL database, so you can perform complex queries from multiple accounts at the same time.

To get started, you need to make sure to have MySQL server installed in your Mac. Then, go to Mailsteward and download a trial version (upgrade when you need to) to test it out. In our case, we went with a trial version of Mailsteward Pro. The way it works is that Mailsteward will work with Apple Mail and archive your emails into a database independently of Apple Mail, without removing them from Apple Mail. The database will be hosted locally, but you can set a remote database server if you wish so.

After installing Mailsteward, you can take a look at the MySQL tables

MS_1

Next, we will connect Mailsteward with Apple Mail, so Mailsteward will be pulling emails from Apple Mail connected accounts

MS_2

Start archiving process:

MS_3

MS_4

Once we are done, it will tell you how many emails got archived from all your accounts. You can allow for duplicate emails or disable duplicates.

MS_5

Now you have an email database, everything indexed and organized:

MS_6

You can then perform complex search queries in your entire email database:

MS_7

Finally, you can schedule automatic email archiving as follows:

MS_8

And voila! Your own email database ready for big data queries.

Polydigital Website Prototype

Writing a Launching Soon website with BootstrapMade template Continue reading

Uptime Monitoring with UptimeRobot

Published on February 18, 2022

Back Online

Published on January 29, 2022