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.

Hey all, I'm transitioning from a plain old software engineer at my company to tech lead (first in responsibility, then eventually in title)!

I'm very excited about the opportunity, but the role is new, both for my company and personally. Would anyone have recommended reading I could peruse? I'd love to get a solid footing for what I should be doing as a tech lead, and how I can do it well!

This topic is part of a series. It is meant to be a place for users to discuss creative projects they have been working on.

Projects can be personal, professional, physical, digital, or even just ideas.

If you have any creative projects that you have been working on or want to eventually work on, this is a place for discussing those.

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!

So I wanna purchase a domain for my personal website (just a WordPress thing), and I wanna pay for three years in advance (I have my reasons). Which domain sellers are reasonably priced, trustworthy, and more likely to assist a less technical, non-developer user like myself?

Thanks!

I've been thinking of writing a follow-up to my post about my now on only mostly lifelong depression. And surprise, this is that post. :) Its mostly stream of consciousness style, but I did try and edit it a bit.

I've realized that I have never had a friend before. I've cared about people, but the trust required to consider someone a friend was something I wasn't capable of. I only realized a few months back that trust is an emotion; it was always a rather cold calculus for me. I would think something to the effect of 'While I trust them not to kill me or physically hurt me...'. I would think a similar thing about best friends, 'Well they are literally my best(think closest) friend'. People have cared for me, but since I couldn't reciprocate, I can't call that a friendship.

It does explain a lot of things that didn't make sense to me before. Everyone I knew always acted like I hated being around them, and in a sense, they were right. I hated being around people because I couldn't actually connect with them. It was like watching people feast while you are starving. I had to impotently attempt to form connections that were impossible for me, while the other person blissfully formed that connection without even thinking about it.
I still have issues trusting people, but I have gotten massively better in this regard. There are a few people I consider casual friends now, but I cannot say I have a close friend.

I also have a fair bit of anger towards people who called themselves my friends. I cannot remember a point when I felt like any of them seriously tried to help me. And its not like I didn't have people who stated they loved me, I've had a few, but that I never felt that love breathed into actions. I imagine I will always wonder if it was just because it was too hidden or if no one ever really tried. I have also realized that I don't think anyone ever realized how bad off I was. To be fair, I couldn't have told you how bad off I was then either, but I have the excuse of not knowing what happiness was.

I've also realized how little people who have not experienced something like lifelong depression understand about it. I've discussed it with a few people, and even the one's who have been depressed and who have had serious issues, do not understand. In particular, a lot of people will use the phrase 'Making up for lost time' and do not understand how incorrect it is. There is no making up for the lost time; I will have always lived roughly a third of my life devoid of happiness and meaning. Nothing will change that, and nothing could ever remove the weight of that burden. Even if I live my best possible life from now own, it won't make my past self happy. Also of course I want to live my best possible life, but that's probably the most universal desire in existence. And my point isn't to insult the people who use this phrase, but to offer a particular example of what I mean by not understanding.

This type of comment also implies suffering from being in a bad situation, not suffering from being in a void. (Though I imagine the vast majority of people do not understand the difference) What most people call suffering is being in the dark, a metaphorical, or sometimes literal, punch to the face; something clearly delineated and demarcated. Some moment of shadow within a wider context of light; even if the shadow greatly outweighs the light, there is still both light and shadow. The suffering of the void is a separation from even the dimension of light/dark itself. And it is a hungry void, it consumes everything and turns it into the Same. Even people who have experienced the suffering of being in a void for a time have memories of light/dark as a reminder of what they are looking for. I do want to be explicit here, I don't think suffering is useful or valuable. Suffering doesn't make you strong or interesting, it just fucking sucks. Nothing pisses me off more then when people dick measure with how bad their life has been. I do kinda feel like an angsty teen talking about this, but it is something I have feel so ¯\_(ツ)_/¯

I have also been steadily seeing how fucked up some things in my past were. For example, as a 7 year-old I had to learn how to careful couch all my words to avoid pushing my mother to suicide. I realized that not feeling physically safe anywhere is a problem.

I got a job working at a local restaurant. Its a mediocre job, but I wanted a zero-stress job and it provided that. I have a few coworkers I consider friends, but the one I am closest to just left which is a bummer. I do also feel like I am down with this period of my life, and I just want to move on right now but I still need to wait a bit.

I am moving to Portland, OR in February. Its definitely the next step I need to take, but its obviously still scary.

I have been working on some coding side-projects that I have enjoyed. One is a weather alert that only sends me alerts if X condition is met, so if the temperature drops 20 degrees or a blizzard is coming type of thing. I have the core logic working, but I am still working on the notification method. I am also working on a stenography theory that attempts to use semantic relationships instead of phonetics as the base dimension. Its still really, really early, but its in that fun, highly theoretical stage.

I have realized that I am not actually ugly, but you know a little too overwhelmed to recognize normal people's interest. I was also surprised how enjoyable it is to wear clothes that look good on you. Unfortunately, there is no one I am particularly interested in right now, but at least I would be able to act if I met someone. I also still have no idea how to date; like do you just approach someone and ask them? Is that it?

This post is much longer then I was originally thinking, so if you read through to the end, thanks.

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their weekend. Did you make any plans? Take a trip? Do nothing at all? Tell us about it!

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?

Have you watched any TV shows recently you want to discuss? Any shows you want to recommend or are hyped about? Feel free to discuss anything here.

Please just try to provide fair warning of spoilers if you can.