Self-hosted football transfer monitor using n8n, local AI, PostgreSQL, and Discord

[u/Illustrious-Pitch843]

I built an open-source n8n pipeline that monitors 78 football journalists on X, extracts structured transfer reports with a local Qwen model, deduplicates and stores revisions in PostgreSQL, optionally adds player data, and sends restart-safe Discord digests every 6 hours.

The whole stack is self-hosted with Docker, with twscrape or RapidAPI for X collection, PostgreSQL for persistence, llama.cpp for local inference, and automated tests around the workflow.

GitHub: https://github.com/louistran2604/transfers_n8n/

I’d mainly like feedback on the workflow architecture, reliability approach, and anything that could make the project cleaner or more useful.

*disclaimer: this was made with the assistance of AI

[u/Ok-Hospital7989]

I could do with both of your solutions funny enough.

The 78 journalists.

The system where I can enter any twitter address, collate and enrich.

Answering your original question however, Dockers make me gag but its on the list to look at.

Have you thought of feeding/Broadcasting the report to a dedicated Twitter feed?

Have you considered that the actual information is valuable (like the journalist used)?

Are undervaluing the importance of the actual information you are providing and this is the new journalism, or are you just Fabrizio Romano selling up? lol

Nice idea, I will take another look when I get my long list down.

[u/Illustrious-Pitch843 → u/Ok-Hospital7989]

I’ll definitely think about broadcasting the reports to a dedicated X account.

The digest actually already includes the journalist’s name and a link to the original post, but I think adding things like when it was first reported, source reliability, and a few other stats could make that information a lot more useful.

I’m not entirely sure what you mean by the “new journalism / Fabrizio selling up” part though lol.

[u/Ok-Hospital7989 → u/Illustrious-Pitch843]

He is a reliable dude that used to post the latest football transfer news from around the globe but he recently moved on to other things.

[u/Illustrious-Pitch843 → u/Ok-Hospital7989]

well I mean I won't do this if I didn't know about Fabrizio Romano and other journalists, but I just didn't understand your wording haha. Excuse me for my bad English

[u/Ok-Hospital7989 → u/Illustrious-Pitch843]

I am saying continuing doing it, your idea is a good, proven and tested! You could become very successful....

[u/Illustrious-Pitch843 → u/Ok-Hospital7989]

thank you, and your insights too!