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?
Not sure if this is the most appropriate thread to ask.
Virtually no programming experience here. At most I've used PHP and MySQL in a school project many years ago. I have thought about creating a wiki to fill in a (kinda niche) gaming subject. Namely that I've gotten into a few competitive video games and have found very few resources on how to play them well. One such game where I tried to find a tier list for instance led me to loads of spammy malware-ridden blogs or lengthy 2 hour long livestreamer YouTube videos on a Google search.
I want to host the wiki myself and don't want to use a third-party site like Fandom. If I were to use something like Wiki.js, dokuwiki, Mediawiki or XWiki, what kind of programming or scripting languages would I need to be proficient in to manage the wiki and the website it's hosted on? And what would be the best resources to learn from?