I thought I could get away from "what [general topic or icebreaker that 99.9% of people have an opinion on]?" questions by filtering out ask.survey, but that seems not to be the case. There are still quite a few that are being considered just "Ask" questions, and not "surveys". Are these not being categorized very strictly, or is my notion of an ask.survey question mismatching that of the moderators of Tildes? Or is the ask/ask.survey distinction up to the poster, and not moderators?

I come to Tildes for articles on specific subjects, not ocean-wide-open questions that generate maximum participation froth. I might have to start filtering out ask as well (as ask.survey), but I'd rather not have to do that. If people ask "what [specific problem or specific topic]" questions, I'd be interested to read 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?

I have two that I will highly recommend:

Vimium has completely changed the way that I use my browsers. They have extensions for firefox and safari as well, but the link I provided is for chrome. If you are used to vim keybindings, it makes websites almost completely navigable using only your keyboard! Here's a video demonstration of it in case you're interested.

My other is SponsorBlock for youtube. This one makes using youtube a little more bearable by automatically skipping the baked-in sponsorships and advertisements. It has literally cut down my viewing times of some channels by like 20%.

Are there any other extensions that you absolutely love?

I like a bit of M.C. Escher art, and I was looking for some Escher images when I stumbled across this old blog post by someone who designed and made his own Escher-inspired floor tiles. Fascinating stuff!

Here's the main page, showing a photo of the finished floor: https://danceswithferrets.org/geekblog/?page_id=911

Then there's 8 blog entries, showing the steps he went through from initial idea to finished product.

As a bonus, here's a simple guide I found, which explains how Escher designed & made his tiles: http://static1.squarespace.com/static/5754f47fcf80a16bffa02c45/t/57c6b680f7e0abc8f6ac6993/1472640669212/Escher-tiling-instructions.pdf

It's so simple when you know how! But there's obviously still some artistry involved in deciding what shapes to cut & paste.

My band are releasing a new single on the 5th August, another later in the year, and a third early next year. We've released a few tracks already, but we never seem to get much traction when trying to promote them. The band has agreed that a different approach is probably needed, and so we're open to a bit of experimentation. So, musos of Tildes: how do you go about promoting the music you release?

Some of my favorite books are nonfiction, so I'm looking for more. These could be from your field of expertise, but could also just be books you have enjoyed. They just need to be comprehensible to a moderately intelligent reader with little to no background in the subject matter.

Here a few I have enjoyed.
A Civil Action by Jonathan Harr,
Being Wrong Adventures on the Margin of Error,
Cadillac Desert,
Facing the Mountain by Daniel Brown,
The Man Who Mistook His Wife for a Hat,
Born a Crime by Trevor Noah,
The Day the World Came to Town,
Travels With Charley by Steinbeck

Edit, a couple more,
Flow the Psychology of Optimal Experience,
Bowling Alone by Putnam,
Because Internet by McCulloch

Hi,

I'm asking here in the hopes that someone remembers a music magazine of yore. "Launch" magazine was mailed to subscribers on a CD in the mid-90s. It was like... Pitchfork, edgy but with broader appeal. I honestly don't remember much of the music that was on there. It had these sort of Dilbert-esqe comics about being a programmer in a start up. Back then, I had no idea, really, what they were talking about, but I thought the comics were hilarious.

Anyway, I can't find it anymore. The name is really generic and nothing I find in searches seems to resemble what I remember. It might be the kind of thing that someone like a Tildes user who browses the music group might remember. Does anyone have a memory of this? Seeing those little comics again would be nostalgia gold.

Three devs just made one of the best selling games this year. A throwback to when games were more about actual gameplay than story or graphics. I think it's pretty cool.

What do you think so far? What are your favorite classes/loadouts? Any sneaky/funny shenanigans you feel like sharing?

Did you know the PP19 quick mag is horribly bugged and so the gun has the lowest recoil in the game? It isn't the best weapon, but it is pretty much a laser.

This is a thread for everyone to share their personal story. But I'll start with mine.

I was never an obese child. I was always borderline overweight, but I was never at risk for being unhealthy. At 15 I even managed to lose some weight when I did go into the overweight category. And then I graduated high school. I ended up gaining thirty pounds before starting college, and the weight just kept on piling up. Ending with me gaining over 120 pounds, and being over 300 pounds. I was 17 during this time period. I ended up losing quite a bit of weight, down to 218 during the summer following my first year. But I ended up gaining it back and could not go back down.

By the time I graduated college I was back up almost to my original weight. Unfortunately for me, I graduated in Spring of 2020. Right when the pandemic started. This just caused my weight to climb up even more. Even worse, I finally looked in the mirror and realized that my hair was thinning. This was an easier fix: Dutasteride. Got on that pill and that started growing my hair. You can read more about my struggle with that here. My eating was another ball game.

In late 2021, after being diagnosed with pre-diabetes, I decided to lose some weight. I did Keto, not because I felt like that was the only way to lose weight, but because I had read that was the best diet to reverse pre-diabetes. I did that for three months and it did indeed crushed my A1C number, and I lost a fair amount of weight. The problem was that when I got off the diet I gained a lot of weight back. Not all of it, but enough to make a difference. Keto was not a sustainable diet, but on top of that my thought process was "when this ends I'm gonna eat this I'm gonna eat that."

