Stuart
@sgrassie.bsky.social
Software Developer in North West England
Can anyone suggest how to handle writing a query for goal scorer streaks? I'm on postgres, and using lag(goals, 1), and in the next cte where I'm comparing if the streak is continuing I think it's not able to handle instances where a player scored twice, it thinks its a new streak
#sql #postgres
#sql #postgres
December 1, 2024 at 10:27 AM
Deactivated twitter. I feel liberated.
November 17, 2024 at 3:04 PM
Deactivated twitter. I feel liberated.
I actually wrote a blog post this year! I need to update the console app I wrote for helping with my blog, perhaps I'll blog about that.
www.temporalcohesion.co.uk/2024/11/04/b...
www.temporalcohesion.co.uk/2024/11/04/b...
build dotnet 8 in an offline build server
In a corporate environment, the build server you have access to, and might even be responsible for, is almost usually ‘offline’ - which is to say that for annoyingly sensible security reasons, it is n...
www.temporalcohesion.co.uk
November 16, 2024 at 9:08 AM
I actually wrote a blog post this year! I need to update the console app I wrote for helping with my blog, perhaps I'll blog about that.
www.temporalcohesion.co.uk/2024/11/04/b...
www.temporalcohesion.co.uk/2024/11/04/b...
Look at all these fancy folk upgrading to dotnet 9 when I'm still working on stuff for my clients in net48 and even older technologies.
November 15, 2024 at 10:42 AM
Look at all these fancy folk upgrading to dotnet 9 when I'm still working on stuff for my clients in net48 and even older technologies.