It is pretty clear there are certain subject areas where the discussion simply never goes well here. This isn't a Tildes thing really. Frankly these topics rarely go well anywhere online but, as we have aspirations 'round these parts of being more sophisticated than the Reddit rabble, I think it's worth digging into.

Overall Tildes is a fairly low-activity site, but if I ever see a topic that even tangentially touches on "identarian" issues get past double-digit comments, there will almost surely be an acrimonious exchange inside. I don't want to pretend I'm above this, I've been sucked into these back-and-forths myself as, I think, has almost every regular poster at one time or another. I've largely disengaged from participating in these at this point and mostly just watch from the sidelines now.

Unlike most of the common complaints with Tildes, I don't think this one will get better as the site grows and diversifies. If anything, I think it's going to end up creating norms and a culture that will bleed over into other controversial topics from tabs/spaces to iOS/Android. To keep that from happening, the community will need to form a consensus on what "high quality discussion" means and what we hope to get out of having conversations on these issues here.
To start, when I say "doesn't go well" I'm thinking of indicators where some combination of the following happen:

1. None of the participants learn anything new about the subject, themselves, or another viewpoint
2. Preponderance of "Malice" and "Noise" tags
3. Heated back-and-forth exchanges (related to the above)
4. Frequent accusations (and evidence) of speaking in bad-faith or mischaracterization of peoples' statements

These threads end in people being angry or frustrated with each other, and it's become pretty clear that members of the community have begun to form cliques and rivalries based on these battle lines. It also seems like the stridency and tone are making people leave out of frustration, either deleting their accounts or just logging off for extended stretches of time, which is also an outcome we don't want. So let's go into what we can do to both change ourselves and how others engage with us so people feel like they're being heard without everything breaking down into arguments.

The "Whys" of this are varied and I'm sure I don't see the whole picture. Obviously people come into any community bringing different background experiences and with different things they're hoping to get out of it. But in my view the root cause comes down to approaching discussions as a win/lose battle rather than a shared opportunity to learn about a subject or perspective. From observing many of these discussions without engaging, there are evident patterns in how they develop. The main thrust seems to be that criticism and pushback pretty quickly evolve from specific and constructive (e.g. "This [statement or behavior] is problematic because [reason]") to general and defamatory (e.g. "[Person] is [bad thing], as evidenced by them doing/making [action/statement]").

This approach very quickly turns a conversation between two people into a symbolic battle about making Tildes/the world safe for [community], defending the wrongfully accused, striking a blow against censorship, or some other broad principle that the actual discussion participants may or may not actually be invested in. Once this happens the participants are no longer trying to listen or learn from each other, they're trying to mine their posts for things they can pick through to make them look bad or invalidate their participation. This has the effect of obliterating nuance and polarizing the participants. Discussions quickly devolve from people speaking candidly to people accusing each other of mischaracterizing what they've said. This makes people defensive, frustrated, and creates a feedback loop of negativity.

The win/lose battle approach permeates political discussion on Tildes (and elsewhere), which is a separate issue, but it gets especially problematic in these threads since the subject matter is intensely personal for many people. As a result, it's important to take care that pushback on specific positions should always endeavor to make people feel heard and accepted despite disagreement. On the flip side, there needs to be a principle of charity in place where one accepts that "no offense/harm intended" actually means no offense intended without dissecting the particulars of word-choice to uncover secret agendas. If a charitable interpretation is available, it isn't constructive to insist or default to the uncharitable one. It may not feel fair if you know that the more negative interpretation is correct, but it is literally impossible to have productive discussion any other way. If you can't imagine that a well informed, intelligent, and decent person might hold a certain view then the only conclusion you can draw is that they're either ignorant, stupid, or evil and every response you make to them is going to sound like you think this of them. That's not a position where minds are going to be changed from. English isn't necessarily a first language for everyone here and, even if it is, not everyone keeps up to date on the fast moving world of shifting norms and connotations in social media. What's more, not all cultures and places approach these issues with the same assumptions and biases you're familiar with.

Now I don't actually believe in appealing to peoples' sense of virtue to keep things going constructively in situations like this. Without very active moderation to reinforce it, it just never works and can't scale. So I think operationalizing these norms is going to take some kind of work. Right now we freeze out comments when they have a lot of back-and-forth, which I think is good. But maybe we should make it a bit more humanistic. What if we rate limited with a note to say "Hey this discussion seems to be pretty heated. Maybe reflect on your state of mind for a second and take a breather if you're upset."

Or, in long threads with lots of my bad indicators, the submit button can send to the post preview rather than immediately posting. It could then flash a banner to be a quick reminder of the ground rules (e.g. Try to assume good faith, Remember the Human, Listen to understand rather than respond, Careful with the snark, It's not about winning/losing, etc.) This would introduce just a touch of friction to the posting process, hopefully just enough to make people think "Maybe I could phrase that better" or "You know, this isn't worth my time" and disengage (Obligatory relevant XKCD)

Alternatively, maybe it is the case that this is honestly just intractable without some sort of third-party mediation mechanic and we freeze out comments under such topics entirely. Like I said before, I worry the frequency with which these discussions turn dispiriting has a chance of acculturating new users or signaling to prospective users that this is an expected way for this community to engage.

This is a long post, and I hope it does not itself turn into another case study in the issues I'm trying to raise. I want to open the floor to anyone who has other ideas about causes and solutions. I also ask that we try to keep any critiques to specific actions and behaviors without trying to put blame on any groups of people. We all contribute to the vibe one way or another so we can all stand to try a little harder on this front.

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?

Most California voters received their ballots this week, and as usual there are a bunch of propositions to vote on that we’ve barely heard of because nearly all election discussion is about national issues. So, what are you using to study up?

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

This topic is part of a series. It is meant to be a place for users to discuss creative projects they have been working on.

Projects can be personal, professional, physical, digital, or even just ideas.

If you have any creative projects that you have been working on or want to eventually work on, this is a place for discussing those.

I am stuck on Windows 10 for the time being, and I wish to make it function similarly to the arrangement I have on Linux, using xcape and xmodmap. This is what I need:

1. Caps sends Escape on tap and Control on hold
2. Tab sends Tab on tap and Alt/Meta on hold
3. Escape sends Caps (I rarely use this one).

I find this setup extremely comfortable. Is there a way to achieve this on Windows (that a layman like myself could do?).

What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.

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!