This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

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?

This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate topic, but almost all should be posted in here.

This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!

I've always been enticed by 8 bit computer projects like this but I've never bought any because I can't think of anything I'd do with them given their self-contained nature. Even a really primitive ethernet controller would explode the project possibilities. Does anything like that exist?

What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.

This might be a weird framing but it's been bugging me for a few days. Many fields have a concept of classical training -- this is most common in music but applies in the humanities and many other areas. For example I do a lot of CAD work for my job, but I received what I would consider a "classical education" in design...I learned to draft by hand and physically model before I was ever allowed to work digitally. I got a lot of value out of this approach and it still informs the way I work today.

A lot of people view computers and technology as modern and almost anti-classical, but as the tech industry matures and the internet moves from something shiny and new to something foundational to our society, what will the new classicism look like?

Thanks for reading my question.

This type of game seems to be the new hotness right now, and there are now enough that I feel like they’ll need their own genre identifier.

Is there a broadly accepted one? If so, is it good?

And, if not, what do you think games of that type should be called?

I’ve see a few suggestions here and there, but none of them have felt right to me. I’m interested in almost theorycrafting the optimal genre identifier (in the vein of “procedural death labyrinth”). What are the unifying traits of games of these types, how do we best identify them without simply stringing together other genres (e.g. “reverse bullet hell idle action roguelike”), and what can we use that has “stickiness” as a term?