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

Groups > comp.programming > #3685 > unrolled thread

E-mail db

Back to article view | Back to comp.programming

Contents

  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

#3685 — E-mail db

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?

Thanks.

[toc] | [next] | [standalone]

#3687

On 8/23/2013 9:06 PM, 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?
>
> Thanks.
How much like Thunderbird does it need to be?  Thunderbird stores them 
in the mbox format.

[toc] | [prev] | [next] | [standalone]

#3690

On Saturday, August 24, 2013 9:36:48 AM UTC-5, Robert Miles wrote:
> On 8/23/2013 9:06 PM, 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?
> 
> >
> 
> > Thanks.
> 
> How much like Thunderbird does it need to be?  Thunderbird stores them 
> 
> in the mbox format.

I think the messages in ThunderBird may be stored in the file global-messages-db.sqlite.

That file is 291.4MB on my PC.  I don't see  any other big files in ThunderBird territory on my PC.

Thanks.

[toc] | [prev] | [next] | [standalone]

#3689

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.

[toc] | [prev] | [next] | [standalone]

#3691

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?

Not exactly a data structure, but if you're going to store emails then the 
Maildir method is the obvious choice.

http://en.wikipedia.org/wiki/Maildir


That, along with a model-view-controller to implement any abstraction that 
you require for your UI, is by far the best way to go store emails.


Rui Maciel

[toc] | [prev] | [next] | [standalone]

#3692

On Monday, August 26, 2013 8:44:40 AM UTC-5, Rui Maciel wrote:
> 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?
> 
> 
> 
> Not exactly a data structure, but if you're going to store emails then the 
> 
> Maildir method is the obvious choice.
> 
> 
> 
> http://en.wikipedia.org/wiki/Maildir
> 
> 
> 
> 
> 
> That, along with a model-view-controller to implement any abstraction that 
> 
> you require for your UI, is by far the best way to go store emails.
> 
> 
> 
> 
> 
> Rui Maciel

Yeah, I used to use a format like that for a free e-mail service.

I remember the day when the service exceeded about 32767 users.  Nobody new could sign up because the ext2 filesystem seemed to have a limit of 32767 subdirectories of a dir.

[toc] | [prev] | [next] | [standalone]

#3693

bob wrote:

> Yeah, I used to use a format like that for a free e-mail service.
> 
> I remember the day when the service exceeded about 32767 users.  Nobody
> new could sign up because the ext2 filesystem seemed to have a limit of
> 32767 subdirectories of a dir.

What were you doing to need 32767 users on a single email client configured to run on a single 
user account?


Rui Maciel

[toc] | [prev] | [next] | [standalone]

#3694

On Sunday, September 1, 2013 6:25:55 AM UTC-5, Rui Maciel wrote:
> bob wrote:
> 
> 
> 
> > Yeah, I used to use a format like that for a free e-mail service.
> 
> > 
> 
> > I remember the day when the service exceeded about 32767 users.  Nobody
> 
> > new could sign up because the ext2 filesystem seemed to have a limit of
> 
> > 32767 subdirectories of a dir.
> 
> 
> 
> What were you doing to need 32767 users on a single email client configured to run on a single 
> 
> user account?
> 
> 
> 
> 
> 
> Rui Maciel

It wasn't a single email client or a single user account.

Each user just had their own directory, which was a subdirectory of 
/coolmail/users.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.programming

csiph-web