this post was submitted on 12 Oct 2023
0 points (50.0% liked)

Self-Hosted Main

511 readers
1 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

For Example

We welcome posts that include suggestions for good self-hosted alternatives to popular online services, how they are better, or how they give back control of your data. Also include hints and tips for less technical readers.

Useful Lists

founded 1 year ago
MODERATORS
[email protected]
0
FreshRSS: Where the SQL Lite file is located? (alien.top)
submitted 1 year ago by [email protected] to c/[email protected]
6 comments fedilink hide all child comments
 

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?

top 6 comments
sorted by: hot top controversial new old
[–] [email protected] 1 points 1 year ago

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.

[–] [email protected] 1 points 1 year ago (1 children)

I would do a search for *.sqlite

[–] [email protected] 1 points 1 year ago (2 children)

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

[–] [email protected] 1 points 1 year ago

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

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

[–] [email protected] 1 points 1 year ago

Yes and that definitely would not stop me from looking

[–] [email protected] 1 points 1 year ago

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.