DB issues

[MarcS1975]

Pre-submission Checklist

• I have searched the existing issues and this bug has not been reported yet
• I have tested this issue on the demo site or the latest version

Where did you encounter this bug?

Latest stable version (self-hosted)

Memos Version

v0.26.0

Bug Description

I need to merge the data from two Memos installations.
What kind of DB is Memos runnning?
The Memos description says:
Plain text storage — take your data anywhere
but I see a .db file so I guess Mysql or mairadb?

Any insight in data structures?

Steps to Reproduce

I need to access notes. Where are they? In dB?

Expected Behavior

No response

Screenshots & Additional Context

No response

[wolveix]

It's a SQLite database. You can interact with it via the sqlite3 CLI tool. E.g. to show table schema, run .schema.

Edit: from the repo README, you can optionally use MySQL or PostgreSQL, but Memos uses SQLite by default which will be the .db file you're seeing.