Hi Paul, > >At the moment queries seem to be spread over dbmail. Is it hard to use a > >more layered approach with a defined storage layer? A interface could be > >something like 'sl_retrieve_message(user, mailbox, condition)' where > >condition could be all/header=xyz/... > > Sounds a lot like what I'm working on.
That sounds very good, great! > The retrieval api must indeed be totally opaque, while still allowing full > control over retrieval-conditions. Returning cursors where possible, and > fake-cursors when not seems like a very good idea that aligns nicely with > db-apis used elsewhere. Yes exactly. MySQL would use a client side cursor on the fetched result set, Postgres/Oracle would use a server side cursor. That would allow to use Trigger + Stored Procedures to update the quota too for example. Thomas -- http://www.tmueller.com for pgp key (95702B3B)
