On Feb 15, 2012, at 3:43 PM, Bron Gondwana wrote:
> So in my head, I'm kind of thinking in SQL when I think about how I would
> access email.
Funnily enough, this is precisely how my diminutive IMAP server is implemented
:D
E.g.:
SelectMailboxStatus =
[[
select cast( count( * ) as integer ) as messages,
cast( 0 as integer ) as recent,
cast( coalesce( max( uid ), 0 ) + 1 as integer ) as uidnext,
cast( 1 as integer ) as uidvalidity,
cast( 0 as integer ) as unseen
from fetch_seq
]],
FWIW, here is the DDL of the data model (a bit of a work in progress):
http://dev.alt.textdrive.com/browser/Mail/MailStore.ddl
And the DML for the IMAP store:
http://dev.alt.textdrive.com/browser/Mail/IMAPStore.dml
_______________________________________________
imap5 mailing list
[email protected]
https://www.ietf.org/mailman/listinfo/imap5
