subversive_dev

ITT bold brave fediverse user discovers that people gravitate towards servers that align with their views

It starts with a right-wing conspiracy fueled media ecosystem, I imagine the “best” minds are already working on that

I’m not a mod but this seems like the sort of post that will get you dunked on, not banned. Unless there’s some dog whistles I’m not understanding it’s not really racist just…lame?

The lesson from Hindenburg that is true to this day is that liberals and “moderates” will ALWAYS side with the fascists against any socialist movement because they serve the same master. Have you been watching capital’s media lap dogs respond to Mamdani’s candidacy? Just keep watching and observe how many “mainstream Democrats” fall in line behind human trash piles Cuomo or Adams.

Saying the good cop is “better” then the bad cop may be true in some sense but is ultimately irrelevant and distracting. Both are your enemy and if you trust either one, you’ll get fucked every time.

Sucking up to the Democratic party is like expecting that sucking up to the good cop in the interrogation room will lead to leniency in the courtroom (aka a fool’s gambit)

They have been crying wolf for 2 years and no one cares what they have to say anymore

Don’t worry, you can fill up on your daily helping of vote blue no matter who circlejerk on !politicalhumor@lemmy.world

OP this is wildly inaccurate because you didn’t put a smiling mask on the Democrats OR show how they are actually an infinitesimal bit better than the Republicans and they’re dying on that hill

It is important to indoctrinate the youth in the ways of righteousness

I’m a little confused because the comic only has two panels? Additionally, in the second panel the character’s eyes are still round not any other shape - I don’t see squinting at all? (If you were trying to draw a head that small with eyes that were squinting, you would use angled lines, not circles)

In any case, I believe the interpretation of the comic intended by the creator is: “Panel one represents what Western liberals say about China. Panel 2 represents the media environment they swim in”

Why?

The meme assumes the Western context. We don’t trust the US government because of the centuries of violence and exploitation. We had to go looking for that information because it is minimized and buried at every turn by the compliant national media.

On the other hand, the supposed abuses of the Chinese government are loudly broadcast at every turn. You’ll find if you go looking outside of Western sanctioned sources that all of those criticisms are absurd fabrications.

Therefore, someone in the western context who says they don’t trust the US or China is trusting the US media for information about China but not about the US itself. Does that help?

Of course!

If you are being serious that’s Derek Chauvin murdering George Floyd

This is both the right and wrong answer

“I like being a libertarian because it allows me to be selfish, ignorant and rude while still feeling morally justified in all my actions”

Sounds like someone who is really confident in the strength of their arguments and the courage of their convictions

I can’t vouch for it, but have you ever looked into nushell? It is built around a table abstraction from top to bottom

he’s dead jim

Done: https://github.com/LemmyNet/lemmy/issues/5555

Good evening Dessalines, I have started looking at the posts query.

The lowest hanging fruit I think would be if we could replace some of the joins with WHERE EXISTS which can have a huge impact on the query time. It seems this is supported in Diesel: https://stackoverflow.com/a/74300447

This is my first time looking at the codebase so I can’t tell yet which joins are purely for filtering (in which case they can be replaced by WHERE EXISTS) and which joins need to be left in because some of their columns end up in the final SELECT

I can’t tell for sure yet but it also looks like this might also be using LIMIT...OFFSET pagination? That can be a real drag on performance but isn’t as easy to fix.

EDIT:

Looking some more, and reading some linked github discussion - I think to really get this out of the performance pits will require some denormalization like a materialized view or manual cache tables populated by triggers. I really like the ranking algorithm but so far I’m finding it difficult to optimize from a query perspective