What's the best way to store sent messages? I can store all incoming messages in a table.

[vijaygill]

Hi,

Thanks for this fantastic library!

In my test application, I can handle history sync messages and then all the new incoming messages. I store those into a sqlite DB.

Now, I want to store the messages sent via the library also into the same table.

The messages that I send from my mobile phone (same as linked device for this library), the client gets "MessageEv" and I can save message into the DB. Thus history of my chat is preserved correctly.

But the messages I send from code using this library need to be saved as well.

What is the suggested/recommended way to do so?

Thanks

The schema of my tables is:

CREATE TABLE chats (
            jid TEXT,
            lid TEXT,
            name TEXT,
            last_message_time TIMESTAMP,
            PRIMARY KEY (jid, lid)
        );
CREATE TABLE messages (
            id TEXT,
            timestamp TIMESTAMP,
            message_type TEXT,
            chat_jid TEXT,
            sender_jid TEXT,
            message_content TEXT,
            media_type TEXT,
            filename TEXT,
            url TEXT,
            media_key BLOB,
            file_sha256 BLOB,
            file_enc_sha256 BLOB,
            file_length INTEGER,
            related_message_id TEXT,
            PRIMARY KEY (id),
            FOREIGN KEY (chat_jid) REFERENCES chats(jid)
        );

[vijaygill]

Closing this as this requirement is not needed anymore.