Modernize or Die® - CFML News for April 19th, 2022 - Episode 144

Gavin Pickin and Eric Peterson host the this weeks CFML News Podcast. They let you know the call for speakers for Into the Box Call has been extended. Don't miss out. They talked about Mid Michigans CFUG presentation on Vue 3, They talked about Ortus's April Webinar by Eric Peterson on cbSecurity: Passwords, Tokens, and JWTs... as well as Hawaii CFUG on ORM and the workshops and webinars from Adobe. They discuss the some upcoming conferences, including some dates for ITB later in the year, including early bird tickets for ITB... and the semi Official ish dates for CF Summit which will be in person this year... and That conference where Daniel Garcia will be speaking!!! They spotlight a lot of great blog posts, tweets, videos and podcasts, too many to list, so listen to the show.  They announce some jobs from and on the web. They show off the ForgeBox module of the Week - sqlFormatter by Michael Born with Ortus Solutions - A CFML wrapper for the Vertical Blank sql-formatter java library. This week's VS Code Tip of the week is R in VS Code# - This VS Code extension provides support for the R programming language, including features such as extended syntax highlighting, R language service based on code analysis, interacting with R terminals, viewing data, plots, workspace variables, help pages, managing packages, and working with R Markdown documents. They thanked all their Patreons - they talked a little information about perks for their Patreon supporters, including Annual Memberships with a discount. For the show notes - visit the website Music from this podcast used under Royalty Free license from SoundDotCom and BlueTreeAudio
2022-04-19 Weekly News - Episode 144

Watch the video version on YouTube at


Gavin Pickin - Senior Developer at Ortus Solutions
Eric Peterson - Senior Developer at Ortus Solutions

Thanks to our Sponsor - Ortus Solutions

The makers of ColdBox, CommandBox, ForgeBox, TestBox and all your favorite box-en out there. 
A few ways  to say thanks back to Ortus Solutions:
  • Like and subscribe to our videos on YouTube. 
  • Help ORTUS reach for the Stars - Star and Fork our Repos
  • Star all of your Github Box Dependencies from CommandBox with 
  • Subscribe to our Podcast on your Podcast Apps and leave us a review
  • Sign up for a free or paid account on CFCasts, which is releasing new content every week
  • Buy Ortus’s Book - 102 ColdBox HMVC Quick Tips and Tricks on GumRoad (
Patreon Support

We have 35 patreons providing 92% of the funding for our Modernize or Die Podcasts via our Patreon site:

News and Events

Last chance for ITB CFP - Into the Box 2022 CFP

Supposed to Close April 17th, but the form is still up there… go submit now - we have extended it until April 30th!!!
Into the Box will be live in Houston in September 2022.  We want you to speak there! Topic submission closes at midnight April 30th, 2022

CFML Community Submissions - Curl Converter by Scott Steinbeck

Convert curl commands to Python, JavaScript, PHP, R, Go, Rust, Elixir, Java, MATLAB, Dart, CFML, Ansible URI, Strest or JSON and now CFML.
We need more of these tools pages to include CFML - like the QuickRef that James Moberg mentions on Twitter (talk about later)
Pull request that made it happen:

HostMedia - Released an Update to CFManager

We've released a new update to our CFManager @cPanel plugin, improvements include UX tweaks, option to support UTF8 connection strings and a new dedicated documentation website at

Mid-Michigan CFUG - John Farrar is presenting on 13 ways to modernize with Vue 3

4/19/2022 - 7 pm eastern time.
Learn everything that is new and how to transition to Vue 3.
Meeting URL:

Ortus Webinar - April - cbSecurity: Passwords, Tokens, and JWTs with Eric Peterson

April 29th 2022
11:00 AM Central Time (US and Canada)
Learn how to integrate cbSecurity into your application whether you are using passwords, API tokens, JWTs, or a combination of all three!
More Webinars:

Hawaii ColdFusion Meetup Group - Using ColdFusion ORMs with Nick Kwiatkowski

Friday, April 29, 2022
4:00 PM to 5:00 PM PDT
The ColdFusion language introduced the concept of ORM (Object Relation Mappings) to allow developers to be able to do database work without having to write database-dependent SQL.

Nick Kwiatkowski is an adjunct professor at Michigan State University, a member of the Mid-Michigan CFUG, and Apache Foundation Member. His day job also includes managing the telecommunications platforms at MSU as well as managing a variety of applications on campus. He has been a ColdFusion developer for nearly 25 years and an instructor for 15.

Adobe Workshops

Join the Adobe ColdFusion Workshop to learn how you and your agency can leverage ColdFusion to create amazing web content. This one-day training will cover all facets of Adobe ColdFusion that developers need to build applications that can run across multiple cloud providers or on-premise

10:00 AM PDT
Adobe ColdFusion Truths
Mark Takata

9:00 AM CET
Adobe ColdFusion Workshop
Damien Bruyndonckx (Brew-en-dohnx)

Full list -

CFCasts Content Updates

Just Released
Coming Soon
  • More… Gavin Pickin - Publish Your First ForgeBox Package

Conferences and Training

ICYMI - LAST WEEK - DevNexus 2022 - The largest Java conference in the US

April 12-14, 2022
Atlanta, GA
Brad & Luis will be speaking
Luis - Alpine.js: Declare and React with Simplicity
Brad - What's a Pull Request? (Contributing to Open Source)
They really enjoyed it
Ray Camden was tweeting about Luis’s Alpine session, he might love it :)


