Re: Homemade email system using LuaSocket and LuaPOP3

[David Given <dg@...>]

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