Posts by SamJSharpe@mastodon.me.uk
 (DIR) Post #AWUhKZmMBd5Rt2eqf2 by SamJSharpe@mastodon.me.uk
       2023-06-08T21:34:58Z
       
       0 likes, 0 repeats
       
       @simon I discovered the LAG() and LEAD() window functions recently too and it definitely neatened up some transforms I was doing.My previous solution was to use ROW_NUMBER() and then select out the current and previous value with row_num = 1, row_num = 2, but the LAG() pattern definitely cut out a few levels of nesting and made things a lot easier.
       
 (DIR) Post #AXcw9JN8F151V9qSW0 by SamJSharpe@mastodon.me.uk
       2023-07-12T18:28:13Z
       
       0 likes, 0 repeats
       
       @ianbetteridge I don't know why anyone would be surprised. There's a reason that The Sun doesn't have good circulation in Liverpool and nothing much has changed in the last 35 years.
       
 (DIR) Post #AXydNStew0FDXkqZN2 by SamJSharpe@mastodon.me.uk
       2023-07-23T06:04:16Z
       
       0 likes, 0 repeats
       
       @simon in theory "forever" because GitHub made the number of public repos an account can own "unlimited".In practise, I bet it's not unlimited, but even if it's *only* 2^16, that's still 180 years 😂
       
 (DIR) Post #AY0oiLEWFMfIdNLswq by SamJSharpe@mastodon.me.uk
       2023-07-24T07:20:28Z
       
       0 likes, 0 repeats
       
       @simon @ash the Homebrew argument is that you should be packaging each llm dependency as a Homebrew package, which can then be installed from bottles. I don't agree with that and in my mind if goes against the OSX way of packaging things as self contained blobs with dependencies embedded.You could distribute llm as a bottle, but then you need a build environment for x86_64 and arm64 and potentially multiple versions of MacOS as it's not supported to install bottles on previous MacOS versions.
       
 (DIR) Post #AZbapR7TFbSNj0C2LY by SamJSharpe@mastodon.me.uk
       2023-09-09T23:03:15Z
       
       0 likes, 0 repeats
       
       @penguin42 @neil a towpath implies a canal, but I think this was more like a stream.
       
 (DIR) Post #AZuC6Q5ijoEuxVrGr2 by SamJSharpe@mastodon.me.uk
       2023-09-18T22:23:04Z
       
       0 likes, 0 repeats
       
       @mjg59 young people have airline status? How? I thought all the airlines were preventing that obvious loophole.
       
 (DIR) Post #Abk6PIlPNxQAUeS6ts by SamJSharpe@mastodon.me.uk
       2023-11-12T21:17:00Z
       
       0 likes, 0 repeats
       
       @mjg59 I’m just looking forward to hearing about him eating unspeakable animal parts à la Hancock and Dorries. It’s the only reason worth him being on TV.
       
 (DIR) Post #Abk8jF316vzUfVKBJA by SamJSharpe@mastodon.me.uk
       2023-11-12T21:43:14Z
       
       0 likes, 0 repeats
       
       @mjg59 I'm hoping to get a few bush tucker rounds in before the body count goes up.