May 10, 2022
Free Online Virtual Conference
DockerCon will be a free, immersive online experience complete with Docker product demos , breakout sessions, deep technical sessions from Docker and our partners, Docker experts, Docker Captains, our community and luminaries from across the industry and much more. Don’t miss your chance to gather and connect with colleagues from around the world at the largest developer conference of the year. Sign up to pre-register for DockerCon 2022!

US VueJS Conf

Beach. Code. Vue.
Workshop day: June 8
Main Conference: June 9-10

That Conference

Howdy. We’re a full-stack, tech-obsessed community of fun, code-loving humans who share and learn together.
We geek-out in Texas and Wisconsin once a year but we host digital events all the time.

For a limited time all monthly THAT Online events are free and do not require a ticket to participate.
Read more at: on THAT.
There have webinars too

A four-day summer camp for developers passionate about learning all things mobile, web, cloud, and technology.

Our very own Daniel Garcia is speaking there

CF Summit

In person at Las Vegas, NV in October 2022!
Official-”ish” dates:
Oct 3rd & 4th - CFSummit Conference
Oct 5th - Adobe Certified Professional: Adobe ColdFusion Certification Classes & Tests

Into The Box 2022

Solid Dates - September 2022
One day workshops before the two day conference!
Early bird pricing available until April 30, 2022

Call for Speakers:

Conference Website:

Into the Box Latam 2022

Tentative dates - Dec 1-2


Still waiting as well.

More conferences

Need more conferences, this site has a huge list of conferences for almost any language/community.

Blogs, Tweets, and Videos of the Week


4/18/22 Tweet - Ben Nadel - Lucee thinks 2.1 million items might be too many???
Apparently, the #Lucee #CFML server isn't happy taking an array of 2.1 M items and splitting it up into chunks of 100. I had NO IDEA that the algorithm I wrote would ever encounter an array with 2M items in it 😱 😱 😱 😱  Time to rework algorithm on new assumptions.

4/18/22 Blog - Ben Nadel - On Always Returning Collections From Data Access Layers (DAL) In ColdFusion
In my ColdFusion applications, I always have a "Data Access Layer," often referred to as a "DAL". This layer abstracts the persistence mechanisms for the application; and, encapsulates the complexities of interacting with low-level data inputs and outputs (I/O). While I love using a DAL, I've never felt confident in how I manage requests for records with a unique identifier. And, in fact, my approach changes with new implementations. This weekend, however, after listening to the JS Party episode on Postgres.js, I've decided to always return some form of collection from the data access layer in my ColdFusion applications.

