11
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?
Is there a generally accepted series of exercises to brush up on programming knowledge? I took CS classes in college and have been lightly scripting in my career since, but I’ve been much more focused on systems/aws admin type stuff. I’m looking for a new job now, and a lot of them want a bit more programming ability than I have, so I’m looking for a refresher. Thanks!
I have been recommended Leetcode in the past and my impression is that its somewhat generally accepted. I just made an account the other day because I would like to brush up for my eventual next job search.
check out exercism. I've been using it to gain some skill in a new (for me) programming language. It's great - they give you the problem, set up automated tests for you so you can harden your implementation, and they have a cross-platform cli tool that makes it easy to download and upload exercises. And reviewing the test code prepares you for test-driven development.
Besides the already mentioned ones, I found Advent of Code a good one as well, and it might be a bit more motivating.