As an old, I prefer the old reddit. Which, lets be honest, has been going away for a while.

But so long as I could browse on my phone via i.reddit.com, I was happily entertained by time there.

No longer. And I'm saddened by it. It was an imperfect community, but its good parts are replicated nowhere else as far as I can tell, Tildes notwithstanding. Although, if Tildes were maybe 2-3x as busy and had more para-reality* fans, it'd be really darn close. I am still sad, and sad that we can't keep awesome things that generate a lot of community benefit but low income (see also, usenet). Probably, it's a good dead cow.**

*As a true believer (tm), I hesitate to use the word conspiracy, because it has gained so many negative associations with far right absurdity and violence. Among the more serious members of the community, we have yet to come up with an easy to use term. Another thing in the world I am sad about. For the record, I don't believe the election was stolen, but I also don't believe Kennedy was assassinated by Oswald, or at least not him alone.

**if anyone is interested, I relay the story of the Wise Man, the Poor Family, and Their Cow.

This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.

I'm spending time at a new city and Google Maps is shit for walking. It's hard to say exactly what's wrong with it, everything feels wrong. Car centric logic just doesn't work for walking I guess (yes I'm using the walking mode). It feels bad, unreliable, and I'm lost all the time. Yesterday I ended up 2 hours away from my destination and had to call an Uber (big humiliation!). Walking is my preferable way of urban exploration and I hate talking to strangers.

What I want is a simple compass that tells me "go to that general direction and you'll get there". No map, no street names. Just an arrow and a linear distance (like, in a straight line). Like a videogame. Without foreknowledge, street names are just confusing and unnecessary. I can handle the route myself.

Does such an app exists?

Have you watched any movies recently you want to discuss? Any films 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.

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?

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?

I’d like your help – and your stories!

I’m working on an article with a tentative title of “Tales of the Crypt: Horror stories (about your past) where database performance caused a real problem.” It’s meant to be schadenfreude nostalgia, about your late nights coping with a performance issue (with, hopefully, a happy ending of “…and this is what we did to fix it”).

So, what happened? Tell me about it.

I do want to quote you, but we can be oblique about the attribution – especially because sometimes these stories are from a previous employer and do not represent any current affiliation. But I do want the verisimilitude that demonstrates that these tales-of-woe come from real people. As a result, I’m fine with writing, “Kim’s first job was as a mainframe programmer at a hotel chain, where database transactions required tape changes. ‘Yada yada story,’ says Kim, who now is CIO of a Midwest insurance firm.” Real person, but you don’t need to worry about getting anyone to approve your words. (Though if you’re happy with full name, company, and role, I’m even happier; send in a private message if you prefer.)

I used an ancient example above, but I’m hoping for more recent database performance stories. Ideally some of the “here’s how we fixed it” become practical suggestions for developers who are enduring such a situation today.

I want to try something new.

The post quality on Tildes is way above average. I myself only post articles/videos on Tildes if they meet my internal quality threshold, of which Tildes is the highest of any social media I post to.

I want to try to surface some of the quality. So, to that end, I'm trying a game. If it's successful, it'll happen recurringly.

The rules

Respond here with a post containing 1, 2, or 3 Tildes links. You are encouraged to give a short description of them and why you think they're of exceptional quality

1. The links must ALL be Tildes links.
2. The links can be of any type: Article, video, self-post, or even a truly outstanding Tildes comment. They can be very old or posted minutes ago.
3. At least one of your links must originate from someone who isn't you.

How to win

Every game must have a winner. For this iteration, whichever post is top-rated by "most votes" as of 2 weeks after this submission will win (excluding myself and any meta posts). And because every game needs a prize, I'll give them a selection of my many unused steam keys.

You are yourself encouraged to vote for replies that contain submissions you especially find of the highest quality!