4/15/22 Blog - Ben Nadel - Instrumenting Cache Hits And Misses With FusionReactor Metrics In ColdFusion 2021
Last month, I mentioned that I cache a lot of data in my ColdFusion blog. And, that FusionReactor gave me peace-of-mind regarding resource consumption in the JVM. For funzies, I thought I would take that one step further and use FusionReactor's custom metrics aggregation to track cache hits and cache misses for incoming requests. To do this, I had to refactor some of my ColdFusion 2021 code to prefer composition of inheritance.

Adam Cameron Corner

4/15/22 Blog - Adam Cameron - CFML: implementing dependency injection in a CFWheels web site
Recently I wanted to abstract some logic out of one of our CFWheels model classes, into its own representation. Code had grown organically over time, with logic being inlined in functions, making a bunch of methods a bit weighty, and had drifted well away from the notion of following the "Single Responsibility Principle". Looking at the code in question, even if I separated it out into a bunch of private methods (it was a chunk of code, and refactoring into a single private method would not have worked), it was clear that this was just shifting the SRP violation out of the method, and into the class. This code did not belong in this class at all. Not least of all because we also needed to use some of it in another class. This is a pretty common refactoring exercise in OOP land.

4/17/18 Blog - Adam Cameron - A day in the life of trying to write a blog article in the CFML ecosystem
This is not the article I intended to write today. That article was gonna be titled "CFML: Adding a LogBox logger to a CFWheels app via dependency injection", but I'll need to get to that another day now.
Here's how far that article got before the wheels fell off:

4/18/22 Blog - Adam Cameron - CFML: Adding a LogBox logger to a CFWheels app via dependency injection
This follows on from CFML: implementing dependency injection in a CFWheels web site. In that article I got the DI working, but only with a test scenario. For the sake of completeness, I'm gonna continue with the whole point of the exercise, which is getting a logger service into my model objects, via DI.

CFML Community Corner

4/13/22 Blog - Zac Spitzer - Lucee - New ESAPI function sanitizeHTML() ESAPI
Sanitizes unsafe HTML input and removes elements and attributes like JavaScript, onclick, etc.
Based on GitHub - OWASP/java-html-sanitizer - A fast and easy to configure HTML Sanitizer written in Java which lets you include HTML authored by third-parties in your web application while protecting against XSS.

4/13/22 Tweet - James Moberg - Any #ColdFusion developers have a cheatsheet for ?
Any #ColdFusion developers have a cheatsheet for ?
For #cfml syntax & examples, I usually reference and recall visiting in the past.

4/19/22 Blog - Charlie Arehart - New updates released for Java 8, 11, 17, and 18 as of Apr 2022
New JVM updates have been released today (Apr 19, 2022) for the current long-term support (LTS) releases of Oracle Java, 8, 11, and 17, as well as the new interim update 18. (Note that prior to Java 9, releases of Java were known technically as 1.x, to 8 is referred to in resources below as 1.8.)
The new updates are 1.8.0_331, (aka 8u331), 11.0.15, 17.0.3, and 18.0.1 respectively).
For more on them, including information on the security fixes and bug fixes they each contain, see the Oracle resources I list below, as well as some additional info I offer for if you may be skipping to this from a JVM update from before Apr 2021. I also offer info for Adobe ColdFusion users on where to find the updated Java versions, what JVM versions Adobe CF supports, and more.

4/13/22 Tweet - Brad Wood - Ortus - Everything in software architecture is a trade-off.  #devnexus #keynote #cfml


Several positions available on
Listing over 74 ColdFusion positions from 43 companies across 36 locations in 5 Countries.