One day I take a pretty hardcore edible. Weed has an anxious effect on me and constantly makes me reflect on my own life and how unhappy I am with it. But this one time it made me realize how much of what was wrong with my life, or how much of what I did not like about my life was connected to my weight. And how many insecurities me being obese gave me. And how it was holding me back from doing what I wanted to do. It also made me realize why I used food as a coping mechanism, and it made me come to terms with the fact that on some level I had an addiction to food.

So that was actually very helpful, and I was able to move on, and actually commit. It helped me to recognize the signs of overeating, and made me pause whenever I would grab something to eat. I would eventually also start lifting weights and focusing on eating a lot of protein. And that helped me lose fat more than Keto ever did. Just the consistency of that was a lot better and honestly easier than the incredibly restrictive diet Keto is. I still struggle with food. I can't really eat chips, or popcorn, because I will finish the whole bag whether I want to or not. But it's gotten slightly easier, at the very least I've gotten better at trying to avoid things like that.

It's completely altered the way that I look. I just recently saw some family that hadn't seen me in a while, and they did not recognize me. My face is much more visible now. When I would get high I would look in the mirror and not recognize myself but now I do. Part of that problem is that I hadn't actually seen myself properly in a mirror since high school until this recent weight loss. So I was just completely delusional, by choice, about what I looked like. I look at old pictures and go "damn that's how I really was huh."

Now that I'm close to being the same weight I was back in high school, I feel more like me. I feel like I look more like how I perceived myself. I'm not scared to look in the mirror anymore. I'm not scared to take pictures anymore. I'm not scared to try on clothes anymore.

What's really been a trip is the fact that people find me attractive again. I don't want to sound conceited, but I am in fact not ugly. But my face was hidden under the weight. So for years nobody really found me attractive, and that's fair now that I've seen pictures of myself from that time (on top of me having no confidence back then). But now they do again. And it's going to take a little bit of getting used to, but damn it feels good. It feels good to finally date, to have the confidence to go out. It feels good for people to think that I'm 19 instead of thinking that I'm 30.

And I feel so much younger. I'm still in my early 20s, but before now I felt old. Like I felt like my body was falling apart. With how much my hips hurt, with how much my knees hurt, how slow I was. I remember when I was 20 my ankle hurt so much. There was like so much pressure on it and it would not pop. And then when I finally did pop it I had to continually pop it to feel relief. That's gone now. My joints pop a normal amount now rather than the excessive amount. I can crouch, I can get up from the floor, I can walk longer easily. Stuff that I should have been doing this entire time that felt almost impossible to do.

It's like I've been rejuvenated. Like I've been given a second chance to enjoy my youth.

And I really really don't want to mess it up again.

We have all done it and seen it happen but I don't know its name

Someone has tried and proven that something just doesn't work, it is broken. And so you call the engineer and the first time you try to demonstrate it, it works and then works afterwards every time.

It isn't Murphys Law and it isn't Sods Law but what is it?

I call it Engineer Syndrome but that cant be right

I have been a big X-Men fan since I was very small, and I have been ever-so-slowly collecting the Volume 1 Uncanny X-Men series (1963) since the late 1980's. I was surprised with a graded (6.5) copy of Uncanny X-Men #94 by my wife for my birthday a few years ago. I've always wanted a copy, but it's a fairly expensive book and one I never thought I would own.

In the issue, the original X-Men quit the team except Cyclops, and are replaced by Colossus, Wolverine, Storm, Nightcrawler, and Banshee while Sunfire returns to Japan. It's their first appearance in the Uncanny series and their second appearance outside of Giant Size X-Men #1.

I'm looking forward to an opportunity to get it signed, if Christ Clairmont does another CGC signing.

Fun fact about the issue from Wikipedia: There are no issues of Uncanny X-Men #94 that rate higher than a 9.8 on the Comic Guaranty LLC grading scale, so if you have an ungraded copy in pristine condition, you might have an extremely rare piece of comic book history.

So, How did you come across your favorite comic book in your collection? Was it a lucky find at a local comic book store or a treasured gift from a friend? Did you stumble upon it while exploring the crazy world of online auctions or conventions? I'm eager to hear the tales of how you obtained your cherished piece of comic book history.

"Generational" might not be the correct word. What I mean is that pop¹ music from the 20th century transitioned from one style to another in a way where decades could have pretty distinctive sounds. 50s music was different than 60s was different than 70s was different than 80s. What I'm wondering: what is your perspective on pop music style change from 2000s to 2010s to today?² Has it changed or does it sound the same as it did 10-20 years ago?

The reason I ask is that I listened to a pop station recently and it seems barely different than when I was in high school pre-2010. Taylor Swift is still incredibly popular, and listening casually to other songs, I had no guess on what year they were actually produced. It could have been 2012 or it could have been last year. I don't know if I'm just getting old and I've lost my ability to keep up on the nuance of current trends or if it's that pop music has stagnated the same way Hollywood movies have - art that is analyzed and meticulously designed to appeal to the widest audience possible.

[1] - I'm defining "pop" as Billboard Top 40 or equivalent.

[2] - I think this only applies to "pop" songs. I haven't noticed the same trend in sub genres such as country, rap, latin, or metal. I am also sure the extent of style variation over time depends on the country.