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?

Looking at the available options, I see many programs such as Ardour and Audacity that seems to focus on recording, mixing, streaming, etc. But what should use it to actually edit the thing?

By that I mean changing the order of things, removing silences, involuntary sounds, and noises, adding music and sound effects, as well as making what I'm saying more concise and intelligible.

I have a background in video editing, and I'm used to working in the "timeline paradigm" that is common to Adobe Premiere and older versions of Final Cut (I have no idea what Final Cut looks like now...). But I have no idea how to edit stuff using actual audio software, I've only used those to treat audio and then finish editing on other programs.

I'd use a video editor for that, but I currently don't own any machine powerful enough to use a video editor software comfortably.

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?

Asking for a friend. 😉

In all seriousness, the question was inspired by the news out of Google and specifically @Whom's comment here.

What should non-technical laypeople know about AI?

The info doesn't have to be limited to just this particular news item either. What information would you want included in an AI 101 rundown? What is it currently used for? What will it do in the future? What are its limitations? What are its potentials?

And, of course, how should people interpret stuff like today's big news item?

So I'm reading Asimov's short-story anthology The Complete Robot, which contains stories written between 1939 and 1977, and I'm fascinated by several instances in which Asimov tries to predict the future of robotics.

When he gets it right is just as interesting as when he gets it wrong, as even when he's wrong, he's wrong in very interesting ways.

For example, it's very interesting how Asimov seems to think that everything must have a positronic brain (which often produces something either identical or very close consciousness), when in reality we now have numerous useful robots that have nothing of the sort.

So this made me thinking, I think I'd like to write a story that was just like that, an exploration of universal themes that is facilitated by simplified technology. A form of retrofuturism. And since I had the idea, obviously someone else had it before. I wanna read it! More recent stories, especially those with old-school robots and artificial intelligence. Any suggestions?

Also open to other medias, but books would be particularly helpful.

Beyond the Infinite Two Minutes

Runtime: 70 minutes.

Budget: $27,000 USD.

Tomatometer: 98% - 8.3 / 10

IMDB Rating: 7.3 / 10 - 2k ratings

Language: Japanese with English subtitles

Streaming: Vudu (Free with Adds) & Amazon (free with Prime)

This is an engaging & novel sci fi, filmed in one location, a Japanese cafe, using what appears to be a single shot for all 70 minutes.

It has comedy, romance, violence, action, and an utterly novel sci fi concept. All in 70 minutes.

I haven’t watched as many films from this year as I would like. But here’s my current Top 5:

1. Top Gun: Maverick
2. Happening
3. Ambulance
4. The Bad Guys
5. The Black Phone

The ones that will most likely stay in my top 10 at the end of the year are 1-3. Most of my yearly favorite films come out at the end of the year as you can see by this list that only contains two movies released earlier in the year.

And really quickly I’ll give you my most anticipated films for the rest of the year:

1. Glass Onion: A Knives Out Story
2. Avatar: The Way of Water
3. Babylon
4. Amsterdam
5. The Fabelmans

This topic is part of a series. It is meant to be a place for users to discuss creative projects they have been working on.

Projects can be personal, professional, physical, digital, or even just ideas.

If you have any creative projects that you have been working on or want to eventually work on, this is a place for discussing those.

I'm considering making the switch to pipewire, as my current setup involving a bridge between JACK and PulseAudio is growing frustrating. Even on a fresh boot, Spotify won't play until Pulse has been killed and restarted, and the same goes for games through Steam. All the while, Firefox audio works perfectly without doing so, and I can jump straight into recording with reaper without any issues from the get-go.

I've been reading through the Arch wiki to get a feel for what the process should be like, and it seems like it'll be relatively straightforward, but given that I do a lot of music recording on my computer, I don't want to experience a total breakage of my sound setup. I'm planning to make a full backup of my system before making any changes, so I can roll it back if need be, but if anybody has any experience with switching to pipewire on a production system, I'd be grateful to hear about any pitfalls or problems that you ran into which I should be aware of in advance!

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 week. Did you accomplish any goals? Suffer a failure? 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!

What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.