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.
this post was submitted on 12 Oct 2023
0 points (50.0% liked)
Self-Hosted Main
515 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
- Service: Dropbox - Alternative: Nextcloud
- Service: Google Reader - Alternative: Tiny Tiny RSS
- Service: Blogger - Alternative: WordPress
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
- Awesome-Selfhosted List of Software
- Awesome-Sysadmin List of Software
founded 1 year ago
MODERATORS
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
Yes and that definitely would not stop me from looking
.sqlite or .db are the usual suspects, but you can always use some shell magic:
find . -type f | file -f - | grep SQLite
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.