Since 2019 I have been running TT-RSS. I started with it on a small Digital Ocean node as I was living on a sailboat at the time. Once I had a house and ISP in 2021 it became one of ~10 VMs that I ran on an old laptop via Debian KVM/QEMU, and a couple years later when I started ramping up my Proxmox cluster and things moved over there.
Also of note: I run a separate PostgreSQL VM with a bunch of databases on it and the TT-RSS database is one of those. And I just run the PHP code straight in the VM, no extra Docker layer.
TT-RSS turbulence
So a few months ago the notorious TT-RSS developer called it quits. I do believe that it will continue to be maintained, but I was pretty sure there are better options. The TT-RSS code is spaghetti. I am somewhat accepting of this because it is similar to the kind of code I tend to write. I am just an OK programmer. So the TT-RSS code is like the kind where you can easily find the lines that do real work, because there are 5,000 lines of it in one file. I have observed that "high-quality" code gets so abstracted out that it nearly all looks like boilerplate. Overall I don't mind the quality of the codebase but it is a signal.
Another issue was the Android app. I have been changing phone about once a year and there is a TT-RSS app somewhere (F-Droid?) that seems legit but doesn't work. This always bogs me down for a bit. Now the app is just discontinued? Probably I could figure it out but it shouldn't be that hard.
Where to?
I didn't do a super thorough search. I wanted something self-hosted, database-backed, very OSS, etc. I found FreshRSS and the demo site seemed OK. There are lots of knobs to twiddle. There are extensions. The GitHub page looks lively. Someone wrote a script to port all feeds and articles from TT-RSS to FreshRSS. Might as well!
(I like to think of my feed reader as an archive of sorts. Maybe 20 of the feeds I have followed over the years have now gone offline entirely. It's kind of a hoarding thing, and kind of a nostalgia thing. I like it. So I wanted to keep all those articles.)
Migration script
Back to that script. Here it is. It worked pretty well and I wrote up my experience in an issue (an abuse of the issue feature I'm sure, sorry!).
I used this script to migrate 125,000 articles from 436 feeds. A batch size of 60000 yielded 3 files of 456MB, 531MB, and 62MB. This ran in under 1 minute and pretty much maxed out the 4GB of RAM on my TT-RSS VM.
So with these file sizes I had to bump all the web server file size limits to 1000MB, PHP memory limit to 1200MB, and various timeout values to 300 seconds. This was fine for the first file, but the second one maxed out that memory limit so I reran with a 3000MB limit. Also by this point I was worried about the 300 seconds being enough so I bumped that to 3000 seconds. And that file ran fine then too. It shouldn't be hard for most people to get better import performance as my database VM storage is slow.
I imported into FreshRSS version 1.28.0. I see that your first patch has been merged, but the second one about the categories still has not. I opted not to figure out how to get the category import to work and will manually categorize them. Yes, all 436 feeds. First of all I will take the opportunity to categorize better than before. Also, I had nested categories in TT-RSS and I'm not sure how that was going to translate to FreshRSS anyways.
Thank you for the script!
Overall it went pretty smooth and I have been using it for about a week. I am happy with it! I have most of my feeds categorized and the dead ones "muted" (should be called "disabled" or something).
Duplicate articles
I did notice an issue with duplicate articles affecting a lot but not all feeds. Say a feed on a website gives the 10 latest articles. TT-RSS had pulled all 10 of those and had them in the database, along with say 90 past articles. So those 100 articles were in the TT-RSS database and were copied to FreshRSS. Then FreshRSS pulled the feed from the website and didn't recognize that those 10 articles already existed in the database, and stuffed them in again. So now there are 10 articles listed twice.
This was a little upsetting but after two days I don't really notice it anymore. I'm guessing that TT-RSS did something dumb with article GUIDs but could be wrong.
Good UI
The FreshRSS UI is pretty good, definitely better than TT-RSS. So I have already set up two features that I just hadn't bothered with in TT-RSS. I have been disabling old feeds so that they don't show up as errored out. And I have set up a few feeds to automatically download full articles when they aren't included in the feeds. This is actually super simple, no extension needed.
Other notes
I miss nested feed categories but don't really need them.
I would love to save article images to my personal S3-compatible archives but there doesn't seem to be an extension capable of doing this.
I haven't set up a mobile app yet. I have heard the website is good enough on mobile so will try that first.
I am not using any extensions yet.