home.social

#lateral — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #lateral, aggregated by home.social.

  1. Интересный хак для упрощения сложных SELECT в Postgres

    Если вы пишете сложный SELECT, в котором одно и тоже вычисляется несколько раз, например, для массовой обработки данных пачками, то наверняка вам хотелось завести локальную переменную вот пример: SELECT price * quantity AS total_price, (price * quantity) * 0.15 AS tax, ((price * quantity) + ((price * quantity) * 0.15)) AS grand_total ... Здесь price * quantity вычисляется несколько раз, и tax вычисляется дважды. Но это выглядит еще ок, в реальности это зачастую всякие монструозные свитч-кейсы с NULLIF, COALESCE и прочими ребятами. Но не суть, вам хочется один раз вычислить значение, без дублирования кода. Long story short, это делается так:

    habr.com/ru/articles/1005138/

    #lateral #cross_join

  2. I've only recently got into Tom Scott's #Lateral on YouTube and, in doing so, I've also discovered that Bill and Dani from #EscapeThisPodcast look nothing like I'd imagined whilst listening to them.

  3. ⬇️ Dumbbell Behind the Back Lateral Raises ⤴️

    Dumbbell Behind-the-Back Lateral Raises place your shoulders in a unique mechanical position that emphasizes the side deltoids through stretch, isolation, and controlled tension, three of the biggest drivers of hypertrophy.

    #dumbbell #lateral #raises #workout #exercise #back #shoulders #delts #advice #tips #form #technique #onlinecoach #personaltrainer #onlinefitnesscoach

  4. And Tom Scott learned that hard way that it's dangerous to share the stage with three comedians when you're not one. #lateral

  5. Let’s gooooo!

    At the #Lateral podcast recording!

  6. In the queue for #lateral - and just 30m of queue in front of me. Half an hour before the doors open

  7. After seeing today's Lateral episode (this is not a spoiler btw), I was reminded of the days when sites would use pop-up licences on their websites. Specifically, the ones where the text in the pop-ups was editable - because someone fucked up.

    You could literally delete some/all the text and write whatever you wanted in its place. Then you'd click the ACCEPT button and it'd work.

    I'm still owed billions of dollars as well as several first-born children.

    #Web1 #OldenDays #Stories #Lateral

  8. Watching #Lateral last night:

    @tomscott mentioned an art installation where you turned a crank and it paid you in pennies at the rate of the minimum wage as you turned, describing it as on point and bleak.

    Only thing I'd change about this is to have it hurl abuse at you every couple of cranks, just to get the true service worker experience.

  9. Poor questions on the current #Lateral Episode. @mattgrayyes butchered them all 😆

  10. I was delighted to see Lateral's latest episode is about the man command's easter egg, what a treat. 😍 I know the answer as early as I see the title of the video, how can one forget this funny little thing exist after they heard about it once, it's just too catchy. I'm not an ABBA fun but this songs lyrics still stuck in my mind. 😂

    'Gimme gimme gimme a man after midnight ('half past twelve)' or I should say just "gimme gimme gimme", the man command's output when you run it in 00:30. 😂

    Edit: 😢 Sadly the fun has ended years before, this easter egg was removed 7 years ago. This detail somehow escaped me.

    #easteregg #man #unix #linux #lateral

    Lateral with Tom Scott - A late night UNIX feature.

    inv.nadeko.net/watch?v=LCro9LL

  11. It feels like half my subscriped London-based youtubers are in the balconies #lateral

  12. #Astuce #Firefox, oui, tiens, pour une fois :tony_wee:

    Si vous n'avez que faire du nouveau #panneau #latéral de discussion avec une "Intelligence Artificielle" (en option sur versions #Beta et #Nightly), vous pouvez modifier une entrée d'about:config pour y placer une #url que vous visitez fréquemment.

    J'ai pris l'exemple de #VivaldiStatus pour suivre l'état des services :vivaldi_blue: Web, Mail, Mastodon, blogs perso, que vous pourriez utiliser même si vous n'utilisez pas #Vivaldi.

    - Modifiez dans about:config :
    browser.ml.chat.provider avec la valeur vivaldistatus.com

    - Vérifiez dans about:config que
    browser.ml.chat.enabled=true

    Cliquez sur la petite #icône ✨ pour faire apparaitre/disparaitre ce panneau latéral, intelligent, lui 👍

  13. #lateral #Wordle 1,185 6/6 #phew
    ⬛🟨⬛⬛⬛⬛🟩⬛⬛🟨⬛🟩⬛🟩⬛⬛🟩🟩🟩⬛⬛🟩🟩🟩🟩🟩🟩🟩🟩🟩
    #lateral #nerdle nerdlegame 971 3/6
    ⬛⬛⬛🟪⬛🟪⬛🟪🟪⬛🟪🟪🟪⬛🟩🟪🟩🟩🟩🟩🟩🟩🟩🟩

  14. So @CeeZedby just got the correct answer for the latest Lateral by choosing the most stupid choice. We're still laughing. - youtube.com/watch?v=01yQfW-1S-

    #Lateral #TomScott

  15. TIL that British people pronounce “coyote” as “coy-yo-tee” (which actually makes more sense, really, but I’ve never heard it that way before) #Lateralcast #lateral

  16. I have important information for your ears!

    I'm back a guest on Tom Scott's LATERAL!

    Have a listen to this week's podcast if you like quirky questions about tricycles, physicists, Ancient Rome and more...

    lateralcast.com/

    #puzzle #quiz #podcast #lateral #TomScott #question #questions #puzzles

  17. Yes, that's right, I was back on Lateral last week! You can find me on episode 78 at lateralcast.com/ and there are a few highlights on YouTube such as right here: youtube.com/watch?v=Gd5L_TpVTF

    Let the confusion commence!

    #puzzle #puzzles #lateral #TomScott

  18. CW: Lateral with Tom Scott Episode #71 A sushi blockbuster

    It took me entirely too long to get the „not hammer“ question 😳. I basically got it as the contestants got the answer. #lateral #tomscott

  19. I'm BAAAAAAACK! You can't get rid of me that easily! Once again, I say the word "horse".

    lateralcast.com/episodes/71/

    #lateral #puzzle #puzzles