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


Groups > comp.programming > #3689

Re: E-mail db

From Nobody <nobody@nowhere.com>
Subject Re: E-mail db
Date 2013-08-24 18:28 +0100
Message-Id <pan.2013.08.24.17.28.50.216000@nowhere.com>
Newsgroups comp.programming
References <d818b2b5-b7be-45e5-a485-ce3d55a2bcdb@googlegroups.com>
Organization Zen Internet

Show all headers | 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