Tony Finch wrote: [...] > Also pretty normal. IMAP has a very strict mailbox model which mostly > means you get no benefit from cross-mailbox indexes, though there are > extensions for things like multi-mailbox full text search which do need > them. It's got nothing to do with Lua, but aeons ago I wrote (and used for a while) an MUA in Python that stored all its data in a MySQL database. You can tell that I hadn't heard of SQLite at that point. http://sqmail.sourceforge.net/ The schema's here: http://sqmail.cvs.sourceforge.net/viewvc/sqmail/sqmail/src/sqmail/cli/createdb.py?revision=1.7&view=markup I stored the headers and the bodies in two tables and then did brute force searches as desired --- I didn't know about database normalisation at that point, but performance was more than adequate. I ended up with loads of virtual folders (defined as custom SQL queries that operated on the headers table) and it all ran very smoothly. One day I must reexamine this idea; it worked very well. But this time in Lua. -- ┌─── ｄｇ＠ｃｏｗｌａｒｋ．ｃｏｍ ───── http://www.cowlark.com ───── │ "I have always wished for my computer to be as easy to use as my │ telephone; my wish has come true because I can no longer figure out │ how to use my telephone." --- Bjarne Stroustrup
Attachment:
signature.asc
Description: OpenPGP digital signature