2022-03-08 Weekly News - Episode 138

Watch the video version on YouTube at https://youtu.be/DO6_4ccmyVg


Hosts:
 
Luis Majano- CEO of Ortus Solutions
Gavin Pickin - Senior Developer for Ortus Solutions


Thanks to our Sponsor - Ortus Solutions

The makers of ColdBox, CommandBox, ForgeBox, TestBox and almost every other Box out there. 
A few ways  to say thanks back to Ortus Solutions:

 
Patreon Support

We have 36 patreons providing 96% of the funding for our Modernize or Die Podcasts via our Patreon site: https://www.patreon.com/ortussolutions.

 
Modernize Spotlight

Awesome shoutout to Ortus in the Boxteam Slack from Don Ballamy

Shoutout to the Ortus team!  A few weeks ago we had a major security incident on our network at Azure (not CF related) that caused us to rebuild our entire network of virtual machines.  We hired a security firm to oversee the rebuild and one of our legacy API apps running on CF 11 was flagged and had to be upgraded to CF 2021 (we had planned to, but time had been limiting it).  I spent a few days trying, this app was originally written in ColdFusion 8, but then gave up and decided to rewrite the entire API application using ColdBox 6.  I was able to rebuild the entire application in 3 days.  Without the tools you guys create and work on a daily basis, this would not have been possible.  Thank You!
https://boxteam.slack.com/archives/C0532LKQ3/p1646535163494699



News and Events


Built with ColdFusion CFML

This repo is a community repo to list and showcase companies, sites and technologies powered by ColdFusion (CFML) and several Ortus Products.
To contribute, fork and star the project. Then add your own organization file in the orgs directory and then append the name of that file ( excluding the extension ), in to the cfml-rocks.json array of orgs. You may use the schema below for reference. Send us your pull request and once validated, we will add it to the repo and site.
https://github.com/Ortus-Solutions/built-with-cfml-box/


CFML Spreadsheet v3.4.0 released

Spreadsheet-CFML 3.4.0 released with a new sheetInfo() method to return properties of a specific sheet within your workbook
https://github.com/cfsimplicity/spreadsheet-cfml


Ortus Webinar - March - ForgeBoxication with Gavin Pickin

March 25th, 2022 Time: 11:00 AM Central Time (US and Canada)
ForgeBox is CFML's package management system, and in this webinar you will learn how you can use it with any cfml app you have. You'll learn how to use ForgeBox packaged in your app, commit your own code to ForgeBox, and if we have time we might even make your code into a ColdBox module.
Register today: https://us02web.zoom.us/meeting/register/tZwkduGurDgoHNf4sljBngAFLpoNSNLkzom3
More Webinars: https://www.ortussolutions.com/events/webinars


Hawaii CFUG User Group - Moving your Legacy ColdFusion application to Modern CFML with Mark Takata

March 24th, 2022
1:00pm Hawaiian Time
We’ve all seen old legacy code in our ColdFusion applications.
How do you move that legacy code to modern CFML with easier maintenance and deployment, fewer bugs, and streamlined code?
Why Move to Modern CFML
Most of us understand that moving our legacy applications to modern CFML is smart.

https://hawaiicoldfusionusergroup.adobeconnect.com/legacy/


Happy Birthday Docker - Docker Community All Hands

Thursday, March 31, 2022 | 8:00am - 11:00am PT
Join us in celebrating Docker’s 9th birthday at our next Community All Hands! This virtual event is a unique opportunity for the community to come together with Docker staff to learn, share and collaborate about all things Docker.
https://www.docker.com/event-community-all-hands


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

WEDNESDAY, MARCH 9, 2022
9:00 AM CET
Damien Bruyndonckx
https://workshop-cf-adobe.meetus.adobeevents.com/

THURSDAY, APRIL 21, 2022
9:00 AM CEST
Damien Bruyndonckx
https://adobe-workshop-coldfusion.meetus.adobeevents.com/

FREE :)
Full list - https://meetus.adobeevents.com/coldfusion/




CFCasts Content Updates

https://www.cfcasts.com

Just Released

Conferences and Training


Docker Community All Hands

Thursday, March 31, 2022 | 8:00am - 11:00am PT
Join us in celebrating Docker’s 9th birthday at our next Community All Hands! This virtual event is a unique opportunity for the community to come together with Docker staff to learn, share and collaborate about all things Docker.
https://www.docker.com/event-community-all-hands 



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)
https://devnexus.com/


DockerCon

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!
https://www.docker.com/dockercon/


US VueJS Conf

FORT LAUDERDALE, FL • JUNE 8-10, 2022
Beach. Code. Vue.
Workshop day: June 8
Main Conference: June 9-10
https://us.vuejs.org/


Into The Box 2022 - Tentative dates - September 27-30


Into the Box Latam 2022 - Tentative dates - Dec 1-2


CF Summit - Still waiting on news from Adobe.


More conferences

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



Blogs, Tweets, and Videos of the Week


