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?

See here for full details on the event.

Post Your Update

• How did your week go?
• What books did you get through?
• How did you feel about them?
• What's up next for you?

(Optional!) Focuses for Week 3

• Books with an aggregate review score of less than 4.0/80% on Goodreads, LibraryThing, or any other review aggregator
• Books that someone else recommended to you
• Non-fiction books

Let's burn through these backlogs!

What is this?

See here for full details on the event.

Post Your Update

• How did your week go?
• What games did you get through?
• How did you feel about them?
• What's up next for you?

(Optional!) Focuses for Week 3

• Games that have a score of less than 80 on any review aggregator
• Games that someone else recommended to you
• Games that are open-ended or story-less

Let's burn through these backlogs!

Hi all -- I have had a Moto G5+ for the last two years, and have been largely happy with it. However, it's recently developed some serious issues w/ charging -- it tends to not ever get past ~45%, and the battery indicator seems to be ... disconnected from how long the phone actually lasts. I have attempted cleaning out the charging port (there was a lot of caked-in dust), changing the charging cable and port, to no avail. It works ok-ish for the moment, but I have largely been limiting it to emergency usage and I suspect it's on it's way out.

So, I find myself in the market for a new phone. In the past I have typically gone with whatever the cheapest reasonable Android phone has been (hence, the G5+ which I really do like quite a bit besides the poor camera). I am not a heavy phone user, and I really don't care about having the latest and greatest, my priorities are:

• long battery life (my Moto G5 lasts two days fully charged)
• cheap (say 200-300$, the SE on this thread is probably the upper bound of what I'd want to spend)
• reasonably performant
• preferably reasonable privacy protections (probably a pipe-dream)

The Moto G series have checked all boxes (apart from privacy) in the past, but I am considering whether I can take this opportunity to rid myself of another Google device in my life. I was thinking potentially going for a refurbished iPhone, but I really have no idea what to be looking for there. I haven't used an Apple device since my iPod (iTunes on Windows PTSD is real, and I don't even want to think about Linux support), and I am more than a bit hesitant to tie myself into their ecosystem, but it's hard to deny their superiority from a privacy standpoint.

I had also considered a Librem 5 at one point, and would be willing to spend a bit more for something so privacy oriented. But the 6-month order window, and other things I read about Purisms' roll-out have left me a bit wary there.

Any thoughts?

Thanks!

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!

(Semi-throwaway account because of personal details)

This is prompted by /u/Adys comment to /u/Kuromantis.
I'm currently 14, and online I've refrained posting my age on my main account (on this site and others) to avoid it becoming a point in discussions (most prominently with politics, but any topic).

• How do/did you feel about posting your age on the internet (in regards to being younger)?
• Do/did you feel like your decision made an impact on discussions?

• What's something you wish people would take more seriously?
• Why do you think many people downplay, overlook, or deride it?
• What are the potential upsides or advantages to changing people's minds on this issue?
• Are there any potential downsides?
• What are the downsides caused by people failing to take it seriously?
• What do you think is the best way, if any, to get people to take this issue more seriously?

Answers for this question can be anything, and they don't have to be broad, something-that-affects-everyone things like the coronavirus or climate change. This can also be stuff that's specific to your field, societal norms, health habits, technology, entertainment -- whatever you think is relevant to the question.

Also, due to the nature of the question, please extend the principle of charity to people in this thread. People will likely be answering from a place of frustration. Keep that in mind when choosing how to respond to them!

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?