2 ms·
if you want to try something that downloads Gmail via imap and indexes it into an sqlite3 db (with FTS5 fulltext of from/to/cc/bcc/subject/body fields) and extr
by leeoniya 10y ago
if you want to try something that downloads Gmail via imap and indexes it into an sqlite3 db (with FTS5 fulltext of from/to/cc/bcc/subject/body fields) and extracts attachments to filesystem, take a look at a recent project of mine:
https://github.com/good-3g-apps/email/tree/master/imap-importer https://github.com/good-3g-apps/email/tree/master/imap-impor...
It also saves the raw .eml files to disk. No support for labels (yet), but it does properly link up threads in the db using `References` from the parsed headers (setting both MPTT and adjacency-list fields)
It's WIP, so contributions welcome :)
- leeoniya 10y agoFWIW regarding speed, i was able to download, index & extract my entire INBOX + Sent Items (14k emails, 3.5GB total) in < 10min on a fast connection. the limiting factor by far was connection/imap speed.
- leeoniya 10y agomoved to https://github.com/Good-3G/email https://github.com/Good-3G/email