AFAIK, there is no criminality (even in Russia) for homosexuality or religion.

You don’t know shit about fuck.

Peter Thiel explicitly sided with Sauron in an interview, because “things work in Mordor, while outside Mordor it’s all wishy-washy and environmental”.

Just FYI, if you just use Firefox in both OSes, you can sync the tabs, history, and extension settings. Though I’ve seen the opinion that Safari works faster, but OTOH extension developers are unhappy with Apple’s publishing/vetting process, and some devs dropped support for Safari that they provided previously.

I wonder if iOS and watchOS being macOS in miniature means that the terminal can be used on them natively, like on Android.

those little pop ups for the space and g menus

Emacs has this with the Hydra plugin, iirc. Particularly, Doom Emacs already has this feature packaged.

Zsh probably can’t do that, because zsh is involved with typing commands, not handling their output. You should look into the docs and settings for your terminal emulator — some of them do support selecting output with the keyboard. Alternatively, something like tmux might be able to handle that too.

Try Vimium if you use Firefox, Chrome, or something Chromium-based. Invoking links with ‘f’ and a couple letters is so comfortable that I now get mad when the addon doesn’t work on Mozilla’s sites (due to security concerns) or when a site has ‘links’ implemented with JS.

It’s likely much faster to fetch the common feed from the database cache or prepared cache like Redis, and apply all this additional data in the app, than do uncached joins. So I’d hope that the apps do this. Especially since you say they use Redis, which of course doesn’t do joins and such, unless something changed in the past years.

To add to other answers, the result for the ‘all’ feed is likely to be cached, either explicitly by the server app or implicitly by the database. Personal feeds are less likely to be cached, since they’re only used by individual users.

Strictly speaking, the db might be looking in an index to choose rows by the communities — but using such a condition is pretty much guaranteed to be slower than not using it, anyway.

The actual answer depends on the actual database organization, of course. Ideally the whole database should be organized around frequent queries.