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.

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 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?

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!

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

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>

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!

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

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>

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?

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

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>