What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

What is this?

First off, this is NOT an April Fool (I promise!). I know that many of us will be stuck at home for this month, I know that many of us could likely use something to pull our attention away from the news, and I know that many of us have accumulated quite the to-read list of books. As such, I'm thinking it could be fun for us to tackle those lists together and collectively clean up our clutter! Let's all burn through our backlogs!

The goal isn't necessarily to completely clear them, just to put a dent in them.

How does it work?

Your "backlog" is all those books you've been meaning to get around to read, but never have yet! For the purposes of this event, an item can be removed from your backlog in one of three ways:

• Finished: you completed the book

• Moved On: you tried it out, but it didn't hold your interest or wasn't for you

• Removed: you are choosing to remove this from your backlog without reading it, likely because it no longer interests you, but really for any reason at all

Use this thread to talk about your backlogs, plan for the month, and once you start reading, inform us of any backlog downsizing and their associated categories. Give us a list of the books you removed. Tell us why you moved on from what you were just reading. Gush about how a particular item held your interest long enough to see it through. The goal of this isn't to read every book you own; it's to explore what you already have in the way that's best, and most meaningful, for you. If you're not enjoying a book, dump it and move on!

If you're not sure what you might write, take a look at a previous backlog post for games to get an idea. Also if you want to keep track of statistics or anything else like that, go for it!

What's the timeline?

I will post an update thread weekly, each Wednesday, for the four weeks of April. At the end of the month, I think it would be neat to tally how many collective books we all removed from our backlogs, as well as what the best finds were from our collective digging into our libraries. I expect we'll turn up some good hidden gems, as well as interesting insights.

Each week, I'll also include some "focus" areas which can help narrow down choices for what to read. Those are just recommendations for fun, however. Read whatever you like, whenever you like, however you like! If it's in your backlog, then it's automatically a good choice!

Do I need to sign up?

You don't have to do anything to officially join or participate in the event other than post in these threads! Participate in whatever way works for you. Also, because this is ongoing, it is okay to make more than one top-level post if you're updating the thread with new information.

Focuses for Week 1:

• Books that have been on your to-read list for more than a year
• Books that have single-word titles
• Books that are less than 200 pages

Let's burn through these backlogs!

Meta Note: I am also running this same event for ~games as well. I am not active in the other media-focused communities on Tildes, but I encourage someone(s) to pick this up and run it concurrently for ~movies, ~tv, ~anime, and/or ~music (and any other places you think it might fit). I like the idea of it being sitewide, with people participating in their media format(s) of choice. Any runners for those groups have my full permission to steal this wholesale, tweak it for their target group, and post it there.

What is this?

First off, this is NOT an April Fool (I promise!). I know that many of us will be stuck at home for this month, I know that many of us could likely use something to pull our attention away from the news, and I know that many of us have accumulated quite the to-play list of games. As such, I'm thinking it could be fun for us to tackle those lists together and collectively clean up our clutter! Let's all burn through our backlogs!

The goal isn't necessarily to completely clear them, just to put a dent in them.

How does it work?

Your "backlog" is all those games you've been meaning to play or get around to, but never have yet! For the purposes of this event, an item can be removed from your backlog in one of three ways:

• Finished: you completed the game, or, for open-ended games, reached some level of "done" that you consider satisfactory

• Moved On: you tried it out, but it didn't hold your interest, got repetitive, wasn't for you, or had some other issue (like compatibility problems or glitches)

• Removed: you are choosing to remove this from your backlog without playing it, likely because it no longer interests you, but really for any reason at all.

Use this thread to talk about your backlogs, plan for the month, and once you start playing, inform us of any backlog downsizing and their associated categories. Give us a list of the games you removed. Tell us why you moved on from what you were just playing. Gush about how a particular item held your interest long enough to see it through. The goal of this isn't to beat every game you own; it's to explore what you already have in the way that's best, and most meaningful, for you. If you're not enjoying a game, dump it and move on!

