Salesforce, Python, SQL, & other ways to put your data where you need it

Need event music? 🎸

Live and recorded jazz, pop, and meditative music for your virtual conference / Zoom wedding / yoga class / private party with quality sound and a smooth technical experience

Bienvenue! Welcome!

My goal is to help you work faster.

I must speak and teach until I hear 10 people say, "That thing you taught me? I used it! And it saved me time!"

(Ahem ... although maybe blogging slower than I'd hoped. Ugh, coders' repetitive stress injury.)

So check out the tutorials. Play with code. Tell me about your triumphs.

Off-by-one errors in Python API pagination

16 Mar 2021 🔖 python tips 💬 EN

If you have json.loads(response.text) in a Python script using requests to perform a loop over API calls structured something like response = requests.get('') inside the loop, and you sporadically see an error stack ending in raw_decode mentioning ValueError from None like this, you might have an off-by-one error in your loop condition:

Continue Reading

A Lyris to Marketing Cloud imaginary architecture

15 Mar 2021 🔖 architecture integration salesforce marketing cloud 💬 EN

A lot of small organizations seem to have legacy use of Lyris (now Aurea) ListManager, even as they adopt newer mass e-mailing software like MailChimp or Salesforce Marketing Cloud.

One reason it’s been so hard to migrate away from is that Lyris offers you the ability to attach “magic e-mail addresses” to mailing lists (whose membership lists can be dynamically populated from an enterprise database), meaning, for example, that the chair of the Math department at a university can simply email from Microsoft Outlook, and it will be sent along as if they’d BCCed everyone.

For some internal groups, Microsoft Active Directory-based Office365 mailing groups can replace Lyris for this use case, but anyone in the organization can see their membership, so Lyris might still be preferred when list membership is a secret (e.g. to avoid harrassment of its members).

Today, I had a crazy idea that just might work to get Salesforce Marketing Cloud to behave more like Lyris for this use case.

Continue Reading

Can 11ty host my podcast for free?

10 Mar 2021 🔖 jamstack web development 💬 EN

Check out a GitHub repository where I’m building a podcast in 11ty. I’m feeling too cheap to mess with a proper CDN, since I haven’t fully committed to the idea.

Continue Reading

Stackbit can teach you web development

09 Mar 2021 🔖 jamstack web development 💬 EN

Have you seen Stackbit’s new “Code” & “Content” editors? I’m not sure what more a person needs in life to learn or teach static site generator HTML templating & front-matter data modeling practices.

I wish this had been around a year ago when I started my Jamstack journey.

Continue Reading

Data Development and Integrations (official Salesforce Developers podcast appearance)

08 Mar 2021 🔖 salesforce tips apex api architecture intermediate databases flow integration 💬 EN

Official Salesforce Developers podcast host Josh Birk is so much fun to geek out with!

Following up from Cactusforce, our working title was “APIs are for everybody,” but we threw in the whole kitchen sink of admineloper-ey goodness about Flow, data modeling, testing, Apex for beginners, user-oriented automation design, Python – and yes, APIs! – that the final show, hot off the presses, is called Data Development and Integrations.

Continue Reading

What's a docking station?

06 Mar 2021 🔖 videography 💬 EN

A docking station is a piece of hardware meant to be permanently-ish installed at 1 location, to facilitate plugging a laptop into accessories that are also permanently-ish installed at that location.

Continue Reading

Using OBS as a virtual webcam for Zoom conference calls

06 Mar 2021 🔖 videography 💬 EN

Going really deep into the world of “virtual webcams” …

In its latest versions, OBS has an option to set its output as a “webcam.”

Continue Reading

Using your phone or iPad as a webcam

06 Mar 2021 🔖 videography 💬 EN

To use your tablet or phone as a webcam, fed into your computer, you have to install some software at both ends to trick the two devices into behaving.

Continue Reading

PiP webcam + screen sharing

06 Mar 2021 🔖 videography 💬 EN

To simultaneously video-capture your face and your computer screen, and embed one “picture-in-picture” (PiP) style on top of the other, like a coding Youtuber would:

Continue Reading

Record 2 videos using the same microphone

06 Mar 2021 🔖 videography 💬 EN

On Windows, there’s no rule saying multiple running programs can’t make use of the same “microphone” at the same time. They can! You can produce 2 separate outputs that share 1 input audio track.

Continue Reading