Software Engineer / Technical Architect working in the UK. on and around the Salesforce platform. Degree and interest in control and information engineering
Yorkshire, UK
Joined March 2023
- Tweets85
- Following21
- Followers24
- Likes14
A question for anyone using queryWithBinds() on Salesforce.
Database.query() has to be used in cursor mode if a subquery has more than 200 records, otherwise you are left with a dangling cursor exception reading the subquery after statement completion.
...
Today I did 50 climbs to raise money for Yorkshire Cancer Research and Diabetes UK.
Total climb between 500m and 750m (as big as one of our local mountains). Time about 6 hours.
justgiving.com/team/richard-…
Ouch! I'm writing demos to present on locking in Salesforce and thought I'd use a "publish immediately" platform event for locking.
Firing platform events breaks locks!!!!
Here the demo with logging inline, and again with logging delayed until end of execution.
I'll be doing an internal seminar on Salesforce concurrency. I have a pattern I call "Blind Write" after the "Blind" function on stage lighting desks. It allows the operator to set specific values without seeing the object (call it LightingState__c). But can I use that term here?
I've written up my AI hackathon results for work, but have drawn heavily on the AI module in my engineering degree. So there's lots of Bayesian in there and talk of possibilities for neural nets for vector classification and digital signal processing for data cleaning.
A large part of the AI module I did was looking at computer vision. That didn't come into this hackathon as we were not looking at vision problems. It's a field that's really changed since I studied it. Back then we were trying to logically analyse edges and vertices.
Salesforce Change Data Capture can produce GAP and OVERFLOW events after which the recipient needs to re-pull data. I wonder if it would be possible to make a Decorator which produced a stream without GAP events for a consumer. How much state would that Decorator need?
Looking at this stuff because I remember finding it relatively easy when I studied it at university in the 90s, so I want to put Salesforce Einstein through its paces by giving it models I can predict the answers to.
byclb.com/TR/Tutorials/neura…
Now that's quite neat. I don't know whether it's used a decision boundary or some other means, but it does show things like false positive and false negative and allows me to adjust cost ratios.
I'm exploring Salesforce Einstein Discovery using data I understand (shortwave radio propagation using WSPR data). I know that the data varies by frequency and time of day. Getting Einstein to find this is taking some coercion.
I'll revisit next time I find a gap.
My original data did not contain hour because Einstein can't extract an hour from a timestamp. My most interesting variable was not part of the model. It also considered outputs like "signal to noise ratio" as inputs. Transform is needed.