tag:blogger.com,1999:blog-304267073920548108.post2772592045019408508..comments2023-07-20T15:12:50.996+03:00Comments on flux: chasing timeUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-304267073920548108.post-88146021950191412052008-10-19T20:05:00.000+03:002008-10-19T20:05:00.000+03:00@ivanfrade: hi ivan :-) zeeshan also asked about t...@ivanfrade: hi ivan :-) <BR/><BR/>zeeshan also asked about tracker; i think i'll blog a bit about that the next time. maybe you can blog a bit about your experiences? I am sure we can all learn a lot from those!<BR/><BR/>anyway, to answer your question: when indexing, there will be one row per message in the sqlite database (table 'message'). this includes sender/recipients fields; note that recipients is a string that can contain multiple recipients (comma separated)<BR/><BR/>however, there is also the concept of a contact (a single sender or recipient), which has a n:m relation with table message. <BR/><BR/>this redundancy allows for searching messages without joins (only 'message' is needed), while it's also quick/easy to get, say, all mails sent to some particular contact. mu does not use that last option yet though. <BR/><BR/>when indexing, we scan the full message body as well and store it in the xapian database, tagging it with the sqlite message-id, so when searching through xapian, we can find the corresponding row in sqlite. it's a bit hackish, two databases, but afaik, there's no good alternative, and in practice, it works pretty well.<BR/><BR/>btw, you can find the sqlite database schema in index/mu-storage.sql in the source code.<BR/><BR/>regarding attachments: i detect that a message has attachments, but I am not doing anything with them. for me personally, that's not really something high on my list.<BR/><BR/>regarding the conversation threads: they are there already if you use mu together with mutt (courtesy of mutt, of course). if i ever develop some GUI, i'd probably try something like http://www.jwz.org/doc/threading.html<BR/>I have the data, it's just a small matter of coding :)djcbhttps://www.blogger.com/profile/15938154009846040711noreply@blogger.comtag:blogger.com,1999:blog-304267073920548108.post-66803772818612640432008-10-19T00:24:00.000+03:002008-10-19T00:24:00.000+03:00Hi Dirk-Jan, nice project!As you can imagine, i am...Hi Dirk-Jan, nice project!<BR/><BR/>As you can imagine, i am very interested on this topic (in tracker we also index emails). <BR/><BR/>Did you take into account for the performance the DB Schema? Is your database a simple table with a row per email? <BR/><BR/>What about attachments? do you plan to support the "meta information" of the mails, like conversation threads?<BR/><BR/>Thanks for your post and keep "hobby programming"!Anonymousnoreply@blogger.com