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.
Drupal vs. 11ty with kittens & puppies
05 Nov 2020
On StackOverflow, Drupal user Alec asked how dynamic “list” generation worked in 11ty compared to Drupal views.
I know nothing about Drupal, but I thought perhaps I could shed some light on the impact differing content data models may have on the two web site building systems: relational (SQL) vs. object.
Movable page builder components in Sanity CMS
27 Oct 2020
Previously, I designed a data structure in the “front matter” of Markdown files that was ready to be “dragged around” a content management system – and hence a web page – by a content author, providing a Squarespace-like experience.
I’ve spent enough time dinking around in Sanity CMS that I’m ready to share how I built the same data model inside of it.
Infrastructure as code homework #2
16 Oct 2020
Live notes as I take a hands-on workshop about Azure and Terraform:
Continue ReadingAlgolia attributes are flexible
15 Oct 2020
Ohhhhh, I GET IT. There’s nowhere in Algolia’s web UI, as you create an Algolia index, to define a schema for the data you plan to send it. Why not? Because it doesn’t care. 🤯
Continue ReadingEllucian Banner fan wiki, OMG
14 Oct 2020
Why didn’t it occur to me that Higher Ed folks would be this nerdy? There’s a “fan wiki” for Ellucian Banner hosted on a web site usually meant for listing characters in TV shows and such.
Continue ReadingRe-indenting with Notepad++ regex replace
08 Oct 2020
The other day I came up with a ridiculously inefficient regex replace for Notepad++ to re-indent some code from 3 spaces per indent (my team’s standard for a certain codebase – no idea how they settled on 3) to 1 (for tight display on this blog).
Continue ReadingAnonymous PL/SQL to write a CSV from SQL
05 Oct 2020
As mentioned earlier today, I transformed Tim Hall’s Oracle PL/SQL “CSV” package into a block of anonymous PL/SQL, for times when it’s just not practical to create a “csv” package in your database. Below is my adaptation, with sample executions of it at bottom in the BEGIN
… END
block.
ORA-29283 hello world
05 Oct 2020
Recently I hit an “ORA-29283” or “invalid file operation” error when editing a long Oracle PL/SQL script. A shorter “hello world” PL/SQL script helped me narrow in on my problem.
Continue ReadingORA-29283 salut le monde
05 Oct 2020
J’ai reçu récemment un message d’erreur « ORA-29283 » (« opération non valide sur le fichier ») lorsque j’ai fait éxécuter un logiciel Oracle PL/SQL assez long. J’ai trouvé très utile un petit script genre « salut le monde ».
Lire plusSetting up Windows Store Python with Pandas in VSCode
01 Oct 2020
My beloved Spyder IDE suddenly stopped working on me, and I needed to install Python + Pandas on a new computer anyway, so I decided to explore installing Python (and various packages I use with it such as Pandas) out of the Windows Store, executing code in VSCode as an IDE.
Continue Reading