Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. [Message Deleted] [modified]

[Message Deleted] [modified]

Scheduled Pinned Locked Moved C / C++ / MFC
database
6 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    kanitamildasan
    wrote on last edited by
    #1

    Hi all, I am working on an e-mail client application I've planned to store every email as *.eml file in the user's appropriate folder (physically created folder like Inbox, Sent Items etc) in HDD and keeps an *.MDB (CDaodatabase) with fields like folder, from, to, subject, emlfilepath, emlfilename So I can query the DB for fast retrieval and when user click/select a mail than open the eml file and show the mail content on the preview pane Is this a right way for the e-mail client storage OR any suggestions appreciated -- modified at 6:06 Wednesday 27th September, 2006

    W L 2 Replies Last reply
    0
    • K kanitamildasan

      Hi all, I am working on an e-mail client application I've planned to store every email as *.eml file in the user's appropriate folder (physically created folder like Inbox, Sent Items etc) in HDD and keeps an *.MDB (CDaodatabase) with fields like folder, from, to, subject, emlfilepath, emlfilename So I can query the DB for fast retrieval and when user click/select a mail than open the eml file and show the mail content on the preview pane Is this a right way for the e-mail client storage OR any suggestions appreciated -- modified at 6:06 Wednesday 27th September, 2006

      W Offline
      W Offline
      Waldermort
      wrote on last edited by
      #2

      Your idea is not very secure. Keeping emails on the HD like that leaves them wide open for people to read. I suggest you implement some sort of encryption. Also, as a user, I would not like individual emails to be stored in this way (even if they are encrypted). It shows people how many emails I have, and roughly when I recieved them, again not very secure. What I would like though, an encrypted container. Take a look at 'Jetico Bestcrypt'; or a form of password protect filesystem. Either of these would make it easy for you to store .eml files, and keep it secure.

      K 1 Reply Last reply
      0
      • W Waldermort

        Your idea is not very secure. Keeping emails on the HD like that leaves them wide open for people to read. I suggest you implement some sort of encryption. Also, as a user, I would not like individual emails to be stored in this way (even if they are encrypted). It shows people how many emails I have, and roughly when I recieved them, again not very secure. What I would like though, an encrypted container. Take a look at 'Jetico Bestcrypt'; or a form of password protect filesystem. Either of these would make it easy for you to store .eml files, and keep it secure.

        K Offline
        K Offline
        kanitamildasan
        wrote on last edited by
        #3

        waldermort, thanks for the point I’ll lookout for encrypting the mails If performance concerned, Is it ok to go with MDB/*.eml(encrypted)OR with single custom database file format like outlook express thanks in advance

        1 Reply Last reply
        0
        • K kanitamildasan

          Hi all, I am working on an e-mail client application I've planned to store every email as *.eml file in the user's appropriate folder (physically created folder like Inbox, Sent Items etc) in HDD and keeps an *.MDB (CDaodatabase) with fields like folder, from, to, subject, emlfilepath, emlfilename So I can query the DB for fast retrieval and when user click/select a mail than open the eml file and show the mail content on the preview pane Is this a right way for the e-mail client storage OR any suggestions appreciated -- modified at 6:06 Wednesday 27th September, 2006

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          I have written an email client and I stored files in mbox format - each "folder" consists of a single file, which is plain text and contains all the email messages delimited with "From - date". I maintain a separate binary index file for each "folder" that contains a list of messages and their position in the main mbox file (and other useful information such as the message size, common header fields like To, From, Subject, etc.). This isn't too far away from how Mozilla Thunderbird works.

          K 1 Reply Last reply
          0
          • L Lost User

            I have written an email client and I stored files in mbox format - each "folder" consists of a single file, which is plain text and contains all the email messages delimited with "From - date". I maintain a separate binary index file for each "folder" that contains a list of messages and their position in the main mbox file (and other useful information such as the message size, common header fields like To, From, Subject, etc.). This isn't too far away from how Mozilla Thunderbird works.

            K Offline
            K Offline
            kanitamildasan
            wrote on last edited by
            #5

            thanks robert

            Robert Edward Caldecott wrote:

            each "folder" consists of a single file, which is plain text and contains all the email messages delimited with "From - date". I maintain a separate binary index file for each "folder" that contains a list of messages and their position in the main mbox file

            But we have to write our own parser(non buggy) for the Index and Mail file I hope SQL queries in MDB gives more customizable(and faster) filters than our own file format

            Robert Edward Caldecott wrote:

            This isn't too far away from how Mozilla Thunderbird works.

            If MDB is not the right way to go Is there any Component/Library which handles the parsing for me ? thanks again

            K 1 Reply Last reply
            0
            • K kanitamildasan

              thanks robert

              Robert Edward Caldecott wrote:

              each "folder" consists of a single file, which is plain text and contains all the email messages delimited with "From - date". I maintain a separate binary index file for each "folder" that contains a list of messages and their position in the main mbox file

              But we have to write our own parser(non buggy) for the Index and Mail file I hope SQL queries in MDB gives more customizable(and faster) filters than our own file format

              Robert Edward Caldecott wrote:

              This isn't too far away from how Mozilla Thunderbird works.

              If MDB is not the right way to go Is there any Component/Library which handles the parsing for me ? thanks again

              K Offline
              K Offline
              kanitamildasan
              wrote on last edited by
              #6

              Is there any MDB data VS (MS)XML data parsing/query/filtering performance review on the net ?

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups