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.

I will shortly have need for a small, low power (power as in watts, not compute power) system for always-on Home Assistant use. However, Raspberry Pis are out of stock everywhere and while they can be had for extortionate prices on various auction/marketplace sites, I'm not sure I want to spend a load of money on something which might not even be what it claims to be.

Home Assistant suggest Odroid which I'd probably go for the C4 edition but it's relatively expensive (I need to add an MMC and a psu and various other things to the listed main board price)

Any suggestions? The Asus Tinkerboard looks overkill and is very expensive. It needs to be capable of running a standard Linux distro, ideally Home Assistant's own OS. Low power consumption is a definite, 2-3W at idle is probably the maximum I'd be happy with. Wifi is a bonus although not required right now - but the ability to add it if needed is essential. Some amount of expansion capability would be good if I want to add hardware sensors or bluetooth or a Zigbee transceiver or whatever. It needs some reasonably amount of compute grunt I assume but I don't think HA is all that hungry for number crunching power. The machine will more than likely be headless at first but a little bit of GPU and graphical IO would be handy if I want to stick a display on it in the future, which I might want to.

Any ideas? Oh, and also must be easily available in/to the UK.

This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.

I just watched an old movie on television: The Boy With Green Hair. It’s a boring afternoon, with nothing to do, and I thought this old 1948 movie would be a pleasant way to kill an hour or two.

I was wrong.

It moved me to tears.

It stars Dean Stockwell, whose name I recognised from ‘Battlestar Galactica’, as a child actor, which is one reason I decided to watch it. He gives a great performance. Doing a bit of research, it looks like he was dragged into acting by his performer parents. His Wikipedia page quotes him as saying he didn’t enjoy acting. Despite that, he was great in this movie.

It also has ‘Nature Boy’ as its theme song, which I know from ‘Moulin Rouge’.

The movie itself is a powerful anti-war message. The central character is Peter, a war orphan (the aforementioned Stockwell). After being placed with a number of different relatives, he ends up with a kindly old ex-Vaudeville performer he calls “Gramp” (who he’s not actually related to). Gramp’s a sweet old man, played very sympathetically by an actor called Pat O’Brien.

Peter doesn’t know he’s a war orphan. He thinks his parents are still on a trip. (A very long trip!) His school holds a charity drive to collect clothes for war orphans, and one of Peter’s classmates tells him, quite matter-of-factly, that Peter is a war orphan: their teacher said so. Peter rejects this, and they get into a fight. Gramp is there, and he confirms the news.

Later that evening, Gramp is reminiscing to Peter about his old flame Eileen, who loved having “a spot o’ green” around the place (a plant) to remind her of Spring and hope. To cheer Peter up, he promises him a surprise in the morning.

The next morning, after taking a bath, Peter’s hair has turned green. He assumes this is Gramp’s surprise, and it cheers him up. It’s not. Gramp knows nothing about it. In fact, the cause of the green hair is never revealed.

When Peter finds out the green hair is not from Gramp, he hates it and wants to get rid of it. However, they’re unable to figure out a cause, and Peter’s unwilling to “paint” his hair (dye it) or cut it off, so he’s stuck with it.

It’s hard to explain why this movie moved me, without giving away certain important plot points. If you don’t want too many spoilers, watch this trailer and stop reading now, until you’ve watched the movie for yourself.

If, like me, you’re not fussed about spoilers, read on. (Spoiler alert: spoilers make you enjoy stories more)

I have to say there were some plotholes in this movie. It’s far from perfect.

Reading the backstory, it’s based on a short story which doesn’t mention war: it’s originally an allegory for racism, which is reflected in one scene in the movie where Peter’s teacher takes a roll call of students by hair colour. The adaptations to make it an anti-war message were inserted by the director, which makes it a bit clunky and obvious.

And, supposedly, the progressive movie studio executive who signed off on the movie was replaced by a conservative executive during production, who tried to change it into a pro-war movie. The movie is therefore a bit patchy and disconnected at points.

But it has heart. The two central actors, playing Peter and Gramp, carry most of the movie. The actor playing the teacher is also sympathetic and warm.

It's not a great movie, but the central performances are strong and the messages are powerful.

Some sources I found tell of Stockwell talking back to the conservative executive when the executive lectured him in favour of war, so Stockwell supported the message of the movie, even as a 12-year-old boy.

This was just supposed to be an old movie to distract me for an hour and a half on a boring afternoon. Instead, it grabbed my attention for the whole 90 minutes, and moved me deeply. So deeply that I just had to share it with someone. I considered putting this in @kfwyre’s Tildes Pop-Up Movie Event thread, but the 1940s slot is already taken. Not that I’m upset by that. I’m very glad I watched this movie, for its own sake.

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!