Enhancement Chat Service Database Solution - Chat Logs and Messages

[parhamrahmani]

Description

Related to this thesis issue

This issue should be an enhancement on the existing approach for chat logs and messages that was presented in my last pull request

Motivation

Existing problem: all chat messages from all chat sessions would be stored on a single table that may cause bloat and scalability issues (can't be scaled horizontally) and is not ideal for bigger volumes.

Details

Possible solutions:

• A NoSQL document database for chat messages that can organize chat messages to collections of documents instead of a single SQL table, which makes it possible for scaling horizontally. Ideal for larger, semi-structured data.
• or implementing a partitioning/sharding logic for the chat message table to avoid bloat and make it possible for horizontal scaling and ideal for bigger volumes.

[parhamrahmani]

@astanik I am already working on this here. This is a needed part of the thesis, but if you see this as a not needed enhancement, i can just develop this on the forked branch and don't merge it here.

[astanik]

@parhamrahmani If you would like to develop this enhancement as part of your thesis anyway, then you can do so via this issue and we will evaluate the result after completion.