Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

finding a list of email authors, finding first and last?

  • No replies
  • 0 have this problem
  • 2 views
more options

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.

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.

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.