Posts by SamJSharpe@mastodon.social
 (DIR) Post #ATWJIDY2WkjEAcgg2C by SamJSharpe@mastodon.social
       2023-03-11T22:38:41Z
       
       0 likes, 0 repeats
       
       @simon funnily enough I needed to do something similar a month or so ago and I found this pretty nifty way of doing it. I dunno if that is faster or slower than a case statement, but it was fewer lines of SQL to read 🤣https://stackoverflow.com/a/33116186
       
 (DIR) Post #ATWLDf7Ao7km7x4nMu by SamJSharpe@mastodon.social
       2023-03-11T23:00:12Z
       
       0 likes, 0 repeats
       
       @simon yeah I wouldn't normally bother code-golfing an LLM, but in this case you just happened on something I happened to also need to do recently 🤣 If I had written it from scratch, I would definitely have made the case statement but I was surprised that sqlite didn't have a format string for the shortened month name like MMM or similar like other languages have so I went searching for that. I mostly deal in Spark SQL and Hive SQL and they both can give the month abbreviation.
       
 (DIR) Post #ATWNdX7TM78WlggEt6 by SamJSharpe@mastodon.social
       2023-03-11T23:27:36Z
       
       0 likes, 0 repeats
       
       @simon do you think it was trained on SO answers?
       
 (DIR) Post #ATzKfjhwcqb1LOQgEa by SamJSharpe@mastodon.social
       2023-03-25T22:35:57Z
       
       0 likes, 0 repeats
       
       @simon I see someone else has pointed out JC, but I think many of these recipes are based on a fairly well known gist that has been knocking around for a while. https://github.com/context-driven-testing-toolkit/git-log2json
       
 (DIR) Post #AU3PDSX4AOmwN0W5gW by SamJSharpe@mastodon.social
       2023-03-27T21:50:48Z
       
       0 likes, 0 repeats
       
       @simon I got as far as fixing up the OCR of the Curl command such that the server accepts it, but I think creating an encrypted payload is a bit beyond my understanding of encryption.
       
 (DIR) Post #AUdQg96OSZgNNkyHSK by SamJSharpe@mastodon.social
       2023-04-14T06:56:42Z
       
       0 likes, 0 repeats
       
       @simon AWS Sagemaker Notebooks can do it, because we use it at work for that, but I don't know how that compares to the other options. It really depends how big a machine you need to run a copy of the notebook for everyone on what the cost is, and if you run one Notebook Server, the only thing separating users is you'd give them differently named notebooks.
       
 (DIR) Post #AUgwM8qlT2Zoof2uOG by SamJSharpe@mastodon.social
       2023-04-15T23:37:33Z
       
       0 likes, 0 repeats
       
       @BarrenPlanet what are the other 75? Does that mean that 75% of that 70% is from privately owned entities? Who are they owned by?