[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: Homemade email system using LuaSocket and LuaPOP3
- From: Tony Finch <dot@...>
- Date: Wed, 28 Sep 2011 14:07:03 +0100
Petite Abeille <firstname.lastname@example.org> wrote:
> At the moment, I have a dual structure, using both the file system (to
> store the raw messages) and SQLite (to store the parsed structures and
> assist with queries).
This is exactly what serious IMAP servers like Cyrus and Dovecot do
(though they don't use SQLite).
> I have one database per, hmmm, "mailbox". In this context, a mailbox can
> be any grouping of messages that make some kind of logical sense.
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
f.anthony.n.finch <email@example.com> http://dotat.at/
Thames, Dover, Wight, Portland: East or southeast 3 or 4. Smooth or slight,
occasionally moderate in Thames and Portland. Fair. Moderate or good.