I like to query the FreshRSS’s SQL Lite file using SQLiteStudio .
Where is the SAL Lite data file located? It is only one data file?
How did you install freshrss, and what operating system are you using. If using docker, which docker image? There are multiple freshrss images. Do you explicitly map a docker volume or are you letting docker create an anonymous volume behind you back?
On my docker install using https://github.com/linuxserver/docker-freshrss the sqlite file is at this location inside the container at /var/www/FreshRSS/data/users/_/db.sqlite I have a bind mount mapping /var/www/FreshRSS/data to ./data . So, the sqlite file is in data/users/_/db.sqlite relative to the directory holding the docker-compose.yaml file.
I would do a search for *.sqlite
Sqlite files don’t always have that extension though. .db is also common, but it might be something else entirely
.sqlite or .db are the usual suspects, but you can always use some shell magic:
find . -type f | file -f - | grep SQLiteYes and that definitely would not stop me from looking
I expect you already have it installed, but it probably would have been better to use PostgreSQL, mariadb or mysql if you wanted to use some tool to run queries.
Looking through Google, it can be done using the CLI.