【Record】TTRSS Uses Supabase as Database

Supabase is one of the BaaS platforms that can provide PostgresSQL databases; TTRSS is a free and open-source RSS aggregator reader based on PHP, which can be deployed on a VPS. Using Supabase as the database for TTRSS can reduce the load on the VPS and avoid data loss if the VPS goes offline.

Create the Database#

Choose a region close to your VPS, for example, select "US West" for the free turtle shell in San Jose.
Go to the settings page of the project and record the connection information of the database.

Set Up TTRSS#

Set up reverse proxy service

mkdir -p ~/app/TTRSS && cd ~/app/TTRSS && nano docker-compose.yml
sudo docker-compose up -d && sudo chmod -R 777 feed-icons
# Default account: admin
# Password: password

version: "3"
services:
  ttrss:
    image: wangqiru/ttrss:latest
    environment:
      - SELF_URL_PATH=https://read.limour.top/ # please change to your own domain
      - DB_HOST=db.xxx.supabase.co
      - DB_PORT=5432
      - DB_NAME=postgres
      - DB_USER=postgres
      - DB_PASS=<password set>
    volumes:
      - ./feed-icons:/var/www/feed-icons/
    stdin_open: true
    tty: true
    restart: always
 
networks:
  default:
    external: true
    name: ngpm

msedge_yOlW0uXlrs

Use FeedMe#

FeedMe is an Android reader for RSS services.

Enable the API in TTRSS preferences.
Choose Fever as the login method instead of TTRSS.
The API endpoint is https://xxx/plugins without .local.
Enable e-ink optimization in FeedMe settings, and set the layout in the viewer to "Card". The effect is as follows:

Additional Items#

Set up RSSHub
Deploy a local PostgresSQL database

mkdir -p ~/db/PostgreSQL && cd ~/db/PostgreSQL && nano docker-compose.yml
sudo docker-compose up -d
sudo docker exec -it postgres-db psql
# Use the command \q to exit psql

version: '3.3'
services:
  postgres:
    container_name: postgres-db
    environment:
      - TZ=Asia/Shanghai
      - POSTGRES_USER=root
      - POSTGRES_PASSWORD=ROOT_ACCESS_PASSWORD
    volumes:
      - './pgdata:/var/lib/postgresql/data'
    image: postgres
    restart: unless-stopped
 
networks:
  default:
    external: true
    name: ngpm

Create a new database

# sudo docker exec -it postgres-db psql
create user ttrss with password 'ttrss_passwd'; # Create user ttrss
CREATE DATABASE ttrss OWNER ttrss; # Create user database
GRANT ALL PRIVILEGES ON DATABASE ttrss TO ttrss; # Grant all privileges to ttrss