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.

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

Using a Behringer UCA202 with Windows, Android, or iOS

06 Mar 2021 🔖 videography 💬 EN

A Behringer UCA202 USB audio interface is special because Windows, Android, and iOS (iPad, iPhone) all see it as a single simple combination device: 1 stereo microphone + 1 stereo speaker. It works like a dream for playback w/o unplugging.

Continue Reading

Listening to computer sound through an Audient iD14

06 Mar 2021 🔖 videography 💬 EN

Bad news: I haven’t yet figured out how to make a Windows computer think of an Audient iD14 USB audio interface as a “speaker” and send sound from the computer to the iD14’s headphone jack.

Continue Reading

Recording an Audient iD14's sound in Windows

06 Mar 2021 🔖 videography 💬 EN

On Windows, an Audient iD14 USB audio interface works like having 5 stereo microphones plugged into 5 USB ports simultaneously.

Continue Reading

Intro to streaming and recording concepts

06 Mar 2021 🔖 videography 💬 EN

In this series, I’ll be sharing a few notes I recently wrote for a musician to orient them to various pieces of hardware and software they’ve been able to borrow or buy during the pandemic for the purpose of livestreaming and recording performances and tutorials.

Continue Reading

My video editing software

01 Mar 2021 🔖 videography 💬 EN

A family member just asked me about my tech stack for video editing, and it’s all over the place. Here’s what I’ve come up with so far.

Continue Reading

11ty Markdown -- group pets by color

08 Feb 2021 🔖 architecture databases jamstack tips web development 💬 EN

Back in November, I addressed a StackOverflow question about how dynamic “list” generation worked in 11ty compared to Drupal views. I explained the mental adjustments you’d have to go through when switching from a web site management system with a relational (SQL) data model vs. an object data model.

However, not really understanding Eleventy’s handling of Markdown, I did so with all of the data inside a single .js file within the _data folder. It turns out Alec wanted to know more about crunching data from Markdown files in 11ty. Now that I understand 11ty’s processing of .md files a bit better myself (and the ways you combine .md files with .11ty.js / 11ty.json files inside a folder to avoid repeating yourself within Markdown front matter), I decided to take another stab at making a web site that groups “kittens & puppies” by color – this time with Markdown instead of JSON data. (Code; live site)

I’m pretty pleased with the results as an example of the way 11ty helps you store your data exactly how you want it, while also generating URLs according to your dreams.

Continue Reading