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.

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

Responsive, accessible navigation 5: HTML structure

08 Feb 2021 🔖 jamstack web development 💬 EN

Having taken apart a lot of other navbars, here’s one structure for my nav.liquid 11ty template that I think might work.

Continue Reading

Responsive, accessible navigation 4: Preventative troubleshooting

08 Feb 2021 🔖 jamstack web development 💬 EN

Before I go any further (yup, there’s still no nav data in my navbar!), I should think through some issues that might come up as I try to implement a navbar.

Continue Reading

Responsive, accessible navigation 3: Constraining width

08 Feb 2021 🔖 jamstack web development 💬 EN

Before I actually put any navigational data into my masthead, I want to play with constraining its width.

Continue Reading

Responsive, accessible navigation 2: 11ty

08 Feb 2021 🔖 jamstack web development 💬 EN

First things first: I need some data items to be in the menu. And I need some templating to turn it into basic blocks of HTML. Let’s make a little 11ty SSG project.

Continue Reading

Responsive, accessible navigation 1: Intro

08 Feb 2021 🔖 jamstack web development 💬 EN

I have a “dream nav bar” in mind, but building it is another issue. Follow me on a journey through building a minimalistic, accessible, responsive 2-level top-of-site navigation menu.

Continue Reading

Insert, update, and delete from a database to Salesforce

05 Feb 2021 🔖 architecture databases integration sql salesforce tips tutorials 💬 EN

Oracle User Group meetups attract some great DBAs and database developers. With their permission, I’d like to share a slick little Extract, Transform, Load (“ETL”) data integration pattern that DBA Ken Frank introduced to me, developed with Sidi Mohamed Cheikh Ahmed and Sue Kolles. It does a single-direction sync from Oracle into Salesforce, making sure that inserts, updates, and deletes are all propagated.

Continue Reading

5 things you need to know about Jekyll vs. 11ty Liquid includes

29 Jan 2021 🔖 jamstack web development 💬 EN

Thinking about migrating from, say, GitHub Pages-flavored Jekyll to a newer SSG? Eleventy is probably your closest bet, because it allows you to stick to the Liquid templating language you know and love. But the heart of a well-componentized site generation model, includes, works a little differently between Jekyll and 11ty.

Continue Reading

APIs are for admins: texting your colleagues with Salesforce Flow (Cactusforce 2021)

15 Jan 2021 🔖 api salesforce flow integration architecture 💬 EN

Thanks for coming to Salesforce MVP Narender Singh’s and my 6-minute lightning demo “APIs are for admins: texting your colleagues with Salesforce Flow” at Cactusforce 2021

Continue Reading