Oh, sleeper
War of ages
The weekly show had a good segment with Mark Cuban he really lays out some solid discussion on how the progressive side of politics for business. https://youtu.be/bnhxbZlvMRQ
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.
Most companies implement for malicious link control. They can actively scan as needed and they can prevent users from going to any links deemed malicious. It also adds tracking for amount of clicks on a specific URL. There are more nefarious uses that others have stated redirection for paid links to them and user profile building for ad targeting
It's been mostly this way for a while reason why it takes a little bit before lineageos releases the next version. AOSP is just fully down stream. What will be concerning is when those releases get longer and longer. As another comment said we all just need to figure out linux phones. Been eyeing a pine phone for a while now should probably pull the trigger.
Same just running in docker have DNS and few other services running side by side on a pi4