5
votes
Fortnightly Programming Q&A Thread
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?
I’m thinking of working with some tools that could mess up my system, so I’m considering running them in a virtual machine. I see a wide variety of options and was wondering if anyone here has any experience running any of them on a Mac and doing development in them. I see Virtual Box, VMWare, Parallels, and Hyper-V. I’d be running the virtual machine on macOS and installing macOS on the virtual machine. I’m not real keen on installing anything from Oracle or Microsoft, but could maybe be convinced if they’re higher quality than the other options. I’m willing to pay a small amount ($0-300), but don’t want a subscription. Any suggestions? I’ve searched for articles about it and they all seem scammy or highly biased so I’m not sure how seriously to take them.
I have no Mac-specific suggestions, but Virtualbox is certainly the easiest virtualization tool I've used (n.b. I last touched any of them several years ago), and if it makes you feel better about its provenance, it was a Sun product (actually, they bought it, too), not an Oracle original; and it's GPLv2 free software (though of course, Oracle is a bad upstream), so you could e.g. use Homebrew's build rather than Oracle's.
MacOS guests are infamously janky, though, as Apple really doesn't want you to virtualize it. If you're willing to spend up to a few hundred dollars, you might have the best experience picking up a used Mac Mini (here's an eBay seller with a bunch of late 2014s which support Big Sur for $250) and snapshotting and working on that.