error returned from database: (code: 7) out of memory

[stopdesign]

What are the system requirements?
I constantly getting "out of memory" error on any db-related operation while running on linux machine.

First, I couldn't even initialize the db:

me@uc:~ $ gurk
Enter passphrase · ********
Error: failed to open signal storage at: ~/.local/share/gurk/signal.sqlite

Caused by:
    0: while executing migrations: error returned from database: (code: 7) out of memory
    1: error returned from database: (code: 7) out of memory
    2: (code: 7) out of memory

After manually creating an empty table "t" in signal.sqlite:

Enter passphrase · ********
Error: failed to open signal storage at: ~/.local/share/gurk/signal.sqlite

Caused by:
    0: while executing migrations: error returned from database: (code: 26) file is not a database
    1: error returned from database: (code: 26) file is not a database
    2: (code: 26) file is not a database

After creating DB and conf files on a Mac, I copied all and got the app running. Now I got an error while sending a message:
"Protocol error: invalid state for call to sqlite to succeed: error returned from database: (code: 7) out of memory"

gurk v0.7.1 installed with cargo binstall --git https://github.com/boxdot/gurk-rs gurk

[stopdesign]

I tested previous version, 0.6.4, which doesn't store signal data in encripted sqlite. It works without issues.

[boxdot]

@stopdesign Currently, all chats are cached in memory. So, the memory consumption is quite high. This is definitely an issue we should fix and prioritize. First, only cache the messages of the current chat. Second (which is harder to implement), only cache a window of messages we can actually render.