3/8/22 - Blog - Ben Nadel - Using Common Table Expressions (CTE) To Create Derived Tables In MySQL 8
Now that my ColdFusion blog is running on MySQL 8.0.28, I get to leverage a number of new features related to derived tables. Yesterday, I looked as using LATERAL derived tables to gather row-specific data. This morning, I want to look at using something called Common Table Expressions (CTE) in order to create derived tables that are factored-out of the main SQL query and placed within a named, temporary result set. This doesn't change the derived table, functionally speaking; but, I believe it does make the SQL query easier to read.
https://www.bennadel.com/blog/4223-using-common-table-expressions-cte-to-create-derived-tables-in-mysql-8.htm


3/7/22 - Charlie Arehart - FusionReactor 8.7.7 released, enhances the recent DB and API Time feature
I had blogged in early November about how FusionReactor 8.7.4 had added at that time a new feature where it lists on request summary pages the DB and API Time of each request, so you could readily tell how much of a request's duration might have been caused by time spent waiting for either of those kinds of resources.
Now in 8.7.7, which was released last week (Mar 1), the benefit of that feature has been extended so that a) the same information is written to both the FusionReactor request logs and b) it's also now available in FR crash protection alert emails. In this post, I'll show you examples of what's changed for each, and I'll note another related changes in the prior FR update, 8.7.6.
https://www.carehart.org/blog/client/index.cfm/2022/3/7/fusionreactor_8_7_7_enhances_db_and_api_time_feature


3/6/22 - Tweet - John Barret - University of Hawaii using CFLM in 2005
How the University of Hawaii used to use #ColdFusion in ICS 415, a class I took way back in 2005. http://nordbotten.com/articles/ColdFusion.pdf
https://twitter.com/johnny_barrett/status/1500677296499269633
https://twitter.com/johnny_barrett


3/5/22 - Blog - Ben Nadel - Tracking Database Schema And Schema Migrations In Git Version Control
A decade ago, I attended a presentation from Tim Cunningham titled "Version Control on the Database: the Final Frontier". At the time, I was relatively new to version control. At InVision, we had just started using git and GitHub; and, before that, I had only dabbled briefly with SVN (Subversion). I was still struggling to wrap my head around branching and merging and rebasing. So, when Tim suggested that we should also be storing our "database" in version control, I simply wasn't ready to hear it. I mean, it sounded awesome; but, due to my lack of experience, I couldn't connect - at a practical level - with anything he was saying. Cut to 2022 and I can't imagine not tracking our database schema and schema migrations in version control!
https://www.bennadel.com/blog/4221-tracking-database-schema-and-schema-migrations-in-git-version-control.htm


3/4/22 - Blog - Ben Nadel - Moving MySQL To A Per-Application Datasource In ColdFusion 2021
Over the weekend, after my ColdFusion blog was accidentally upgraded from MySQL 5.0.10 to 8.0.28, I had to scurry and update the datasource configuration in both my production environment as well as in my local Docker development environment. And it occurred to me that manually updating the MySQL datasource in the ColdFusion Administrator represented a huge point of human failure. And, more than that, there was no record of these changes being made; which meant that undoing said changes would be quite challenging. In a modern application context, this is highly disturbing! My application's datasource configuration workflow should be in source-control. As such, I've decided to move my blog to a per-Application datasource.
https://www.bennadel.com/blog/4220-moving-mysql-to-a-per-application-datasource-in-coldfusion-2021.htm


3/4/22 - Blog - Mark Takata - Adobe - Trying out Redis for ColdFusion caching
I had a customer reach out to me last week about moving their session storage to Redis, so I decided to play around a bit with it. I’d never really had the need to utilize Redis or any of the other caches, as the companies I’d worked with used the local CF cache or other solutions. So I saw this as an opportunity to play and learn.
https://coldfusion.adobe.com/2022/03/trying-redis-coldfusion-caching/


3/4/22 - Blog - Nolan Erck - South of Shasta - Why Do Some CFML Jobs Require Degrees?
Earlier today in the ColdFusion Programmers forum on Facebook somebody asked (I’m paraphrasing a little) why do some ColdFusion jobs require a Computer Science degree when they don’t teach CFML in college?
I have 2 answers:
1 - Actually, there is (or was?) a ColdFusion curriculum written up and made available for colleges that want to teach ColdFusion in the classroom. I’m unclear on the current status of this, but my guess is someone on the Adobe ColdFusion team would have more info (Mark or Kishore probably).
2 - The longer answer is, because good Computer Science degrees are not language specific. Good degrees (and good software developers) focus on constructs, concepts, and higher level skills. They don’t spend (much) time worrying about the difference between a CFInclude and a Custom Tag...but they do teach you why a programming construct that leaks data (CFInclude) would be less appropriate in most situations than one that promotes better programming practices (CFFunction, CFCs, and even Custom Tags are better than CFInclude in that regard).
https://southofshasta.com/blog/why-do-some-cfml-jobs-require-degrees/


