In-Memory SQLite database drops data for unknown reasons

[adzialocha]

I've observed this a couple of times now where my longer running node with in-memory SQLite database failed with:

Error occured during `EntryStorage` request in storage provider: error returned from database: (code: 1) no such table: entries

My assumption is that other processes (other programs using in-memory database, like fishy or other aquadoggo instances) wipe / amend the database but not sure.

[adzialocha]

Still not sure why SQLite behaves like this. It might need a similar fix as we already have for our test environment (in-memory databases where each one receives a random id)

[adzialocha]

Related issue: launchbadge/sqlx#2510