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 do you guys do to really listen to music in a mindful manner?

I don't do streaming, but I have a really big collection of albums in digital format, but the way I listen to music is to just shuffle everything and listen while doing other things.

I was contemplating entering the vinyl hobby, but living in Brazil this gets extremely expensive just to start. This would allow me to bring back the "ritualistic" aspect of listening to music and have good equipment to focus on what's being played.

I guess I could just force myself to not pirate music and buy an album a month on bandcamp. That would at least assure that I have good quality flac files instead of trusting random people on soulseek, but in the end it would probably end up in the shuffle pile.

Do you guys do something to try to be mindful of the music you are listening?

The new Forza Motorsport has released to the masses as of today, and has been available to those who paid extra for premium upgrades and the like for about a week. I got it via Xbox Gamepass and played about an hour of it this morning, and so far it feels like a nice return to form for the series, which hasn't seen a new non-Horizon edition since Forza Motorsport 7 in 2017.

That game had some baggage with the card system/gambling mechanics, and I'm glad to see none of that thus far in the new Forza Motorsport - which, you may have noticed, has dropped the number. There's a feeling that Microsoft/Turn 10 may be aiming to make this something of a long-term platform play rather than just another game in the series.

I'm enjoying it so far, and after playing Forza Horizon 4 and 5 a lot since FM7 came out, I'm glad to have the return to more traditional circuit racing, and absolutely do not miss the supremely annoying voiced characters from those games.

The thing I most immediately noticed upon playing the game (besides the graphics, which are a real showcase for the Xbox Series X or a sufficiently beefy PC) is the new upgrade/tuning system, which requires you to actually spend time driving a specific car in order to unlock the various upgrade parts for it. You earn car points for doing things like clean racing and fast lap times, which you can then spend on upgrade parts between races. The game keeps calling those CP, which makes me think that nobody at Turn 10 has spent any time on the internet. An unfortunate acronym...

I'm curious to know what everyone's opinion on this game is. I know a lot of the audience is turned off by the more sim-like/boring nature of the Forza Motorsport games versus the arcade fantasy for the Horizon games, but I'm very much on the FM side of that divide.

I'm looking for a desktop monitor for mixed usage (work, gaming, etc.):

• MiniLED
• 4k
• 144Hz
• 27"
• Built-in KVM switch

There are 2 well-rated monitors that fit this criteria:

• Cooler Master GP27U
• INNOCN 27M2V

I'm in a bit of an analysis paralysis between these monitors. It's very hard to gauge anything without buying both and comparing in-person (I might actually do this).

Going by the numbers alone, the 27M2V has x2 dimming zones making it "better". This monitor received a lot of praise for picture quality. Not so much for the rest (e.g. build quality, support, etc.). But I'm willing to sacrifice some of the picture quality, unless it's very noticeable, if it means better build quality and support from the manufacturer.

I hear blooming occurs (even with the x2 dimming zones) during normal usage. Which is fine because, as I understand it, this feature makes sense when you're consuming media (movies, games, etc.). Not so much for everyday tasks. I don't really care about the blacks when developing or browsing the web. I haven't seen anyone do a comparison without going into graphs, charts, and checkerboards. Lab tests and numbers are one thing, but are the differences drastically noticeable to the eye when compared side-by-side?

I currently have an LG 27GL850-B which has been going strong for ~2 years. I'm sure either choice will be a significant improvement, but I'd like to know if anyone here has any first-hand experience with either monitor before I make the jump.

Cities: Skylines II is an upcoming city-building game developed by Colossal Order and published by Paradox Interactive. It is a sequel to Cities: Skylines, and expands upon many of the simulation factors such as simulated city and population sizes, and improved traffic AI and management schemes. The game is scheduled for release on 24 October 2023 for PlayStation 5, Windows, and Xbox Series X/S.

Source: Wikipedia

As we near the release date of Cities: Skylines II, more and more media and articles both substantial and fluff-esque are going to be popping up everywhere. Inspired by the release of Two Dollars Twenty's YouTube gameplay video (linked below), this thread is a repository for any morsel of news regarding the much anticipated city-building sequel. Utilise the tags to see previously posted content on Tildes.

I opened up the Google Earth app on my phone wanting to browse random beautiful and interesting places, but it doesn't seem to have a good way to do it. (Maybe this is a limitation on the mobile app, and the desktop app is better?)

For example, if I try searching for "wetlands", it only shows me a list of maybe 10 places near my current location.

I tried searching the web too, but I mostly get "listicles" like "10 amazing places on Google Earth" but they're practically unreadable with the webpage being covered with ads.

I found Earth View Gallery https://blog.google/products/earth/most-stunning-images-from-google-earth/ and it's nice but it's just a gallery of images with no contextual information (at least when viewing on mobile). It shows me beautiful pictures but no information about where the picture is from... I would have expected it to link to the spot on Google Earth.

Anyway if you happen to have some recommended places for me to check out on Google Earth I'd love to see them! I like:

• wetland-type habitats like marshes, pond systems, mangrove swamps
• beautiful natural scenery in general
• abandoned and/or ancient architecture

But open to any interesting recommendations in general.

Edit: It does seem to be slightly better on desktop. Searching on Google Earth works better, and Earth View Gallery does link to the location on Google Earth. I wish Google Earth had like, a built-in community feature for me to check out other people's public projects.

I have a Pixel 4a which has just reached end of support for Android. However, I love this phone and the only hardware issue is that the battery doesn't last me scrolling social media all day, so I am not looking to upgrade to a newer handheld just yet.

I've been looking into Graphene OS and Lineage OS as perhaps alternatives I should consider, at least just so I can keep getting security updates. However, looking through GOS, they say that their 4a build is an "extended support" build different from the main OS which is described as a "stopgap" before upgrading phones. LOS says it's supported but through an automatically generated page which doesn't leave me with much confidence about the attention and stability of the build on my particular phone.

I'm asking y'all's opinion on whether I should even bother. Security upgrades are important, but my phone is a secondary device at best, one which I always use with the same apps and websites and honestly not really that much of a security risk. Watch hubris get me.

It was an interesting race with tire strategy, given that Pirelli and the FIA imposed an 18-lap max on all tires, even used one, for safety reasons.

F1 heads to the US in two weeks for COTA (Oct 20-22). Hopefully the drivers and teams get a bit of a break from such a grueling race. See you all there!

Choose one series
that you love
that you think deserves more love

Tell us what it is, and why.

Welcome to the inaugural MangaLove post. Passively being exposed to new manga and anime is one of the things I've missed most about Reddit, so this is an effort to bring some of that spirit to Tildes.

Many thanks to @kfwyre and their AlbumLove series in ~music that I plagiarized was inspired by.

Additional Details

October 1st has already hit in some parts of the world, so Timasomo has officially begun!

Posting in this thread is your official entry into Timasomo. Let everyone know what your actual plans are: what are you going to make?

Once the date turns over to October 1st wherever you are in the world, feel free to start creating!

FAQs

Hey guys,

I am kind of out of touch with the Anime scene these days, and as the title says... What should I watch on Crunchyroll?

All genres are a go, I will try anything, but I do tend to prefer your classic fantasy/sci-fi esque action types. I watched Claymore a few years ago and loved it, Hellsing, Tri-gun, Cowboy Bebop, etc.. So just drop some good recommendations if you don't mind.

Edit: Thank you to everyone posting suggestions! It is appreciated.