finding a list of email authors, finding first and last?
I want to continue using TB but a few things really make me despair of it. But there may be workarounds. If I have a question, when did these people last send me an email… (read more)
I want to continue using TB but a few things really make me despair of it. But there may be workarounds. If I have a question, when did these people last send me an email, or have any of these people responded to something, there seems to be no way to get to a list. But. I found a way to do it. Using sqlite3.
I have been wanting a CLI for interacting with TB for a while. You know, that folder I have with 10k+ emails and if I click on it, the UI spins forever. What is even in that?
Now I can do this: 1) copy the global-messages-db.sqlite from the active profile to another place 2) run: sqlite3 global-messages-db.sqlite 3) ```sqlite> select m1.c3author, min(m2.date), max(m2.date) from messagesText_content m1, messages m2 where m1.docid = m2.id group by m1.c3author order by m1.c3author; ... ray kiddy <ray@ganymede.org>|1732124816000000|1759268233000000 ruby29@something undefined|1756740716000000|1756740716000000 salvatore@someother undefined|1758733831000000|1758733831000000 support@linode.com undefined|1755126295000000|1755126295000000 ... ```
Holy sender dates, Batman! Now I can see the earliest and latest email sent by any user. Now I can filter, sort, and see every person who sent me something in a time period. And whether it was 1 email or 1000, I just see the names and not an enormous amount of other information.
So, is this the only way to get this? Or the best? I have no idea. Please let me know if there is a better way, perhaps one using TB itself. It would be nice.
In the meantime, I will be wrapping this in a python call, doing some formatting and it will work and I can stop worrying about not seeing their email.