3/3/22 - Tweet - Brad Wood - Ortus Solutions - CFML Queries have member functions like arrays and structs
This came up today-- you may not realize CFML queries have the same each(), map(), reduce(), filter() member functions as arrays and structs. Your closure receives a struct representing each query row. Super easy to use for manipulating queries.
https://twitter.com/bdw429s/status/1499534951699603456
https://twitter.com/bdw429s


3/2/22 - Blog - Brad Wood - Ortus Solutions - CommandBox/Undertow Server scanned with OWASP ZAP
We had a user ask recently if we had run any automated scanners against CommandBox servers to verify they were secure. While we’ve taken care to make CommandBox servers secure by default and I’ve helped many clients who have run scans against their own CommandBox-hosted apps, Ortus had never performed any scans just against CommandBox itself. I grabbed the OWASP ZAP scanner 4, which is a free scanning tool that checks for a bunch of different vulnerabilities, specifically HTTP header related. I figured it would be nice to post what I did here for the community to see.
https://community.ortussolutions.com/t/commandbox-undertow-server-scanned-with-owasp-zap/9134


3/2/22 - Tweet - Brad Wood - Ortus Solutions - SQL Server Monitor
I've tossed the (very old) code for a little CF tool/site I wrote years ago to visually monitor all the running process on a SQL Server (ONTO GITHUB).  It's handy for finding processes with locks blocking other processes.  It's rough, but works. Feel free to play:
https://github.com/bdw429s/SQL-Server-Monitor
https://twitter.com/bdw429s/status/1498812367605538816
https://twitter.com/bdw429s



CFML Jobs

Several positions available on https://www.getcfmljobs.com/
Listing over 54 ColdFusion positions from 33 companies across 32 locations in 5 Countries.


6 new jobs listed


Full-Time - ColdFusion programmer at Washington, DC - United States
Mar 08
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-programmer-at-Washington-DC/11441

Full-Time - Full Stack Developer (Remote) at Sacramento, CA - United States
Mar 07
https://www.getcfmljobs.com/viewjob.cfm?jobid=11440

Full-Time - Coldfusion Developer at Connecticut - United States
Mar 05
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-Connecticut/11438

Full-Time - IT Web Developer at Everett - United States
Mar 04
https://www.getcfmljobs.com/viewjob.cfm?jobid=11437

Full-Time - Senior ColdFusion Developer - GeoNorth Information Systems a.. - United States
Mar 02
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Senior-ColdFusion-Developer-GeoNorth-Information-Systems-at-Alaska/11435

Full-Time - Database Administrator with ColdFusion at Remote - United States
Mar 02
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Database-Administrator-with-ColdFusion-at-Remote/11436


Other Job Links

Ortus Solutions
https://www.ortussolutions.com/about-us/careers


Everett Community College
https://employment.everettcc.edu/postings/5300


The Consortium, Inc
https://jobs.crelate.com/portal/consortium/job/ok4b6rcj95g1rhscawespxcdjy



ForgeBox Module of the Week

Sentry by Ortus Solutions

This module connects your CFML application to send bug reports to Sentry (https://sentry.io)
If your app uses neither ColdBox nor LogBox, you can still instantiate the SentryService and use it directly so long as you prep it with the settings it needs.
Methods include captureMessage, captureException, capture… with the ability to use levels, tags, auto pass cgi variables, and much more.
Great free tier options for getting started with smaller apps.
https://www.forgebox.io/view/sentry


VS Code Hint Tips and Tricks of the Week

File Nesting in VS Code

VS Code v1.64 was released a few days ago and it’s once again packaged with nice new features and improvements. An exciting new feature is the Side Panel that can be opened opposite to the Side Bar, i.e. the “other side of the screen”, giving you the option to have more views open at once. I can see how that can be useful on bigger screens.

Another new feature that catched my interest was the experimental support for file nesting. This feature lets you visually “nest”/group related files under a “root” file in the same directory. For example, say you have a main.ts file and next to it you have main.js, main.d.ts and main.js.map. After enabling the file nesting feature and configuring it, VS Code will visually group the main.* files under the main.ts file
https://dzhavat.github.io/2022/02/07/file-nesting-in-vs-code.html




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 https://www.patreon.com/ortussolutions

Don’t forget, we have Annual Memberships, pay for the year and save 10% - great for businesses.

Patreons

John Wilson - Synaptrix 
Eric Hoffman
Gary Knight
Mario Rodrigues
Giancarlo Gomez
David Belanger  (Bell-an-jer)
Dan Card
Jonathan Perret
Jeffry McGee - Sunstar Media6
Dean Maunder
Joseph Lamoree  (Lah-more-ee)?
Don Bellamy
Jan Jannek  (Yan Yannek)
Laksma Tirtohadi  (Lah-ksma Turt-o-hah-dee)
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  (Mongee)
John Whish
Kevin Wright
Peter Amiri

You can see an up to date list of all sponsors on Ortus Solutions' Website
https://ortussolutions.com/about-us/sponsors