(I'm tagging as ask.advice and ask.discussion because while my motivation to make this comes from my comments I'm not the only one who this could apply to and deleting coments is very much a general topic.)

So basically, I wrote this comment, noone agrees with it and the contrary takes all are upvoted, so should I delete it? If noone agreed with what I had to say and upvoted contrary answers, then what I said wasn't valuable to anyone, and so I should delete it, right?

This also applies to quite a few comments I have written that have 0 votes like this, this this and this.

In the other hand, measuring a comment's value by how many people voted on it isn't that great and leaving clarifications and tecnical/minor details and if someone replied, even if only to point out your comment as wrong or not so unlikely, so other than the third comment, you can argue they aren't entirely bad. (And leaving someone's answer without a question is pretty bad if someone comes later since they wouldn't know why that answer was there.) So where does one draw the line?

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?

Primarily non-US, as there's been a lot of discussion for various places in the States.

In my country (Croatia, EU), nobody knows anything, including the government, and the school year starts in three weeks. With the govt change this summer, and the new ministers enjoying their summer vacations, they only created a "task force" last week, which only met today for a few hours and concluded "there are challenges ahead". The minister in charge "thinks" schools will start normally, and "thinks" masks won't be required, with no straight answers or plans.

Teacher associations, individuals, parent groups have been calling for development of some kind of strategy for weeks (as a tourism-powered 2nd wave hit us), but there doesn't seem to be any sense of urgency on the part of govt.

This leaves parents (we'e gor one kid in primary school, other in kindergarten) in total fog, there's no way to prepare. Our family is better placed to handle this due to grandparents around to help and flexible schedule (self employed), but the online school from this spring was a disaster and I don't see a chance of the fall doing any better.

Even with preparations it would be hard, right now looks like it's going to be a disaster.

How is your country (not) coping with these challenges?

(edited to clarify the school year start)

I've been in a relationship with my current girlfriend for almost a year now, and things seem rough right now because of an issue we're having.

My girlfriend is upset with me because she thinks I don't care about her past trauma. She's told me, very roughly, what she's gone through, and I told her that whenever she's ready to talk about it, I absolutely will. But according to her, the last time she tried to initiate talking about it, I told her that I had no idea what to say. And this upset her and stonewalled the discussion.

I don't doubt that happened. My problem is, is that if she were to try again, I might just very well do the same thing. I have zero idea on how to handle something of this severity. How do I ask her to talk about it? Is that something I should be asking? What does someone even say when given this information? I am not equipped whatsoever to deal with information of this magnitude and I'm at a loss. How do I let her know that I really do care about her, and am 100% willing to listen to what she has to say? I worry I'm too far in the doghouse to even make use of any of this advice, but any help is immensely appreciated

Edit in case anyone was interested: We talked and we're okay :). She told me what she went through and I didn't handle it nearly as bad as I worried I was going to. Thanks everyone for your kind words and helpful advice.

There's plenty of stuff that's supposed to be creepy out there, but then there's stuff that really shouldn't be unsettling but, for whatever reason, has a really powerful effect. These are different for everyone, but I'd wager we almost all have them. They can be at the level of a classical "phobia" or something less pronounced but still puts you on edge.

What is an example of something that creeps you out more than it should, and why do you think it bothers you so much?

I'm working on an application that allows a user to view playlists belonging to a particular radio show and stream/download/favourite the tracks in them. It has 4 core entities: User, Show, Playlist and Track.

• Each show has multiple playlists (one-to-many)
• Each playlist has multiple tracks (one-to-many)

To be able to reference a playlist belonging to a particular show. I gave those playlists the same uuid as the show they belong to. A few questions though.

1. Is this the right/best way to associate data?
2. As a track could potentially belong to multiple playlists, I can't take the same approach as I do for (show/playlist) How would be best to handle this? Ideally I would like to have a single "Track" table containing all tracks for all playlists.

For any experienced database designers out there, how would you structure this data? What would you consider in designing the schema and why? If I did go with 4 tables only, presumably there would be performance implications given the potential amount of data in any one of those tables, particularly tracks. If that is the case, how best to structure this kind of thing with performance in mind? Thanks in advance for any help :)

For reference, in case it's of importance, I'm using sqlite3.

I haven't been able to get samfundssind out of my head since reading the article. It's the polar opposite of what you see in a lot of the US, and I wish that more people in this country weren't selfish assholes. It blows my mind that people are unwilling to make such small personal sacrifices, like wearing a mask, for the benefit of their neighbors.

On that note, what are some small, self-imposed inconveniences you put up with to improve the lives of others?

I'll start: if I'm pulling up to a red light in the right-most lane and there's a car behind me, I'll always move over to the left. There's a chance they want to make a right turn, and there's no need for them to wait behind me for the light to cycle.

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!

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!

I think on most sites this discussion isn't even worth having, knowing the type of people it would attract. But I have faith that Tildes can maintain civil discourse on this.

For those unfamiliar, for threads on r/BPT that receive an influx of racists and trolls the mods have implemented a sort of soft-lock where only verified users are allowed to post. However, the verification process strikes me as toeing the line of what should be acceptable in an online community. Essentially it breaks down to this:

1. Are you black? Give us proof of the color of your skin and you'll be verified and flaired with your race.
2. Are you a "non-white POC"? You can be verified but will receive no flair.
3. Are you white? Talk to the mods to receive further instructions...

I understand the rationale, but subtly race-gating threads feels icky no matter the reason.

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!

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.