Sven-Meikel Auer | Tech Blog: EMAIL-TO-DB | Email archiving software | Saves directly to an sqlite or MySql database | attachments are in the file system!

Sven-Meikel Auer | Tech Blog 

EMAIL-TO-DB | Email archiving software | Saves directly to an sqlite or MySql database | attachments are in the file system!

by Sven-Meikel Auer


Posted on Mittwoch März 20, 2024 at 05:26vorm. in MY SOFTWARE


information and technical data

EMailToDB JAVA VERSION

Sales are carried out by our authorized seller JVZOO! By clicking on the button above you will be taken to the JVZOO with our offer!

EMailToDB APP.png

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!

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.

LICENSE
The license includes software updates for 1 year! The software must be renewed after one year if you want to continue using it. 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.

EMailToDB JAVA VERSION

Sales are carried out by our authorized seller JVZOO! By clicking on the button above you will be taken to the JVZOO with our offer!

Email to Database.png

Who can buy this product?

Can be ordered by private or business customers!

Kontakt aufnehmen

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




Bisher hat niemand einen Kommentar verfaßt

Einen Kommentar hinterlassen

HTML Syntax: Ausgeschaltet