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?

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.

Today's problem description: https://adventofcode.com/2021/day/7

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>

Timasomo is Tildes' Make Something Month: a creative community challenge that takes place in the month of November, where participants from our community self-select creative goals to achieve.

Timasomo 2021 is now officially complete! Participants will be posting their creations and efforts in this thread as a showcase! Comments and feedback from the wider community are both welcome and encouraged! Let these creators know what an awesome job they've done!

Creators: In posting your showcase:

• Give your project a title, and use the # markdown to make it stand out in the showcase thread!
• Link to your project in whatever way works best for your project.
• Give a "creator statement" that contextualizes what your project is.
• Add anything else you consider relevant! The showcase is yours!

Community:

• Treat this thread like a walk through an art gallery or a museum where you get to see different works on display.
• Comments do NOT have to be in-depth -- it is okay to just affirm that you like/love/appreciate something! (In other threads these might be considered noise, but here they are directly validating the sustained creative efforts of another community member!).
• Make sure any feedback you give is constructive.

Hello everyone,

I'm currently living in Germany and in these few years I've discovered by chance a small but super sharp fruit knife from Solingen (I think the brand was from Rör). I was so amazed by the sharpness that now I want to buy a chef's knife for myself (budget: up to 60 or 70) and a knife for my dad (budget: up to 30 or 40) as a Christmas gift.

I've already searched the web for great German knife brands, and it seems these are the ones:

• Wüsthof
• Burgvogel (a.k.a. in the US as Messermeister)
• Friedr. Dick
• Herder Windmühlen
• Hohenmoorer

If someone is looking into this post looking for a budget (but still good) German knife brand, it seems that Rör is that brand.

But since, I’m looking for advice with this post, I’m no expert on the topic, if there are bad knife makers on this list or great knife makers missing, please tell me, and I'll remove/add them from/to my post. :)

The knives list below are all that fit the budget I've mentioned. Hohenmoorer and Windmühlen (and this brand only has wooden handles, which I don't like), are just too expensive, so only Friedr. Dick and Wüsthof are left inside my budget, but I could include two more expensive ones from Burgvogel and Friedr. Dick, if it is really, really worth it.

For myself:

• Friedr. Dick

  1. ActiveCut 21 cm
  2. Premier Plus 21 cm

• Wüsthof

  1. Gourmet 20 cm

• Bonus (around €80, if they are really worth the extra effort):

  1. Burgvogel: Master Line 20 cm
  2. Friedr. Dick: 1905 21 cm

For my Dad:

• Friedr. Dick

  1. ProDynamic 21 cm
  2. Superior 21 cm

• Wüsthof

  1. Silverpoint 20 cm

Last questions:

1. Would you recommend a 20, 21 or a 23 cm blade size? Some knives have different variations of these blade sizes.
2. Should I care about the material of the knife? I saw someone saying that it should be made of carbon steel (I think?).
3. Should I already buy a knife sharpener from one of the brands above?
4. Should I buy one of those knife guard/protector/sleeve to store it on a drawer or something like that?

That is all, and I want to say thank you in advance for all the replies 🙂

EDIT: I already bought a knife! Thank you so much for all the help! I've bought the Burgvogel Comfort Line 21 cm, I got a nice discount and bought for €58! I don't know how did I miss it but, Burgvogel has the Comfort Line and Series 4000 which are cheaper and also nice quality, just in case, someone in the future wants more options when looking into a new knife. :) My Dad will have a ProDynamic after reading good things about the quality of the cheaper F. Dick knife series.

This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

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!

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

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>

I am considering the purchase of a Garmin GPS watch, but I don't want to run the bloated Garmin Connect app on my phone. Really all I want, is the ability to pull coordinates from my watch (.gpx files) and put them on my phone or computer. Does a privacy-respecting app like this exist?

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

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>