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.

Next.js Minimum Viable Build

23 Aug 2021 🔖 architecture jamstack web development minimum viable build 💬 EN

Like with Gatsby for novices and dabblers, I need to work my way through Next.js, because I find it intimidating.

Continue Reading

ETL QA is interpersonal communication

23 Aug 2021 🔖 architecture integration databases 💬 EN

I’ve spent a week writing e-mails and calling people after enabling a new primary-database-to-secondary-database feed.

I think one of the hardest parts about troubleshooting whether unexpected issues are “garbage in, garbage out” data-quality issues or whether they’re “I wrote bad code” issues is getting clarity about the input data quality from people who do the data entry without making them feel like I’m accusing them of failing to do their jobs.

Continue Reading

Next.js for novices and dabblers

22 Aug 2021 🔖 architecture jamstack tips web development 💬 EN

Like I did with Gatsby, I want to make sure it’s easy for novice web developers to explore if Next.js is right for them.

I aim to lower the bar by bringing you along as I learn it myself.

I also hope to abstract core Next.js concepts away from the command-line tools often used to implement them so you can keep your computer clean while you dip a toe into Next.js’s waters.

Continue Reading

Database fiscal year in review: 2020/2021

19 Jul 2021 💬 EN

Time for a performance check-in, and I realized I might as well brag publicly about some things I did in my database work this past year.

Continue Reading

Random handy CumulusCI notes

13 Jul 2021 🔖 salesforce 💬 EN

Below are some miscellaneous Salesforce scratch org / packaging / SFDX / CumulusCI / VSCode / Git notes I don’t want to forget.

Continue Reading

Open a Salesforce scratch org in a different browser with CumulusCI

10 Jul 2021 🔖 salesforce 💬 EN

Using Salesforce’s CumulusCI to manage SFDX scratch orgs? I am. I was working from a machine where Firefox is the default web browser, and Firefox didn’t play nicely with Lightning-mode editing of custom metadata types (it wouldn’t ever render the main part of the page where I edit types). Nor would Firefox let me switch to Classic mode (it kept logging me out of the scratch org). This is how I managed to open the scratch org in Chrome.

Continue Reading

Adding Tailwind to a Jekyll site on Windows

06 Jul 2021 🔖 web development jamstack 💬 EN

I’ve been wanting to migrate one of my web sites from the Github Pages Jekyll to 11ty for a while so that I could use Tailwind CSS and facitate a redesign of the look and feel.

In the end, I realized that migrating old .md files w/o breaking anchor links to subsections was going to be a regex nightmare, and I’d be better off figuring out how to add Tailwind to Jekyll.

Continue Reading

Jamstack live preview tooling

15 Jun 2021 🔖 web development jamstack 💬 EN

Vercel announced Next.js Live, real-time previews with live collaborative editing at Next.js conf.

This seemed like a good time to list all the options I’ve explored over the past year.

Continue Reading

Growing link underline, in Tailwind CSS

15 Jun 2021 🔖 web development 💬 EN

Today I learned that Learn 11ty From Scratch opened up for free. Searching for the news, I found Ben Myers’ article “I Finally Understand Eleventy’s Data Cascade,” which reminded me how much I like some of his styling, including links whose underlines are chunky and grow to be full backgrounds when you hover or focus on them.

I’ve been doing a lot of Tailwind lately on landing-page-type sites so I can rip off other peoples’ components, but I hadn’t found a link style I was satisfied with, so I ported Ben’s work to Tailwind. See it on Tailwind Play or keep reading to just see the source code here.

Continue Reading

SEO savings, one bubble tea at a time

10 Jun 2021 🔖 web development jamstack 💬 EN

Fact: My Huong Kitchen on “Eat Street” in Minneapolis (Nicollet Ave) has the best bubble tea in the Twin Cities, Minnesota, USA region. Not just on Eat Street. You get to watch fruit go into your blender for a smoothie, not boba powder.

The savory food is also delicately well-flavored, in case you care about more than your sugar rush.

In other words, if you mess with this teeny-tiny gem of a restaurant, hiding in its adorable hole in the wall, you’ve picked a fight with me.

By the way, if you want to do me a big favor, please go buy something, and tell the owners Katie sent you!

Continue Reading