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?

Any answer in any scope is fair game: can be something very minor or something quite significant. It can be very domain-specific or very general.

Also the goal of the thread isn’t to judge people for their mistakes but more just highlight some common errors in hopes of bringing more awareness to them.

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?

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!

I've noticed some people making a point of editing titles on articles to either impose or undo title case on articles. I dug around a bit and haven't been able to find any style guide suggestions on the matter.

Barring some kind of official stylistic standards being laid down, that I'd like to respectfully request that curator roles refrain from overruling a submitter's formatting choices without good reason.

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 week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

I'm in the market for a house, been looking pretty seriously for the past week or so. I've got two pre-approvals for mortgages, and I think I'll probably look for at least two more for fee comparison purposes. I have yet to actually see a house unfortunately, since every house we try to view gets sold that very same day :/ Hopefully the streak is broken, since we have an appointment with another house today!

Anyway, who here has advice for (any part of the process of) buying a house? Things to look for when viewing a house, things to consider that the common person might not, tips for making offers, tips for not giving up because of the market, etc.

I'll lead with some tidbits that I've gained from asking around friends and family that have already bought places recently.

1. Apparently, sending a personal letter to the owners with the offer letter has gotten multiple people a house even when their offer wasn't the highest. For example, my sisters friend knew the owners had a cat, and has cats herself. So in the letter she wrote, she mentioned how happy her cats would be laying on the windows and running around in all the new space and such.... and she got it! The owners realtor was kinda pissed.

2. Try to find out the reason the owners are moving out. My sister and her husbands realtor asked around, and they were able to close on their house because the owner needed a quick turnaround to get out as fast as possible. They got the house for 60K under asking price because they were able to sweeten the deal to suit the owner.

3. Location is (generally) more important than furnishings. You can add or remove things from a house, but you can't move it once you buy it.

4. Once you make an offer on a house and the owner accepts, make sure the contract includes the following two parts that are (apparently) very important:

   • House must appraise for at least the same value you've agreed to buy it at
   • Inspection must show no more than $buyer_defined_value dollars of necessary repairs, otherwise the deal should be re-negotiated or considered void.

5. Always leave enough money in your savings account to pay for any extras (because there are always extras) after the house is yours. New furniture, carpets, smaller repairs, paint, etc. You don't want to drain your account for the house only to find out you can't do anything afterwards.

I'm very excited (and exhausted already), but I want to make sure I'm as thorough as possible since I'll be spending the next several years of my life in it!

Forgot to mention(Thanks @Thra11), this is the US East Coast.

OK, so this is kind of a weird question, but has anyone here ordered a USB cable recently, and if so, how long did it take to arrive? I ordered a 3 meter USB A male to USB A male cable on June 27th from NewEgg, who have been fairly reliable in the past. I got an email later that day or the next saying the shipping label had been printed. So I thought, OK, it will go out in the next day or two. It still hasn’t shipped. After about 2 weeks of waiting, I ordered another one from B&H Photo. It also hasn’t arrived yet. I know there is a global chip shortage. Would that affect cabling too? It just seems odd that it’s taking so long to get a single USB cable. Anyone else experience this or am I just unlucky this month?

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!