Geek asks and answers

SQLite Thunderbird message database query from C #

I want to request email messages stored in Thunderbird from the C # application that I am developing.

Currently, I can get some parts of messages, such as From address and Subject, by querying the SQLite database, global-messages-db.sqlite.

SELECT subject FROM messagesText LIMIT 10;

I could not find the message body. I was looking for documentation on the Thunderbird repository, but I can not find anything that describes where this is stored.

Where are message bodies stored?

+5
source share
1 answer

From my own experiment, it looks like you can get a list of posts using below.

select * from messages;

, . , .

select c0body,c1subject,c2attachmentNames,c3author,c4recipients from messagesText_content where docid = 1234;

, - 1234.

+4

More articles:


All Articles