Skip to content

OpenTech.News - Project Notes & Journal

2025-07-14

Priority Outcomes - Automate data import (1 minute) - Automate build webpage (1 minute)

Boot-up on linux

python3 -m venv venv-linux
source venv-linux/bin/activate
pip install -r requirements.txt
source _SECRETS/set_supabase.env
python app/load-newsfeed-stories-to-database.py

# Load AWS credentials

# Load Supabase credentials

/home/public/Public-SYNC/2025/_Projects/OpenTechNews/venv-linux/bin/python /home/public/Public-SYNC/2025/_Projects/OpenTechNews/app/load-newsfeed-stories-to-database.py

Accomplishments

  • Automated News Fetcher & Website builder on local cron
    • TO-DO: Make paths relative, instead of absolute
  • Bold as a different color - make it pop
  • Fix hover highlight
  • Font: Avenir Book
  • Add news feeds
    • Postgres
    • Python
    • FastAPI

Next

  • Fix title
    • Align with stories
    • OpenTech to purple-ish?
    • Padding
  • Story number
  • Enlarge titles to be bigger
  • Auto refresh
    • Javascript
  • Continuous scroll / pagination
  • Rewrite headline (AI)
  • Ask Josh, favorite feed
    • Super awesome feed

Later

  • Change date to show just time
  • Date/time localizes to user browser
    • Javascript?
  • Group by date header

Top headline right now: 2025-07-14T23:58:28+00:00 How I Made an Unreliable External API Reliable; - DEV Community

2025-07-13

Next time

  • Format date as time
  • Group stories by date (H2)
  • Title
  • X LCARS style
    • Background is black
  • Automate every 1 minute

Stories

  • Story Link
  • Story Title
  • Story Publish Date
  • Source Name
  • Source Link
  • Keywords

Feeds

  • Feed Link
  • Feed Name
  • Type (RSS)

Migrate remote code repository from GitLab to Codeberg

Created new repository: https://codeberg.org/jro/OpenTechNews

git remote remove origin    
git remote add origin https://codeberg.org/jro/OpenTechNews.git
git push -u origin main

Setup Python virtual environment:

python3 -m venv venv-mac
source venv-mac/bin/activate

Install packages

pip install feedparser
pip install boto

# Save Python package requirements
pip freeze > requirements.txt

Python

Run program as main

if __name__ == "__main__":
    print("Hello, this is the main program!")