The data are not saved in the sqlite database.

[tigerzioo]

Create docker
docker run -d --name memos -p 5230:5230 -v ~/.memos/:/var/opt/memos ghcr.io/usememos/memos:latest

I can see memos_prod.db file in the ~/.memos but I don't think the data are saved there. I moved it to a new memos docker. I don't see the data. I deleted the db file in my old docker. I still can login and see my notes.

I am confused. Where are my data? I am trying to move it to my new memos docker.

Thanks

[tigerzioo]

I figured it out. The sqlite creates WAL file to store the uncommit data so the uncommit data will not be stored in the db file.
I am wondering if this is a bug or I did something wrong in the configuration. Does the memos use BEGIN [TRANSACTION] in the insert or update queries? According to the sqlite document the COMMIT [TRANSACTION] needs to be used to confirm the transaction so the data can be stored in db file instead of WAL file.
I have to stop the docker to commit the transactions. After stopping the docker and starting the docker, I can find my note data in the db file.
so if I only backup the db file, I will lost all uncommit data. I have to backup db and wal files.
Or I need to stop the docker and backup the db file.
Hope this is helpful.