Vadim Zaytsev

@piperatdawn

RU/ENG 35 y.o. ex-terminally unemployed Ruby on Rails developer (redemption arc progressing nicely). TTRPGs, gaming, music, being angry at the world. Sometimes I fight windmills in the comment section.

568 Folgt494 Follower4.531 Posts

Reddit YouTube YouTube YouTube YouTube YouTube YouTube YouTube YouTube Bluesky

Ist das dein Profil?Übernimm es — dann gehört dir piperatdawn.dirty.social.Profil übernehmen

Vadim Zaytsev@piperatdawn· 26d

AND THIS GUY IS COMING TO COLLECT (you ain't evading those taxes)

Vadim Zaytsev@piperatdawn· 27d

Покажите мне настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку. Я сказал настоящую музыку.

Vadim Zaytsev@piperatdawn· 27d

Vadim Zaytsev@piperatdawn· 27d

У меня продолжают.

Vadim Zaytsev@piperatdawn· 27d

Судя по всему, да - упоминаешь ИИ, лайк последних двух постов и подписка.

Vadim Zaytsev@piperatdawn· 27d

Мне нравится, что на этот комментарий вместе с другим рандомным комментарием на английском набежала куча ботов. Отряд высокосинхронных билингвальных ценителей тупых шуток.

Vadim Zaytsev@piperatdawn· 29d

A handy illustration of what happens if you read the Hobbit without special preparation. RIP Sam Neill :(

Sam Neill in Event Horizon, scarred and eyeless

Vadim Zaytsev@piperatdawn· Jul 10

The thumbnail of the video with Quinn compared to an old-timey boxer because of the way he's holding his hands, with the speech bubble: "games! fight me"

Vadim Zaytsev@piperatdawn· Jul 6

THAT'S IT, MOTHERFUCKER, I'M GOING WIDE

Vadim Zaytsev@piperatdawn· Jul 6

Vadim Zaytsev@piperatdawn· Jul 1

I managed to snag the same edition dirt-cheap in an online Russian store, which was lucky, foreign lit is mostly sold in paperbacks or expensive hardcovers. It had the original price tag in dollars, and I got it cheaper than it costs at current rates. Haven't read it yet though.

Neuromancer green cover with circuitboard-style golden inlaid text

Vadim Zaytsev@piperatdawn· Jun 27

Clasping hands meme with Zohran Mamdani photoshopped on top of both people

Vadim Zaytsev@piperatdawn· Jun 27

(This is not an edorsement of Fate)

Vadim Zaytsev@piperatdawn· Jun 26

Heh, I like the almost perfect 50/50 on techbro/neo-luddite. britmonkey.com/2020s-politi...

Political test results:
83% Woke / 17% Chud
48% Techbro / 52% Neo-Luddite
58% Hopepilled / 42% Doomer
80% Davos / 20% Dubai
Closest Match:
Zohran Mamdani

Vadim Zaytsev@piperatdawn· Jun 26

The "Powder that makes you say..." meme, except the guy is colored blue with Bluesky butterfly wings, eating powder from a JOKE POWDER can, saying "THIS IS TERRIBLE!"

Vadim Zaytsev@piperatdawn· Jun 23

Media literacy is important, folks.

Meme where a guy is looking at 1984, Children of Men and V for Vendetta and making nuanced interpretations while the idea "The UK fucking sucks" goes over his head

Vadim Zaytsev@piperatdawn· Jun 20

Norm MacDonald laughing after loudly saying "NINE ELEVEN" and staring at his conversation partner, as he was wont to do

Vadim Zaytsev@piperatdawn· Jun 18

The cover of "Parable of the Sower" with the word sower circled in red and pointing with a red arrow to a picture of Josh Sawyer

Vadim Zaytsev@piperatdawn· Jun 18

It said my rarest pick was Socrates Jones - only three other people picked it. I played it way back as a Flash game in the browser!

1. Socrates Jones: Pro Philosopher
https://store.steampowered.com/app/2120060/Socrates_Jones_Pro_Philosopher/

2. West of Loathing
https://store.steampowered.com/app/597220/West_of_Loathing/

3. The Drifter
https://store.steampowered.com/app/1170570/The_Drifter/

4. Chants of Sennaar
https://store.steampowered.com/app/1931770/Chants_of_Sennaar/

5. Roadwarden
https://store.steampowered.com/app/1155970/Roadwarden/

6. Skald: Against the Black Priory
https://store.steampowered.com/app/1069160/SKALD_Against_the_Black_Priory/

7. Felvidek
https://store.steampowered.com/app/2299900/Felvidek/

8. Drova - Forsaken Kin
https://store.steampowered.com/app/1585180/Drova__Forsaken_Kin/

9. Colony Ship: A Post-Earth Role Playing Game
https://store.steampowered.com/app/648410/Colony_Ship_A_PostEarth_Role_Playing_Game/

Vadim Zaytsev@piperatdawn· Jun 16

James Franco in a noose saying "First time?" meme

Vadim Zaytsev@piperatdawn· Jun 15

*Sigh,* I did not know it works that way (in the project, a previous developer had created a double-column index both ways several times, I just assumed that was the best approach for whatever reason).

Screenshot of Google's AI overview:

No, you generally should not create two composite indexes for both permutations unless your specific query patterns strictly demand it and you have weighed the write-performance trade-offs. Database engines read multi-column composite indexes from left to right. This foundational behavior determines exactly how your queries will utilize your indexes.Understanding Left-to-Right Index BehaviorIf you define a single composite index as (ColumnA, ColumnB) on your table, the database optimizer can use this single index to speed up:

Queries filtering by both columns: WHERE ColumnA = x AND ColumnB = y.

Queries filtering by only the first column: WHERE ColumnA = x.

However, that exact index (ColumnA, ColumnB) will not be effective for queries filtering by WHERE ColumnB = y alone, because ColumnB is not the leading (left-most) column in the index.

Vadim Zaytsev@piperatdawn· Jun 14

The cover of Disco Elysium with the textbox with the words "Basic reading comprehension is needed to fully enjoy the game." pasted at the bottom

Vadim Zaytsev@piperatdawn· Jun 14

Screenshot of angry Willy Wonka saying: "You are rejected from the gallery of my retinas! You lose! You get nothing! Good day, sir!"

Vadim Zaytsev@piperatdawn· Jun 11

This is the dumbest thing I've seen in a while, I love it.

A photoshopped poster for Ingmar Bergman's The Seventh Seal. The title is now The Six Seven, and the knight is holding out two hands palms-up over the chessboard before Death

Vadim Zaytsev@piperatdawn· Jun 9

@mattcolville.bsky.social my DM got the "Dune that Matt Colville likes." No idea what we're doing so far. Bene Gesserit tried to use the Voice to force Harkonnen to play Family Atomics in their fight before we figured out it's not a weapon.

Russian edition of the Dune board game (2019)

Vadim Zaytsev@piperatdawn· Jun 9

Quinn getting up to tackle and tie down a guy dressed poorly as a sand worm at a table with the Dune board game

Quinn putting his hand in a cardboard box with a slit held by a guy dressed up, poorly, as a Bene Gesserit

Vadim Zaytsev@piperatdawn· Jun 8

Sebatian Murphy of the Viagra Boys, from the music video for "Bog Body," with a speech bubble pointed at the quoted post

Vadim Zaytsev@piperatdawn· Jun 5

I mean, for music specifically, reactions from composers/musicians are really good. Charismatic Voice, Doug Helvering, Critical Reactions, Virgin Rock, Ok Christina Listens, etc. If you want someone who really milks the thumbnail format, check out Isaac Brown… but it's still actually great content!

Screenshot of Isaac Brown's channel with multiple thumbnails about "Gez-Z music producer AMAZED listening to something for the first time"

Vadim Zaytsev@piperatdawn· Jun 4

Решил проверить, есть ли более грамотный способ сказать "не-носитель языка", и обидел гугл.

Vadim Zaytsev@piperatdawn· May 26

Was reminded of a lovely interview with NoMeansNo's Rob Wright. alienatedinvancouver.blogspot.com/2018/05/nome...