Author: Jernej

  • Examples of PostgreSQL’s RETURNING clause and its impact

    The RETURNING clause in PostgreSQL is a powerful feature that allows you to retrieve values of one or more columns immediately after performing an INSERT, UPDATE or DELETE operation. This can save an additional query to fetch the data and is especially useful in applications where you need immediate feedback from the database operation. Below…

  • Na koncertu AKA Neomi

    V četrtek, 18. 4. je v Kino Šiška nastopila glasbena skupina AKA Neomi in na koncertu sem bil tudi jaz. Na koncertu je skupina predstavila svoj novi (tretji) album Lepo se svetiš v temi, pesmi pa so bile prej že vse na voljo za poslušanje preko YouTuba. Za koncert sem se odločil, ker za njihov…

  • Cut video in multiple clips and export them as a seperate video files (ShotCut tutorial)

    Sometimes I want to cut video in multiple clips and export each clip to a separate video file. One option to do it is with ShotCut. On screenshot below interesting parts of the UI are highlighted: The downside of this approach is the repetitive work of adding each clip on a playlist but I just…

  • Exercising with jump rope

    For the past six months I have been regularly exercising with jump rope. Prior starting it I only do strength training regularly and cardio every once in a while and I felt guilty not including latter more often into my workouts. Jump rope came to mind after browsing fitness YouTube recommendations (benefits, tons of workouts…

  • Breaking Up with Google: How ChatGPT Became My Go-To Search Engine for Everything

    As a millennial, I grew up relying on Google for everything from school assignments to travel plans to recipe ideas. I was a loyal Google user for years, until I discovered something that changed everything: ChatGPT. ChatGPT is an artificial intelligence language model trained by OpenAI that can understand natural language queries (including you native…