What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.

I am faced with an unusually busy year this year between work and school. I have one window for a vacation between December 27 and January 7. My planned travel companion can no longer come along. My ticket can be changed to most destinations worldwide.

Before I choose to go alone or to not travel this year, I decided to ask this community the following question. Is there anyone who lives on a continent I consider less risky to visit alone, who would be open to a meetup and provide some local travel advice? I understand that many people fiercely protect their anonymity and I am not trying to convince anyone. If no one responds, that is fine.

I also don't need or want handholding or babysitting. I am a middle aged, american married woman with some health issues. I am a moderately experienced traveler.

If you are open to discussing this possibility, please feel free to reply or message.

Apologies to my friends in South and Central America and in Africa. I need this trip to be relatively easy and to feel 99 percent safe while traveling alone.

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?

The vaccine antigen technology, developed by the University of Cambridge and spin-out DIOSynVax in early 2020, provided protection against all known variants of SARS-CoV-2 – the virus that causes COVID-19 – as well as other major coronaviruses, including those that caused the first SARS epidemic in 2002.

The studies in mice, rabbits and guinea pigs [...] found that the vaccine candidate provided a strong immune response against a range of coronaviruses by targeting the parts of the virus that are required for replication.

Professor Jonathan Heeney from Cambridge’s Department of Veterinary Medicine, who led the research, [said] “We wanted to come up with a vaccine that wouldn’t only protect against SARS-CoV-2, but all its relatives.”

https://www.eurekalert.org/news-releases/1002345

https://www.nature.com/articles/s41551-023-01094-2

I have Bipolar I with minor psychosis, CPTSD and OCD. I was born into an emotionally abusive family, and they are the only people i know, because i am also chronically alone and have dealt with feelings of loneliness on some level since i was a young kid. I had some online friends who helped me a lot with mental health issues but i lost access to them. The main reason im suicidal is because i feel like i have really bad luck. No matter what i do it ends up amounting to nothing. Everytime i start having hope i lose it because something bad happens to me again.
I hear about mental illness and people having a successful life despite it and despite feeling hopeless, but i just dont see that its possible to ever have a life worth living.
I really hope there are other people who relate, or maybe people who used to be that hopeless but ended up living a good life.

I've been climbing for about 2 years now and yesterday I was finally able to complete my most difficult route yet without stopping for a break! I've tried this 6C about 15 times or so and only finished it twice, but I usually fall or have to stop to rest in the middle, so I was really pleased I did it in one!

What about you guys?

(P.s apologies if this is the wrong place for this. At first I was going to post in ~sport but that looked more like pro sport news)

Find yourself watching tons of great videos on [insert chosen video sharing platform], but also find yourself reluctant to flood the Tildes front page with them? Then this thread is for you.

It could be one quirky video that you feel deserves some eyeballs on it, or perhaps you've got a curated list of videos that you'd love to talk us through...

Share some of the best video content you've watched this past week/fortnight with us!

So the discussion at https://tildes.net/~movies/1ar2/martin_scorsese_says_fight_back_against_comic_book_movie_culture_by_supporting_directors_like made me think about mainstream Hollywood way of movies versus - well everyone else? I am not even sure I like the term "arthouse" movies, because movies are movies regardless of the boxes we put them in, but for the sake of the argument movies that don't fall in the category of traditional mainstream storytelling. Is it just French artsy fartsy pretentious weirdness or is (quote) real cinema (unquote)?

I think my movie habits have been pretty average. I am not American, but most of what I have watched during my lifetime have been Hollywood productions. By a huge margin. In recent years I found myself going more and more bored with both movies and tv series from whatever the algorithms at the streaming services were pushing to me. Not that it was bad, just felt more and more like a product designed after a specific set of criteria aimed at my taste demographic. So I forced myself to break out of the bubble and watched movies totally outside my comfort zone with something I am sure the algorithms would never have recommended me. Started with movies by Kieslowski and Wong Kar-wai. And since then I feel like a whole new world of movies has opened up for me. Not that everything is magically great. There are still pretentious French movies that make me roll my eyes, but most of all it is something different. Story telling rules I thought couldn't be broken are thrown in the air and something completely unexpected appears on screen instead.

It takes some getting used to. I really struggled with a good deal of self-doubt whether I could actually understand these movies, because I have studied film theory or went to art school. At the end of the day it is really just about watching things intuitively and trying not to analyze everything or thinking about what things are supposed to mean, and be curious to why the movie does things that maybe the complete opposite of the film techniques I was used to from more mainstream movies.

This is not to bash at the Hollywood blockbuster way of filmmaking, because when that formula works - it really damn well works. But so can something completely different like Hlynur Pálmason's Godland, Haneke's Funny Games or Bujalski's Computer Chess - just to name a few of my recent very compelling movie experiences.

I've taken on the monumental task of scanning my family photo albums in and saving them to a NAS (plus cloud, of course). 1000+ photos in, and I had the great idea of also banging through the images with AI to clean them. Anyone who plays with AI knows it can be a little hit-and-miss. The tool of choice was GFPGAN and in some images it cleaned them lovely, others, not so much.

To help sort this out I'm looking for a side-by-side image viewer, similar to something simple like Gwenview, that allows me to look at the files and simply pick the better image. I'm not sure this software even exists after the exhaustive time I've been looking for it. I'm on Linux, so that may be the hindrance here. Brownie points if I can pick the better image, and it copies the file to a new folder to allow building out a mixed bunch of files from the two source folders.

Absolute worst case, I'm willing to put some money in a pot for someone to develop this very needed tool. Best case, if the software doesn't exist and they build it for timasomo.

Note: Tried XNView but it won't compare across folders.

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.