Over the weekend, I sat down with my old buddy Claude and made a new backend for rss.chat written with Go.
The big differences are that it splits the database into more task relevant pieces, and ports it to sqlite rather than mysql. (its just a file!).
With this new foundation I'm able to do some hacking on pieces that I'm interested in, like websockets (I'm super impressed with Bluesky's ATProtocol "Jetstream" service), and getting a native phone interface up and running.
The code is available at https://github.com/roberte3/rss.chat.go.