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?

The title question is more of an umbrella one, and I want to state from the get go that I am asking these questions non-judgmentally. I want this to be a space where people can feel safe to respond honestly.

I’ll also qualify that I’m not asking these impartially, as part of my reason for making this thread stems from some identified frictions in my own life that I’ve been mulling over. I don’t want to prime anyone’s answers, however, so instead I’ll just lay out what I’m interested in hearing about:

• Do you feel that you need to hide your gaming from others?
• Are you honest with others about the amount of time you spend playing games, the types of games you play, or the importance you ascribe to them?
• Do you feel that people judge your gaming habits or status as a gamer negatively?
• Do you identify yourself as being a part of a broader gaming culture?

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.

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?

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!

I know that "over" is a nebulous concept as it relates to COVID-19, but I'm using that more as a way of prompting long-term thinking rather than identifying any actual endpoint to the pandemic.

The question could also be phrased: what changes did COVID-19 bring about that you hope will stick around in the years to come?

I was wondering if anyone organizes their life in checklists, and if so, how people go about doing it. I'm interested in starting to try this, but haven't yet taken the time to do so and I'm curious what works for people.
My idea of this came off of CGP Grey's usage, which he often talked about in his podcast with Brady Haran, Hello Internet, but I'm a Windows/Android kind of person and would probably use a program such as Notion, which I'm using for notetaking and other tasks already, to do so.

What I'm mainly wondering is how you might structure checklists to a day of the week, and what to include/not include on there. What works for you if you've tried this before, and would you recommend it?

I find myself at a point in my life where I have the time, energy, and money to adopt a dog. Growing up I never had a dog - my parents only had cats. I don't totally know what I'm getting into so I'm looking for some advice.

I would like to have a moderately active dog, as I live a moderately active life. However, many donation sites list even just moderately active dogs as needing a yard. I live in a fairly spacious 1 bedroom apartment that's in a small complex (5 units) on the ground floor. Does this severely restrict the kind of dogs I should adopt? I know a hyper-active breed wouldn't be happy here. But should I consider myself limited to small, lower needs dogs?

Edit:

Probably important bit of information, I don't plan to get a puppy.

I don't need answers so much as an idea of where to start.

Essentially, I have a Google Sheet that uses importjson.gs to pull from the following APIs

• OMDB (IMDB)
• TheMovieDB
• TVMaze

I also use another script to scrape Letterboxd for ratings.

This works well, but sometimes it'll time out or I'll hit urlFetch limits that Google has in place.

Basically, I'd like to have a text file (input.txt) where I pop in a bunch of titles and year or IMDB IDs, then the script runs and pulls set endpoints from all of these, outputting everything on one line (a pipe as a delimiter.)

My thinking is that I can then pull that info a sheet and run all of the formatting, basic math, and whatever else so it suits my Sheet.

I have a feeling I'll be using requests for the JSON and beautifulsoup for letterboxd -- or maybe a module.

Can anyone point me in the right direction? I don't think it'll be too difficult and should work well for a first python project.