https://en.wikipedia.org/wiki/2023_FIFA_Women's_World_Cup

starts this Thursday, July 20th, and runs for the next month.

here is a schedule that will automatically convert match times to your local timezone:

https://www.espn.com/soccer/schedule/_/date/20230720/league/fifa.wwc

I'd be interested in hearing from anyone who lives in Australia or NZ. what have the preparations been like? are you planning on attending any matches?

or, anyone who is travelling from other countries to attend - what has your experience been like?

I'll be watching on YouTube TV. it's one of the more expensive streaming options (currently 73 USD/mo) but I've used it for men's and women's world cups since 2018 (as well as several years of live & time-shifted American football). they've had one glitch in all that time, during a 2018 semi-final match, but otherwise it's been damn near perfect. I'd definitely recommend it if you can afford it.

please limit discussion of other streaming options to legal ones only - linking to pirate streams could get Tildes and Deimos into copyright trouble.

like probably a lot of people, I'll be time-shifting matches because I'm on the US west coast and many will be inconveniently timed (but you better believe I'll be awake at 3am on Sunday Aug 20th for the final)

to avoid spoiling matches for people who haven't seen them yet, please use <details> tags:

<details>
<summary>spoilers for Foo vs Bar match</summary>

wow I can't believe so-and-so scored 15 goals

</details>

turns into:

Nothing spectacular- I don’t particularly wince at bitter foods but after posting this thread:

https://tildes.net/~food/18ae/is_it_me_or_does_spicy_sweet_bitter

I was today’s years old when I learned most people don’t taste bitterness like I do; it’s not an overwhelming taste and on some foods a light bitterness is actually pleasant, but I didn’t know that others don’t taste the bitterness of things e.g. unsweetened sparkling water.

Well I’ll be a donkey’s uncle.

I've been thinking about the arguments that are increasingly common when dealing with tech: "it's too complicated" and "I just want something that works".

My father gifted a used computer to me and my brother when we were kids. Ours to use, ours to take care. He would pay for the eventual screw up, but we had to walk several blocks carrying the tower to get assistance.

I messed up a lot over the years, mostly because I wanted to explore the little that I knew and learn more. I had some magazines that expected everything to go well if instructions were followed and no access to internet forums to ask for help. I was limited to just one language as well. I had to find a way out. Nowadays things are much more simple and really just work, until they don't and I can't really fix them.

In this world, what people can do is complain. Or offer a report of how things went wrong and wait patiently. It's not even that common for people in general to just go back to the version that worked. There's no version, only the app we use or can't use and it's not our responsibility any kind of maintenance.

I have to confess I was going in another direction when I started, but things are really limited from a consumer's point of view. In part, it's our fault for not wanting to deal with the burden of knowledge, it inevitably takes the control away from us, but big tech really approves and incentives this behavior.

As with so many problems I see in the world, education is the solution. And educating ourselves might be the only dependable option.

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?

There was a post here the other day asking women about their preferences in a partner's emotional attachment style (not the exact wording, but about as close as I can remember). The responses were overwhelmingly critical of the framing of the question and how it mischaracterized the qualities of a healthy relationship. Upon looking at life.women a day or two later, it seems to have been removed.

While I agree that the post showed problematic thinking and was kind of a nuisance post rather than one which fostered healthy discussion, I'm not sure I agree with removing it entirely. The original poster did not seem to have any malicious intent, but instead displayed a flawed internal view of healthy relationships. Though the feedback was likely not what they were hoping for, I think it could be instructional not only for that original poster but also for any other site visitors who may have a similar way of thinking. If someone were to read the post and not recognize anything wrong with it, only to then read the criticism in the comments, it's possible they may discover that their own thinking is flawed in a similar way to OP and seek to change the way they view the topic. If we hide every problematic question, people with similar thinking won't ever see that 1) other people have similar problematic views and 2) those views are problematic for reasons X, Y, and Z.

More simply, if people come here and ask questions that we find distasteful, instead of deleting them should we leave them up with the relevant feedback so that other people learn from that interaction and develop a better idea of where the poster went wrong? It feels like there are a lot of folks out there that might be simply ignorant about social and relationship norms and could learn by example. If these people never see a post where someone is getting called out for their misguided thinking, how do we expect them to learn what's acceptable and what isn't?

I'm curious to hear your opinions. Should we tolerate entertaining some troublesome questions in order to better educate others, or is it not our job to teach them proper social skills/those posts don't belong here at all?

(To be clear, I do not support leaving up anything overtly abusive or malicious/hateful, those should obviously be removed ASAP).

I've been keeping a finger on the pulse of analytics & contract valuation in the NFL for the last few years (as a fan, not related to my profession). Anyone else who has been of fan of this is probably aware that we hit a pretty serious breaking point yesterday, as a handful of top-end RBs failed to reach deals with their respective teams resulting in them being franchise tagged. I was wondering what others thought about this whole fiasco.

My thoughts:

In one sense, this is simply effective roster management: RBs add little win probability by themselves (i.e., their production is largely a result of the offensive line and passing game), their age curve is poor (i.e., they're typically out of highly productive years by the end of their rookie deals), and they're easily replaced by rookie talent.

On the other hand, these guys take a beating to produce a product we all love. They spend some of their best years in the college system, where they do seem to add a lot of win probability, being totally uncompensated. They get to the NFL only to have their potential earnings suppressed by the rookie wage scale, then get franchise tagged guaranteeing they'll be SOL with respect to a deal with big fully-guaranteed cash.

What's the solution here? Assuming the draft is an efficient(-ish) market, adjusting the rookie pay scale for them will just cause teams to adjust their drafting behavior. Letting RBs arrive to the NFL sooner than everyone is something that the NCAA almost certainly won't allow without a vicious fight. Is there any hope for these guys?

edit: typos

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.

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.

Just wanted to put this out there as a little PSA in case it's helpful: if you want a cloud server but don't wanna pay anything, Oracle's Free Tier is a life saver. Discovered it a year ago and couldn't be happier I did, since I'd never pay for cloud computing otherwise 😭.

Quick Specs:

For free you get:

• 24/7 uptime
• 200gb of storage space
• 24GB of RAM
• 4 OCPUs
• 4 Gbps Bandwidth

That's been more than enough for me and honestly feels too good to be true. Some things I've done with this:

• Minecraft Server
• Radarr/Sonarr Plex Setup
• I'd like to make my own backup solution as well!

If anyone has any other ideas for cool projects I could self host, please do tell I'm curious what else I could do :)

ABC news article: Voice to Parliament referendum pamphlets for Yes and No camps published by AEC

On the Australian Electoral Commission's website:

• The case for voting Yes

• The case for voting No

The Sydney Morning Herald / The Age newspapers have provided annotated versions of each pamphlet:

• The Yes pamphlet annotated: 14 things you should know

• 17 things you need to know about the No pamphlet

As has been observed in those annotation pages, there is no legal requirement for either of these pamphlets to be truthful or factual, and there is no obligation for the AEC to fact-check them (in fact, the AEC is legally restrained from commenting on those pamphlets in any way - its role is restricted to disseminating those pamphlets, because it must stay neutral).

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.

https://youtu.be/vodNabH5qoM
But some important context:

Earlier this month I saw a post regarding a Misinformation Susceptibility Test and was curious how 20 binary questions could be an indicator of someones media biases.

I started digging into the related paper and while the methods and analysis was interesting, there was still a lot of questions. So I reached out to Dr Rakoen Maertens who headed the study and we agreed to a discussion on the assessment and his experiences in social psychology.

The video above is an unlisted, unedited cut of the interview and I'd love to get some feedback:

Firstly: I have offered the Dr a tildes invite and he may engage with any questions or discussion. Time was limited and there were a lot of topics that was only briefly touched on or overlooked. Here is the original paper and supplementary resources if you want to see some of the language model work and bigger 100 question tests.

Secondly: I am going to do a more through edit and posting this on a dedicated channel. Since cutting off reddit, twitter and tiktoc; I've sort of rediscovered a love learning and investigations. I'd like to know if people like this form of engagement and discussions. No fancy production, just simply engaging with the research and academics behind topical and interesting ideas.

I'm already reading into fandom psychology, UV reflective paint, children's TV and CO2 scrubbing technology.

I absolutely adore both, it has such a relaxing animation style and soundtrack. Kind of an embarrassing guilty pleasure as a guy.
The soundtrack is partially by the artist Baths who is also incredible. And I just saw its been released sometime recently!
Anyways please leave your thoughts about the show, I hope it gets another season, which is likely since they were partially acquired by Toho studios
(⁠◍⁠•⁠ᴗ⁠•⁠◍⁠)

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.