FreshRSS: Where the SQL Lite file is located?
reddit / selfhosted

----------------------------------------------------------------------
RevolutionaryHunt753 · 2023-10-11 19:20

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?

----------------------------------------------------------------------
Murky-Sector · 2023-10-11 19:35

I would do a search for \*.sqlite

----------------------------------------------------------------------
trxxruraxvr · 2023-10-11 19:38

Sqlite files don't always have that extension though. .db is also
common, but it might be something else entirely

----------------------------------------------------------------------
geo38 · 2023-10-11 19:53

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.

----------------------------------------------------------------------
Murky-Sector · 2023-10-11 19:58

Yes and that definitely would not stop me from looking

----------------------------------------------------------------------
zoredache · 2023-10-11 21:38

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.

- https://github.com/FreshRSS/FreshRSS/discussions/4748
- https://github.com/FreshRSS/FreshRSS/blob/edge/cli/README.md

----------------------------------------------------------------------
Darth_Baggins_ · 2023-10-11 23:27

.sqlite or .db are the usual suspects, but you can always use some
shell magic:

`find . -type f | file -f - | grep SQLite`

----------------------------------------------------------------------
trxxruraxvr · 2023-10-12 05:39

You can run most queries in sqlite. There's really no point in running
an extra database process unless you've got multiple database users or
a lot of concurrent writes happening in the database.