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?

I just try to navigate the internet with as little "logging in" as possible. Youtube always had an age restriction that forced you to confirm your age by logging in but it could be bypassed when watching the video embedded on another site. I just tried for the Hitman 3 trailer on /r/games and it didn't let me. That's the first time this happened. Could it be just some adblock thingy? Or are they no longer letting you watch restricted content without logging in?

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.

In the past I used whatever Chrome extension I found, then moved on to youtube-DLG because Google Play store doesn't allow extensions that let you download off of Youtube. Now neither is working, on and off Youtube. I'd wager websites are trying to actively fight people downloading videos, even though (I assume) the data is likely identical to what we're viewing in the browser.

Basically the title. I'm not going to navel-gaze too much here because it's not that much of a complex problem.

Currently, as it stands, if a submission is older than x days (where x may be 3, but I'm not sure), new comments in that submission will no longer cause Tildes to bump the thread to the top of the list in activity view. Additionally, after 2 weeks, a note will be appended to the comment posting view indicating community standards around commenting on older threads.

The scenario I'm seeking to solve is where one submission covers an event of some duration longer than a few days—where Tildes users feel repeated or recurring submissions are not warranted. My example is this thread about a YouTube video series that was released in three parts, but all discussion has been placed in that submission, presumably because no one has felt that duplicating a post for each new part of the series is worthwhile.

Perhaps if a certain proportion of comments occur within a timeframe, after the submission has been aged out of the sliding window where new comments cause a bump in activity, a bump should still be allowed, but should require more than 1 comment to trigger said bump?

There's some fairly good discussion in that thread that feels wholesome enough that it could be exposed again to the wider Tildes community—because right now everyone interested in that thread is operating under the implicit assumption that to read and participate about this topic, they have to remember to go back to thread y.

Today's problem description: https://adventofcode.com/2020/day/8

Join the Tildes private leaderboard! You can do that on this page, by entering join code 730956-de85ce0c.

Please post your solutions in your own top-level comment. Here's a template you can copy-paste into your comment to format it nicely, with the code collapsed by default inside an expandable section with syntax highlighting (you can replace python with any of the "short names" listed in this page of supported languages):

<details>
<summary>Part 1</summary>

```python
Your code here.
```

</details>

For worldwide launch times, see:
https://pbs.twimg.com/media/EoVEcJCW8AIXqLR?format=jpg&name=large

7PM on the 9th for me. Can't wait!

Also, heads up, there is supposedly a 43GB day 1 patch coming, at least for consoles but possibly PC too.

p.s. If you try to launch the preload early on GOG. :P

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 weekend. Did you make any plans? Take a trip? Do nothing at all? Tell us about it!

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!