I used reader.google.com in the past, but it was shut down and I got reminded that it was a free service someone else was hosting. Then I used feedly, but it was not optimal. Tiny Tiny RSS (ttrss) seems like the best solution for me. https://tt-rss.org/ - Tiny Tiny RSS
Until 2021, I simply used a clone of the ttrss git repo, and updated that clone every now and then. Since 2021, the official/documented way of running ttrss is via containers. In 2023, I created a podman based version, which I'm using since then.
Many pages are not as social as they should be, they are not offering feeds. ttrss can directly read feeds, but for example twitter needs extra care. I use 2 solutions for it:
Normally, I just update the ttrss code via 'git pull origin', and schema updates are then recognized. For a friend, the schema update takes so long that it runs into a timeout. How to execute the schema update manually?
The single incremental schema updates are in this directory for Postgres: $ ls -rt ttrss/schema/versions/pgsql/ [..] 137.sql 138.sql 139.sql So if one is already on schema 138, one can access the ttrss-db and then execute the code from 139.sql. $ su - postgres [postgres]$ psql ttrss <code from 139.sql>
Alternatively, “php update.php –schema-update” should work.
# first, in the ttrss webinterface go to preferences/feeds and # create an OPML export. With that, you can restore your feeds # later if something goes wrong. cd /opt/soft/ttrss/ttrss-docker git pull origin docker-compose stop docker-compose pull docker-compose up -d # login again
podman exec -it rss-app sh cd /var/www/html/tt-rss/themes cp night.less night_cust.less cp night.css night_cust.css grep system-ui night_cust.css sed -i 's/system-ui/"Noto Sans CJK JP"/' night_cust.css