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!

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?

Recently I got for free an old Zeiss Super Ikonta 531/2, it's a medium format foldable camera from 1936. It was in decent shape but the lens was very foggy. Fungi can grow on lenses but I think it was just general dirt. Opening it was a bit tricky (I had to get watching-making tools, because the screws are very tiny) but I managed to clean the lenses quite well. I shot a first roll but the focus was off, so I had to make sure the front lens element was at the right distance, using some semi-transparent tape on the back of the camera to see the image.

Then I shot a second roll and developed it myself, which was also a first (it's not super hard though), I had no idea if the images would come out good, or even at all (wasn't even sure I loaded the developing tank correctly). Seeing the images come out of the tank for the first time is quite magical, and they came out great (some of them at least...) :

https://imgur.com/a/bF817x9

Even with my crappy development & scanning I can get high-res images that compete with my expensive digital camera. The lens (Tessar 105mm, f3.8) is quite sharp wide open (statue shot) and I even took a long exposure shot at night using a release cable. The process is very slow and focusing is hard, but it's quite fun and rewarding. These kind of cameras are very cheap but the rest (film, accessories, development, repairs, ...) not so much.

Inspired by posts I've seen elsewhere, what small purchase have you made that has vastly improved your life?

For me, one example would be this Gerber Folding Utility Knife. It's great for opening boxes. I've had several pocket knives over the years, but this one has replaced them. When the blade gets dull or gunky from opening packages I just replace it.

Use this thread to post about the games that you play!

Also, a quick note about thread etiquette: It is fine to make multiple top-level posts throughout the week if you play multiple games. It is also fine to respond to yourself with updates if you're continuing a single game and want to talk more about it as you go!

Previous threads:

Announcement
Beginning

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.

Alright, so I fell down a rabbit hole of trying to understand a whole bunch of techy things that I don't fully understand and could use some help:

What I'm looking for: a pair of Bluetooth wireless earbuds that I can pair with my computer, with low enough latency that it won't impair my enjoyment in casual gaming/video watching

What I understand so far: Almost nothing. 😔 I get that Bluetooth will always have some level of latency, but, beyond that, I've got nothing. I'm so confused.

There are lots of different versions of Bluetooth, and then there are different Bluetooth protocols within that, and then different audio codecs, and each piece of hardware seems to support completely different combinations of those, and I'm not sure if the devices have to match configurations or even how to figure out what my computer supports? It seems Bluetooth will gracefully fall back to worse codecs/protocols if better ones are incompatible, but I don't really want to buy something that's just going to fall back to its worst usecase.

I also don't know what's an "acceptable" level of latency. What's reasonable versus what's intolerable?

It also seems like the information I read online is subject to rapid decay. I read a bunch of stuff only a few years old saying I should look for aptX Low Latency capability, but then I read very recent posts saying that's dead and to go with aptX Adaptive instead. Meanwhile there are a handful of gaming-focused headsets that say they're low latency but don't really say how (e.g. Razer's Hammerhead). And some, like Samsung's buds, having a "gaming mode" but it only works on special hardware.

Also, how do I know what my computer itself will support? Is there anything I can do from the computer side to reduce latency, or is that strictly a function of what my hardware supports and which earbuds I buy?

My usecase:

My computer is a System 76 Oryx Pro (5) running Pop!_OS 21.10. I think its Bluetooth adapter is version 5.1 (though I'm not confident on that). I do not know which protocols/codecs it supports, nor how to find that out.

Audio quality isn't too important. These will be for everyday video-watching and gaming, which is what's prompting the latency requirement. I'd rather them be responsive than rich.

Active noise cancelling would be nice to have (especially if it has a toggleable transparency mode), but I don't know if ANC adds latency and is therefore incompatible with what I'm wanting.

I don't have a specific budget for it, and that's honestly the least important requirement. If the solution exists I'm fine paying for it (within reason, of course). These will end up getting used for thousands of hours, so even a big price difference upfront will even out over time.

I'd appreciate any help anyone can offer in pointing me in the right direction on this!

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!