Virtually none of my friends read books. I don't think my neighbors do, either. Sometimes I feel like I'm the only book reader. There's no one to talk to about the books I'm reading. I can post on the Internet and I will get a few upvotes here and there, sometimes a comment, but there's no depth to it. Also, I'd like to talk about books in person, not keyboard. The statistics of readership as conducted by our national library (Poland) were always piss poor, while I think they don't cover the whole society (because they focus on books lent from libraries?) it still seems accurate. Our nearest southern neighbors (Czechia) have high readership, same as our western neighbors (Germany, gosh I envy the sheer amount of books published in German). Poles not only don't read, but because of that we get only a small chunk of published books, oftentimes I search for a book online and there are English, German, Spanish, Russian, Czech (not as often, but a lot more than Polish) translations available, but not Polish -- I understand it, it's not worth it business-wise to publish some obscure books in Poland. It's a sad affair.

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.

Sorry for seeming like a total idiot but I cannot find the process to change my text color when I type a message.
I checked this site and did some online research with the Markdown system itself which is new to me.
It appears that there is some kind of code insertion but it's unclear how to format.
So many of you are advanced computer users and I am just your traditional semi-fluent poster.
Any help would be appreciated.

I have a server running Unraid at home. I have ~20 docker containers running at the moment with almost all of them only available within my local network. I just stood up an instance of Seafile on the server to act as a google drive replacement. Still in the early test phase before I commit to throwing important stuff on there. I have my domain proxied through Cloudflare so none of my local ports are exposed to the internet. Seafille has complicated passwords set for admin and user accounts (generated with Bitwarden, hot damn I love that app). I also enabled 2FA on each account. I know that I can further clamp it down using some of Cloudflare's extra access controls but in my admittedly limited experience, those all cause issues getting an app to authenticate with the service. Web apps don't have this issue of course.

So am I ok with this setup? I can encrypt the data before uploading easily as it's a built in feature of Seafile. Or would it be better to just run with local only and run a VPN to access when I'm outside?

I figure just about any effort along these lines I trust more than Google with my data. But I may be overconfident in that perhaps. I'm still learning the ropes with Linux and self-hosting in general.

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 :)