Sven-Meikel Auer | Tech Blog 

NEW: THE MYSQL SERVER EDITION IS NOW INCLUDED WITH A PURCHASE! IT ALLOWS YOU TO SAVE YOUR E-MAILS IN A MYSQL DATABASE!

Would you like to securely archive all emails on your PC/MAC/SERVER? Then I have the right solution. Correct: All emails are not archived on third-party servers, but rather stored directly on your computer or any server. So, you have full control!
Now you can everything with your E-Mails do!

TECHNICAL DATA
The software works on Microsoft Windows, Apple macOS and Linux (CentOS, Fedora, RHEL, AlmaLinux, Rockylinux, OpenSUSE, SLES, Ubuntu, Debian) with 64-bit. JAVA version 17 is supported.

WHERE IS IT SAVED TO?
The data is still saved under SQLITE. If you are interested even after purchase, I will submit a MySQL version in the next few weeks. Then you can also use MySQL as a database. However, SQLITE is usually sufficient as it can store terabytes of data. If there is really not enough space, you can simply save the JAVA application in another folder and run it and the email messages and email attachments will be saved in a new directory (in the folder where this JAVA application is located Both are stored (SQLITE database and in the attachments folder). Combined with the start and end times, you will never have a bottleneck.

What does this application do?
This software not only saves all messages from a specific specified period, but also uses a database to store the emails in a structured manner. The attachments used in the email are saved in a folder in the file system. The reason for this is that when the attachments are saved in the database, they become too bloated. Therefore the attachments are stored in the file system. The advantage is that you can search the saved emails for words, but above all also to use them in other programs and of course to generate a data archive. So you can then delete the emails on the mail server after archiving them with my program to make space. Another advantage is that the backup can be copied to any computer as a further backup using my program and, above all, the user decides what happens to his backup. Simply storage directly with the customer or wherever he wants.

Regardless of the operating system, all IMAP email mailboxes can be backed up in the database!

The following records are stored in the database:

Table name: EMailMessages

• id als UUID/VARCHAR
• smabody als LONGTEXT
  Email text (only text no html - html will be converted to text)
  
• smabodyhtml als LONGTEXT
  E-Mail-Text (only html)
• smacontentType als LONGTEXT
  Content Type
• smaemailaccount als LONGTEXT
  z. B. imap.gmail.com | anyemail@example.com
• smaflags als LONGTEXT
  Flags like /seen
• smafolder als LONGTEXT
  The folder that was specified when the program started. This means that the folder in which the emails are located is specified here (e.g. "inbox").
• smafrom als LONGTEXT
  Who the email came from.
  
• smafromAllHeaders als LONGTEXT
  The complete header of the email is displayed here.
  
• smamessageid als LONGTEXT
  The News Id.
  
• smareceivedDate als TIMESTAMP
  The date of receipt in the following format:
  2020-01-01 06:24:49
  
• smarecipients als LONGTEXT
  All recipients of this email in the format:
  anyemail@example.com |
• smasentDate als TIMESTAMP
  The sent date (if it is an incoming email, the date is the received date) in the following format:
  2020-01-01 06:24:49
  
• smasize als BIGINT
  The message size as BIGINT - for example:
  61226
• smasubject als LONGTEXT
  Der Betreff der Nachricht.

Table name: EMailAttachments

• id als UUID/VARCHAR
• SmaUniqueMessageId als UUID/VARCHAR
  Unique id (only exists once per email message). Is the unique id of the table EMailMessages.
• smaattfilename als LONGTEXT
  File name of the attachment assigned by the system.
  
• smaattname als LONGTEXT
  Original file name of the attachment.
  
• smafolder als LONGTEXT
  The folder that was specified when the program started. This means that the folder in which the emails are located is specified here (e.g. “inbox”).
  
• smamessageid als LONGTEXT
  The message Id. Has the same Id of the original message from the table EMailMessages.

The attachments are saved in the program directory in the “attachments” subfolder.

I am available Monday to Sunday and on public holidays!
You can easily answer your questions by email by clicking here!