Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.programming > #3689

Re: E-mail db

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!news2.arglkargh.de!dedekind.zen.co.uk!zen.net.uk!hamilton.zen.co.uk!reader01.nrc01.news.zen.net.uk.POSTED!not-for-mail
From Nobody <nobody@nowhere.com>
Subject Re: E-mail db
Date Sat, 24 Aug 2013 18:28:50 +0100
User-Agent Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-Id <pan.2013.08.24.17.28.50.216000@nowhere.com>
Newsgroups comp.programming
References <d818b2b5-b7be-45e5-a485-ce3d55a2bcdb@googlegroups.com>
MIME-Version 1.0
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding 8bit
Lines 14
Organization Zen Internet
NNTP-Posting-Host c3282594.news.zen.co.uk
X-Trace DXC=;ZoFY9RX>RU7l[^@m?i@V\a0UP_O8AJo\=dR0\ckLKGPWeZ<[7LZNRVdhgHVJkI0@QM2Z^cWRFGA[ReI:gm7c5T^
X-Complaints-To abuse@zen.co.uk
Xref csiph.com comp.programming:3689

Show key headers only | View raw

On Fri, 23 Aug 2013 19:06:42 -0700, bob wrote:

> If you were going to make an e-mail client like Thunderbird, what would be
> the most sensible data structure to store the messages in on the hard
> drive?

Store the raw messages in mbox format, then add an index using e.g. SQLite
so that you can search/order by date/subject/sender/etc and retrieve
individual messages quickly.

Storing the raw messages allows for easy migration to/from other clients,
other versions of the client, other OSes, etc, as well as the option to
rebuild the index from scratch if it gets corrupted.

Back to comp.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

E-mail db bob <bob@coolfone.comze.com> - 2013-08-23 19:06 -0700
  Re: E-mail db Robert Miles <milesrf@Usenet-News.net> - 2013-08-24 09:36 -0500
    Re: E-mail db bob <bob@coolfone.comze.com> - 2013-08-24 18:29 -0700
  Re: E-mail db Nobody <nobody@nowhere.com> - 2013-08-24 18:28 +0100
  Re: E-mail db Rui Maciel <rui.maciel@gmail.com> - 2013-08-26 14:44 +0100
    Re: E-mail db bob <bob@coolfone.net> - 2013-08-27 15:02 -0700
      Re: E-mail db Rui Maciel <rui.maciel@gmail.com> - 2013-09-01 12:25 +0100
        Re: E-mail db bob <bob@coolfone.net> - 2013-09-04 00:32 -0700

csiph-web