If you're not sure what you might write, take a look at a previous backlog post to get an idea. Also if you want to keep track of statistics or anything else like that, go for it!

What's the timeline?

I will post an update thread weekly, each Wednesday, for the four weeks of April. At the end of the month, I think it would be neat to tally how many collective games we all removed from our backlogs, as well as what the best finds were from our collective digging into our libraries. I expect we'll turn up some good hidden gems, as well as interesting insights.

Each week, I'll also include some "focus" areas which can help narrow down choices for what to play. Those are just recommendations for fun, however. Play whatever you like, whenever you like, however you like! If it's in your backlog, then it's automatically a good choice!

Do I need to sign up?

You don't have to do anything to officially join or participate in the event other than post in these threads! Participate in whatever way works for you. Also, because this is ongoing, it is okay to make more than one top-level post if you're updating the thread with new information.

Focuses for Week 1:

• Games you've been meaning to play for more than a year
• Games you can mod
• "Evening-size" games

Let's burn through these backlogs!

Meta Note: I am also running this same event for ~books as well. I am not active in the other media-focused communities on Tildes, but I encourage someone(s) to pick this up and run it concurrently for ~movies, ~tv, ~anime, and/or ~music (and any other places you think it might fit). I like the idea of it being sitewide, with people participating in their media formats of choice. Any runners for those groups have my full permission to steal this wholesale, tweak it for their target group, and post it there.

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?

This thread is posted daily, 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 just finished binging The Habitat, the awesome podcast about NASA's simulated mission to Mars. And I'm feeling the urge to read something along those lines: fiction or true stories and indulge my fascination with space (and things coming from it) and how that relates to contemporary imagination.

Any suggestions?

This is mostly a test to see how well this will show up, but I'm experimenting with some text-based (I guess UTF-8) chord diagrams. If anyone plays guitar and/or has some feedback, feel free to chime in.

These are drop 2 chord voicings on the top 4 strings of a standard-tuned guitar. Arranged vertically, with each shape representing each chord piece. The gaps are for clarity, but each line ought to be successive and the patterns repeat themselves.

Edit: Well, it seems some of the symbols aren't rendered at a fixed-width. Though, they are in the font in my editor. Hm. I guess that's what I get for using symbols for an unintended purpose.

EditEdit: Oh, I see. Firefox is using three different fonts to render the symbols. SF Mono is my default monospace font, and it only renders the ◊ symbol. It falls back to Courier New for ○ and Segoe UI Symbol for the rest. Interesting.

▢ = Root
△ = Major 3rd
▽ = Minor 3rd
○ = Perfect 5th
◎ = Diminished 5th
◊ = Major 7th
◇ = Minor 7th
◈ = Diminished 7th

Major 7 
Drop 2 Voicings
Top 4

EADGBe
------

||||○▢
||◊△||

||▢|||
||||||
|||○◊△

||||▢|
||△|||
|||||○
|||◊||

||○▢△|
||||||
|||||◊

------

||||○▢
||◊△||

etc...




Dominant 7
Drop 2 Voicings
Top 4

EADGBe
------

||◇|○▢
|||△||

||▢|||
||||◇|
|||○|△

||||▢|
||△|||
|||◇|○
||||||

||○▢△|
|||||◇
||||||

------

||◇|○▢
|||△||

etc...




Minor 7
Drop 2 Voicings
Top 4

EADGBe
------

||◇▽○▢
||||||

||▢|||
||||◇▽
|||○||

||▽|▢|
||||||
|||◇|○

||||▽|
||○▢||
|||||◇
||||||

------

||◇▽○▢
||||||

etc...




Half-diminished 7
Drop 2 Voicings
Top 4

EADGBe
------

||||◎|
||◇▽|▢
||||||

||▢|||
|||◎◇▽
||||||

||▽|▢|
|||||◎
|||◇||

||◎|▽|
|||▢||
|||||◇

------

||||◎|
||◇△|▢
||||||

etc...

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?