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.

Sanity datatable serializer for 11ty sites

10 Sep 2020 🔖 jamstack web development 💬 EN

Playing with the 11ty (Eleventy) code from Knut Melvaer and Bryan Robinson’s sanity-eleventy-blog repo (from Sanity’s official tutorial on 11ty) and a Sanity project started using the built-in “blog” dataset, I got stuck adding Fred Jens’s sanity-datatable Sanity Studio plugin to the body rich-text editor of Sanity because 11ty threw an error: “Unknown block type ‘table’, please specify a serializer for it in the serializers.types prop.”

Continue Reading

Sep. 9: Content creation panelist on Whiskey Wednesday podcast

08 Sep 2020 🔖 tips 💬 EN

Sep. 9 at 9AM Pacific / 12 noon Eastern / 4PM UTC / 5PM British Summer Time, I’ll be livestreaming as a guest on Whiskey Wednesday, a new web development podcast by Marc Backes and Scott Spence. I can’t wait to join fellow panelists Randall Kanna, Rich Haines, and Jon Hilton.

Continue Reading

Intro to XML, JSON, & YAML: the book

04 Sep 2020 🔖 xml json yaml tutorials 💬 EN

I wrote a book!

I'm honored by this lovely note from traditional sysadmin turned Salesforce admin + developer Kris:

"Thank you SO MUCH for making JSON and XML clear and removing the enigma and fear and ego from these topics."

Download or print your copy of Intro to XML, JSON, and YAML.

Continue Reading

Reading a datetime with miliseconds into an Oracle DATE

26 Aug 2020 🔖 databases sql integration api json instructure 💬 EN

While fetching information from Instructure’s Bridge learning management system API, I noticed that their course completion timestamps include miliseconds (e.g. 2020-06-30T08:19:16.413-07:00). I needed to load this value into a DATE-typed column in an Oracle database table.

Continue Reading

Choosing a headless CMS without losing your head

24 Aug 2020 🔖 web development jamstack digital garden 💬 EN

Snap judgments about whether I’d ask my grandparents to use a variety of content management systems (CMSes) popular in the world of static website management:

Continue Reading

Why do bloggers love Markdown? Why use MDX? And other notes from MDXConf 2020

24 Aug 2020 🔖 jamstack web development 💬 EN

Live-notetaking from MDXConf below.

Continue Reading

Qu'est-ce qu'un générateur de site statique ?

18 Aug 2020 🔖 tutoriels développement web jamstack 💬 FR ( EN )

Dans les temps anciens, pour télécharger mon site web BestKatie.com vers son serveur, j’ai composé à la main un dossier de fichiers du type .html pour servir comme des « pages » du site. Je ne veux jamais plus répéter un tel effort.

Lire plus

Qu'est-ce que l'hébergement web statique ?

18 Aug 2020 🔖 tutoriels développement web jamstack 💬 FR ( EN )

Avant de devenir développeuse, j’ai eu un site web personnel. Disons que c’était sur http://www.BestKatie.com. Je ne l’ai pas construit avec un constructeur de site web tel que Squarespace ou Wix.

Lire plus

What is a static site generator?

18 Aug 2020 🔖 tutorials web development jamstack 💬 EN ( FR )

In ancient times, I’d hand-write a folder full of .html-typed files and upload them to a directory katie on a web server, where they’d become my site’s “web pages.” I never want to do that again.

Continue Reading

What is static web hosting?

18 Aug 2020 🔖 tutorials web development jamstack 💬 EN ( FR )

Long before becoming a programmer, I had a personal web site. I was definitely already a nerd. Let’s say it was at http://www.BestKatie.com. I didn’t make it with a site builder like Squarespace or Wix.

Continue Reading