Define “major platforms” and “noteworthy” however you like, but I’m thinking of this as stuff you can’t find on Steam/Origin/GOG, etc.

I’m interested in people surfacing things like small itch.io projects or standalone downloads from the creator’s website or abandonware that’s never seen the light of day in digital distribution or cool romhacks — anything that’s worth a look but that someone would really have to go digging in order to find.

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!

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!

On and off throughout the years, I have attempted to make my online footprint as small as possible, taking steps such as:

• using pseudonyms on social media
• creating a new account every year or so
• overwriting old posts with a new message blanking out my original post
• "deleting" posts after a few days if the account has a higher probability to be tied to my real life

The last point, I put quotations around deleted because I understand that once I post something, it is not ever really deleted but it adds a barrier of entry to trying to dig into my personal life. Pushshift comes up because, try as I might, I seem to have difficulty getting accounts removed from their searches. Additionally, I think they allow you to download reddit data in bulk so even if I were able to get my name removed from the search results, the data could still exist on someone's hard drive, somewhere.

From your perspective, are services like Pushshift, that archive people's information without their explicit knowledge, ethical? On the one hand, I think of detestable content that users might post then delete later to avoid accountability. On the other hand, I think of people like me who want to keep their data footprint as small as possible because of the crazies who might utilize this information to do harm.

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!

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 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 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.

I want to share with all of you a gift I've been preparing. I love finding good gifts and seeing people's reactions when they get something that truly blows them away. But this is the one I'm most proud of yet.

First, some backstory! Early February 2021, something amazing happened in Belgium. The winter cold wave hit hard and all over the country, lakes froze.

In the middle of an intense and frustrating lockdown, after a 5 months lull during which all ice rinks were closed and travel was impossible, Belgian skaters all across the country put on their boots and went to skate outdoors on lakes.

On February 12th, that's exactly what I did with my (at the time) friend from the rink. I posted about it here before. We had a blast of a time; truly a day you don't forget, and it came at a time where both of us were seriously depressed.

Today, that friend and I have gotten very close and she has become my skating partner. Recently, she moved in to her new apartment close to the ice rink, and I needed a housewarming gift for her! I settled on a keyring. It's very on-brand for a housewarming gift, and I myself have skate boots keyring ornaments kinda like these which are pretty cool. But this is someone I really like, and I wanted to personalize it a bit.

I then thought about a skating figure ornament that could represent her. And what better than my absolute favourite photo of her from our day on the lakes?

So I got to work, and a friend helped me trace the initial silhouette as vector since my tracing skills suck. I did clean it up in Inkscape, and I now needed somebody who could turn this digital silhouette into a real physical artifact!

I found this shop on Etsy, but they did not respond in time when I asked them about cutting that figure for me. So I asked my ex girlfriend (who is doing a Ph.D in metallurgy, soldering and metal printing) for some advice. To my surprise and delight, she volunteered to do the laser cutting herself!

And so we got to work. I turned the SVG into a DXF (thanks Inkscape for being able to do that!), and she helped me clean up some of the edges. We calculated dimensions, stress spots, and added an attachment anchor. Here is the final contour for the cut, and here is the first trial sample!

So, after fixing a couple more minor issues, she gave me eight samples. We engraved her trouser's pink stripes into two of them; they're very representative of her skating attire.

One final issue to deal with was the burn marks. The back of the samples had very burnt edges due to the laser. Today, I found a jewelry workshop which was able to polish that away. I then added a small chain and a cute little snowflake ornament.

And so, here is the final result:

• Front: https://imgur.com/TqKLCzU
• Back (after polishing): https://imgur.com/7OdItjf

Full album: https://imgur.com/a/SW7Sqdm

She's currently sick and in quarantine. Once she recovers, we are having dinner at her house. I cannot wait to see her reaction :)

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!

Reclaiming a word means stripping it of it's negative baggage and giving it either a neutral or positive meaning. The most common example is the word Queer going from a slur to a descriptive term for non cis-het people.

My personal pick would be returning the term "incel" to it's original meaning of "involuntary/involuntarily celibate" or someone who wants a relationship but doesn't have one, because the word is currently associated with the few tens of thousands of extremists who occasionally commit terrorist attacks, consider the redistribution of women reasonable and created the black-pill, but the amount of men (and realistically also women) who would consider themselves as wanting a relationship but not having one is much higher than a hundred thousand violent extremists, and if they could all describe themselves as incels, I think that would help steer the conversation about wanting a partner and not having one away from the extremists and to the much more numerous pool of mostly young people, seemingly mostly men who just want a partner and can't have one and usually mostly just feel bad about it to varying intensities. It wouldn't completely detach the term from cringe online right tropes as a lot of the dudes who can be described as incels often tend to fuel the kind of "women aren't real"/"Girls don't exist on the internet" culture that makes complaining about dating so 'lame'. (As in, the default reply is "just do basic self-improvement it'll put you ahead of most people lol".)

Another term I would reclaim if I could is the Red-pill/Blue-pill dichotomy with becoming red-pilled either being a joke about some vaguely red pill used to transition or as a shorthand for adopting leftist beliefs, mainly because the creators of The Matrix were Trans women who intended the movie to have a strong Trans subtext, and red is usually a leftist color instead of a conservative one, so becoming red-pilled meaning becoming a leftist is more intuitive in most places.

From June through December 2012 I tried an Android smartphone. For reasons that I don't want to discuss nor argue about here, I ended up donating it.

Next winter (January 2023) I will start preliminary week long trips from the northeast US to the southeast US. Eventually, these January trips will be 2-3 months long (essentially, snowbirding)

I will be flying and renting a car for these trips. I may consider, at some point, driving with a pull behind tear drop camper (I hate driving long distances!).

I have an oldish Garmin that is still useful. However, because I will be traveling/visiting multiple people scattered around the southeast US, I believe it to be necessary to have a smartphone.

Also, I am an Apple fan. My family, almost exclusively, uses Apple products.

All of that being said, what would you recommend for a smartphone/GPS?

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.