5 new job listed

Full-Time - Senior ColdFusion/Lucee Engineer (Remote) at Remote - United States
Apr 19

Full-Time - Full Stack Developer ColdFusion at Aurora, CO - United States
Apr 13

Full-Time - ColdFusion programmer at Washington, DC - United States
Apr 12

Full-Time - Technical Operations (Coldfusion)Engineer at New York, NY - United States
Apr 12

Full-Time - Technical Operations (Coldfusion)Engineer at United States - United States
Apr 12

Other Job Links

Ortus Solutions

There is a jobs channel in the box team slack now too

ForgeBox Module of the Week


by Michael Born with Ortus Solutions

A CFML wrapper for the Vertical Blank sql-formatter java library.
Basic formatting is done via the format() method
For database-specific syntax, you can set the dialect using .of():

Supported dialects:
  • sql - Standard SQL
  • mariadb - MariaDB
  • mysql - MySQL
  • postgresql - PostgreSQL
  • db2 - IBM DB2
  • plsql - Oracle PL/SQL
  • n1ql - Couchbase N1QL
  • redshift - Amazon Redshift
  • spark - Spark
  • tsql - SQL Server Transact-SQL

FYI - This allows the CBDebugger to not require hibernate for formatting sql... yay.

VS Code Hint Tips and Tricks of the Week

R in VS Code#

This VS Code extension provides support for the R programming language, including features such as extended syntax highlighting, R language service based on code analysis, interacting with R terminals, viewing data, plots, workspace variables, help pages, managing packages, and working with R Markdown documents.

There is a new R in Visual Studio Code topic describing R programming language support in VS Code with the R extension. The R extension includes rich language features such as code completions and linting as well as integrated R terminals and dedicated workspace, data, and plot viewers.

Thank you to all of our Patreon Supporters

These individuals are personally supporting our open source initiatives to ensure the great toolings like CommandBox, ForgeBox, ColdBox,  ContentBox, TestBox and all the other boxes keep getting the continuous development they need, and funds the cloud infrastructure at our community relies on like ForgeBox for our Package Management with CommandBox.

You can support us on Patreon here

  • Don’t forget, we have Annual Memberships, pay for the year and save 10% - great for businesses.
  • Bronze Packages and up, now get a ForgeBox Pro and CFCasts subscriptions as a perk for their Patreon Subscription.
  • All Patreon supporters have a Profile badge on the Community Website
  • All Patreon supporters have their own Private Forum access on the Community Website
  • John Wilson - Synaptrix 
  • Eric Hoffman
  • Gary Knight
  • Mario Rodrigues
  • Giancarlo Gomez
  • David Belanger
  • Dan Card
  • Jonathan Perret
  • Jeffry McGee - Sunstar Media6
  • Dean Maunder
  • Joseph Lamoree
  • Don Bellamy
  • Jan Jannek 
  • Laksma Tirtohadi
  • Carl Von Stetten
  • Jeremy Adams
  • Didier Lesnicki
  • Matthew Clemente
  • Daniel Garcia
  • Scott Steinbeck - Agri Tracking Systems
  • Ben Nadel 
  • Brett DeLine
  • Kai Koenig
  • Charlie Arehart
  • Jonas Eriksson
  • Jason Daiger
  • Shawn Oden
  • Matthew Darby
  • Ross Phillips
  • Edgardo Cabezas
  • Patrick Flynn
  • Stephany Monge
  • John Whish
  • Kevin Wright
  • Peter Amiri

You can see an up to date list of all sponsors on Ortus Solutions' Website

★ Support this podcast on Patreon ★

Switch to Modernize or Die ® Podcast - SoapBox Edition - Switch to Modernize or Die ® Podcast - Conference Edition

Powered by

Music from this podcast used under Royalty Free license from SoundDotCom and BlueTreeAudio

© 2019 Ortus Solutions