This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

So there's something interesting I’ve been seeing on social media, and was wondering if anyone here might have any insight into this.

I’m assuming you all know the story, but I’ll sum it up. 2016 Depp and Heard divorce. It’s implied that Depp was abusive of Heard and then TMZ obtains video of Depp yelling and throwing cabinet doors around. Depp is still in good standing with the industry, but a year later MeToo happens and the Depp stuff is now evaluated with that climate.

Depp seems to be still getting work, including Fantastic Beasts, but then Heard publishes an op-ed in the Washington Post claiming to be a victim of domestic abuse by Depp, who she only refers to as a former husband.

The internet largely backs Heard, that mixed with Aquaman being released around the same time as the op-ed, becomes a launching pad for her career into the mainstream.

Then in early 2019 new evidence comes out that Heard was abusive towards Depp. A shift on the internet becomes prominent. People start to side with Depp and in early 2020 (still pre-pandemic) phone recordings of Heard admitting to hitting Depp were released.

Suddenly the “woke” standpoint, in terms of the online culture war, became to believe Depp. At least for the most part, there were still some corners of the internet and personalities who were still calling Depp an abuser. But still, things tilted in favor of Depp. Even when the UK trial against The Sun didn’t go his way, the stance was largely pro-Depp.

Then the U.S trial happens. And things shift again. Suddenly we get articles begging people to believe Heard.

Even when progressive news outlets and journalists defended Depp they would get dog-pilled by other left-of-center people. This included Shure getting called a fake feminist and a Republican.

So what happened here. Why did Depp’s position in the online culture war change, or was it ever changed to begin with?

This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

I like watching speedrunning videos, especially ones where they break the game in really interesting and novel ways. Every now and then when I'm bored I search "any% speedrun" on YouTube, but... the search results feel gamed by clickbaity Top 10 videos, Soulslike games, and the latest hyped up title of the month.

So I thought I'd ask if you guys have any videos to share. Maybe even like, favorite GDQ videos or favorite niche games you like. Stuff like that?

Here's what I've got:

• Sethbling's "4 Different Mario Credits Warps in Under 15 Minutes" -- Specifically for the Super Mario Land 2 speedrun. I really love how the game's code and RAM gets interpreted as level data, and he has to navigate the garbage sprites to get to a point where it will trigger a debug flag to load the credits.
• Luigi's Mansion any%: Something about the OOB route here is so spooky and interesting to me. It's a 3D game, but fixed perspective, so you don't get the freedom of movement you would in a game like Super Mario 64. That makes any OOB tricks really funky, with Luigi skewing oddly and going off camera in a way that forces the runner to intuit and feel out where to go. It's neat!

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

This may seem like an odd request and I'm not sure if I can properly explain this, but for some reason I dislike games that require me to drag things with my fingers. I prefer games that allow me to "click" stuff using my finger as a mouse, like Go (baduk), checkers, and other board games. Any genre. Any suggestions on Android? Thanks!