

Opensearch will be the most performant. Anything sql will likely start to stumble with lots of stories or really long stories where this is exactly what lucene based search engines (solr, elastic, opensearch) are designed to do. Could an SQL solution solve your problem, yes, but it may be a bit on the slow side as your amount of stories and size grows.
I had the same experience. Long time kubuntu user and various other distros. Got on the nixos bandwagon used it on a couple computers. The breaking part for me was all well supported applications was great, but where it broke down hard were the fringe or unsupported applications I was spending a lot of time building the nix configs. After a while I just couldn’t spend that much time making my computer work. Back to kubuntu lts, its so low maintenance.