How and where do you like to read? Tell me all about your reading environment(s), both real and idealized. Do you sit in an arm chair with a cup of coffee and a worn paperback? Lie in bed with a cat curled up next to you in the dim glow of your ereader? Under a tree in the woods, listening to the book on your headphones? If you could find/build the perfect reading space for you, what would it look like?

And then, what about your more practical reading: on your phone on your lunch break? While waiting for your kids in the car during soccer practice? Tell me about the times you fit reading in even if it's not necessarily the full focus of the moment, or the times where you settle for a comfortable but less than ideal setup.

Include any meaningful rituals or accessories too. Do you like to put a good album on the record player to accompany you? Do you have a special bookmark that you use? Do you share your book covers on social media or livetweet each chapter? Does your favorite lamp like to look over your shoulder as you turn the pages?

Basically, tell me all about what reading looks like for you -- with enough detail so we can picture it!

My husband's birthday is coming up and I want to get him a smartwatch that syncs with his Pixel. I was gifted an Apple 3 watch which I like a lot and would like to find something with the same sort of functionality for android. I tried going through watch reviews but ended up with buyers paralysis because there's so many to choose from. What would you recommend and why?

Edit: Fitness is not the key use I'm looking for.

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?

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?

Hey folks,

I hate Twitter with a passion and find it very hard to follow discussions because they are so terribly displayed in the official App/Website. Unfortunately I have to use it for job reasons and therefore I am looking for less headaches.

Is there an app which can show me Twitter content and discussion tree views like Reddit does?

I am totally willing to pay.

Thanks in advance for your thoughts.

So a few weeks back someone posted an article here about Super Recognizers. These are people that can instantly remember 80% of a persons face and can identify that face easily later on. It talked about how these people are getting hired by police departments across the world.

It caught my attention because my wife has always been freakishly good at facial recognition and recall. Well, she took the test, which led to another test, and today she received her official invitation to join Super Recognizers International!

This is a big deal because her company is about to go under and she has been considering leaving lately. This will open up doors for her to find work she can do from home on a flexible schedule. Thanks @skybrain for posting that article and thank you to the Tildes community for being here!

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!

Have you watched any TV shows recently you want to discuss? Any shows you want to recommend or are hyped about? Feel free to discuss anything here.

Please just try to provide fair warning of spoilers if you can.

Sometimes I get into a back-and-forth... heated interaction with someone, and it goes on for a while, and then they stop responding. Afterwords, I might wonder if it was worthwhile. Maybe they got tired of arguing with me, or maybe they just thought the conversation reached its natural endpoint? Rarely, the conversation might end with us explicitly agreeing it was a good discussion, but that's kind of formal and not the usual case online.

Just stopping is my habit as well. If I don't want to talk anymore, I upvote the last comment (if I thought it was good) but don't reply.

In the case of repeated interactions like this with the same person, sometimes I wonder if I'm annoying them by replying to their comments too much, particularly if we disagree often. I've never been explicitly told to go away, but people are often reluctant to say things like that, for good reason since you never know how people will react.

It seems to me that upvotes don't tell me this. Upvotes tell you whether your comments make sense to the crowd. They don't tell you whether the person you're talking to liked your reply. Which seems like it would be good to know. It would be valuable feedback if the goal is to be a better conversationalist. That seems like a good goal to aim for?

I guess we could get in the habit of saying "good point" and all that, and sometimes things can be inferred from what people say if you're good at taking hints, but not all of us are. But we are all trained to upvote things we like already, and it seems like it would be nice to take advantage of that.

To the extent that people like to gather internet points, I wonder what sort of conversation would be encouraged if you got them by writing a good reply from the perspective of the person being replied to? But I guess it could be gamed pretty easily if two people cooperate, so we probably shouldn't keep a total.

Also, think about how this looks from the outside: if you are reading a conversation by two other people in a heated back-and-forth, how do you know whether they're having a good time or not? Maybe it seems obvious, but in some cases a heated discussion might look worse to outsiders than participants. If you could see that they liked each other's comments then it would seem friendlier.

Note that Facebook does tell you who upvoted a comment, but since it tells you everyone who upvoted it, it's even more information, maybe too much.

(This is a followup to @NaraVara's previous topic, focusing on a particular aspect of it.)

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?