Français
Presentations About Resources Store

Salesforce, Python, SQL, & other ways to put your data where you need it -- a bilingual blog in English & French

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.

Pssst -- too much screen time? My XML & JSON (vs. CSV) series is now a printable book: Intro to XML, JSON, & YAML

I worked in the best parts of my Forcelandia talk about how familiarizing yourself with these file formats can help you even if you're not a programmer and added an exclusive book-only section on YAML.

SPECIAL: MAKE ME SPEND MY MONEY. Celebrating this release, all proceeds for the first two weeks are going to charities I adore.

Book ad

Configuring public-private key pairs so 2 Linux machines can talk

16 Sep 2020 🔖 linux tutorials integration 💬 EN

Recently, I needed a sysadmin colleague to set up an ETL tool to make Linux Server #1 (on which the ETL tool runs) send a file to, and execute commands on, Linux Server #2. I had the privilege of watching and taking notes.

Continue Reading

Study plan for GraphQL in Salesforce Marketing Cloud

15 Sep 2020 🔖 marketing cloud salesforce databases graphql api integration tips 💬 EN

I’ve been collaborating again with Salesforce Marketing Cloud expert Kyle Griffin, this time thinking through what it would require to build SFMC data extensions from queries against an Oracle database.

Continue Reading

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 today, because September 4-18, to celebrate the release, I'm donating all proceeds from you to great charities and matching them out of my own pocket.

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