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?

Putting aside specific criticisms of the GOP as it exists today, what do you think of using the debt ceiling as a tool to reel in spending and put the US on a sustainable path with its national debt? People make it out to seem backwards and manipulative, but this whole situation seems like we're driving a hundred miles an hour toward a cliff and the person saying we should slam the breaks is getting flack because it'll damage the car.

Stories involving dragons tend to be in medieval periods so maybe we can try to extrapolate forward in time a bit. Dragons could be from any mythologies or fictions of your fancy!

For my take, a dragon is a flying fire-breathing giant lizard with the size and toughness of a big building. I believe a critical factor is how tamable dragons are. If not at all, they'd go from something humans fear and run away from, then being hunted for glory and materials, then being protected in conservation areas to prevent going extinct. If they can be fully domesticated (like dogs), they could expedite for warfare, transportation and industrialized metalwork. The most interesting scenario imo is the in-between where they could only be partially trained. Maybe a skilled trainer can get them to behave 80% of the time but there's a low but significant chance that they get agitated and wreck havoc. How do we make use of them while ensuring safety and intervenability?

On the cultural side, we might not have as many myths and legends about dragons anymore. We might find the idea of giant flying fire creatures utterly mundane (phoenixes might be less interesting by relation even if they still don't exist in this universe). What would we mythologize about instead?

I know very little about Linux but have a good overall level of technical aptitude.

I have a device called an eDrumin 10 which uses an app to change the internal settings. https://www.audiofront.net/downloads.php I would like to use the control app from a tablet, but would prefer not to buy a ipad if I don't need to. Would it be possible to run the Linux version from an Android tablet?

I have an oral surgery coming up that's going to require me to be on a liquid diet for around two weeks (possibly more). Early on it'll have to be pretty strict -- nothing with even small bits of food or anything "gritty" like a smoothie. Later on I'll have a bit more leeway, but I will still have to keep to stuff that doesn't really require chewing until everything's fully healed.

I'm mostly looking for opinions on stuff like meal replacement shakes -- ideally ones that are tasty, satisfying, and without a lot of sugar (if anything like that even exists?).

I'm also interested in any tips/tricks people have if they've been through something similar. I'm hoping to make the best of the (hopefully no more than) two weeks that I can.

Meta note: this series has been restarted by request.

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

Tell us what it is, and why.

Previous posts in series

Additional Details