4
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 feeling an urge to write an emulator of some sort. Coming off Advent of Code 2020, I'm looking back to AoC2019 and remembering how much I liked the Intcode problems. Seems like just about everyone starts with Chip-8, so that might be a thing I try. After that, it seems like a lot of people try NES or GB, which is a pretty big step up, and then a large step up from there to the 16-bit consoles.
Anyone else given emulation a try?
I wrote a C64 emulator a while ago. It's a lot of fun and can fill as much time as you have. The older hardware is really well documented, so you can get cycle counts for each instruction and stuff like that. That isn't to say it's easy, just that you at least have the docs on how it should work. Depending on what you emulate you may have to learn a lot about useless and/or obscure standards like NTSC, PAL, and SECAM.