2021-10-12 Weekly News - Episode 122

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

Hosts:
 

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 89% of the funding for our Modernize or Die Podcasts via our Patreon site: https://www.patreon.com/ortussolutions.
Now offering Annual Memberships, pay for the year and save 10% - great for businesses.



News and Events



CommandBox 5.4.2 Released!

There is a new update for CommandBox CLI available.  Version 5.4.2 is a patch update that contains a few bug fixes including two important ones.
There is a fix for a regression introduced in 5.4.0 where updating the version of a CF engine doesn't work without forgetting the server first.
There is also an important security improvement to CommandBox servers.  Thanks to Abram Adams for reporting this to Ortus so we could address it. 
https://www.ortussolutions.com/blog/commandbox-542-released


CFML REPO - New Google Drive Link fixes Security updates

Google rolls out some security changes / updates recently and all of a sudden Gavin got inundated with emails asking for access to the CFML Repo files that people needed.
It’s awesome to see so many people using it.
After some researching, Gavin found the issue was a google security update, and required changed to drive folders and files. There is a new link released on the website, so hopefully that should solve all the access issues people were having.
http://www.cfmlrepo.com/


More Info on the CF9/8 Ransomware Attack

If you're running CF9 or 8, beware: a recent spate of ransomware attacks have occurred, hitting such old CF servers that were not updated (in ways offered by Adobe in 2010!) This news has been reported in various security industry press, but Charlie wants to share here more that they generally did not.
https://www.carehart.org/blog/client/index.cfm/2021/10/11/beware_ransomware_attacks_cf9_and_earlier/


ICYMI - Into the Box 2021 - Videos are now available
Videos are now available on CFCasts!
https://cfcasts.com/series/into-the-box-2021

Free for subscribers; Free for ITB 2021 attendees; available as a one-time purchase for $199.
If you bought a ticket to Into the Box 2021 and have not received a coupon for access to the videos on CFCasts, please contact us from the CFCasts support page. https://cfcasts.com/support


ICYMI - ContentBox v5 released

We are incredibly excited to announce the release of the ContentBox Modular CMS v5 series. This has been a work over 1 year with a complete refocus and rearchitecturing of the core to take ContentBox to the next 10 years. It is also great to note that we are Professional Open Source, FREE, FOREVER. This series includes tons of great features and updates that will take your content management to the next level. From multi-site support, a companion CLI, to a complete Headless CMS deployment, your will be able to deliver your projects in no time.

Blog post - https://www.ortussolutions.com/blog/contentbox-v5x-released
Marketing site - https://www.contentboxcms.org/
Docs - https://contentbox.ortusbooks.com/v/v5.x/


ICYMI - Modernize Or Die Podcast - SoapBox Edition - Relaunching Oct 7th

Luis Majano is hosting a series of Community Members over the coming months.
Interview format.
Several episodes are recorded and prepped for release.
https://soapbox.modernizeordie.io/


Ortus Webinar for October - Gavin Pickin - Building Quick APIs - the extended version

In this session we will use ColdBox’s built in REST BaseHandler, and with CBSecurity and Quick ORM we will set up a secure API using fluent query language - and you’ll see how quick Quick development can be!
https://www.ortussolutions.com/events/webinars


Hacktoberfest 2021

Support open source throughout October!
Hacktoberfest encourages participation in the open source community, which grows bigger every year. Complete the 2021 challenge and earn a limited edition T-shirt.
GIVING TO OPEN SOURCE
Open-source projects keep the internet humming—but they can’t do it without resources. Donate and support their awesome work.
TREES NOT TEES
Rather than receive t-shirts as swag, you can choose to have a tree planted in your name and help make Hacktoberfest 2021 more carbon neutral.
To win a reward, you must sign up on the Hacktoberfest site and make four pull requests on any repositories classified with the 'hacktoberfest 'topic on GitHub or GitLab by October 31.
If an Ortus Solutions repo that you want to contribute to is not marked with the `hacktoberfest` topic, please let us know so we can fix it.
https://hacktoberfest.digitalocean.com/


Adobe 1 Day Workshop - Adobe ColdFusion Workshop with Damien Bruyndonckx

Wed, November 10, 2021
09:00 - 17:00 CEST EUROPEAN
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.
https://coldfusion-workshop.meetus.adobeevents.com/



CFCasts Content Updates

https://www.cfcasts.com

Just Released

Send your suggestions at https://cfcasts.com/support



Conferences and Training


VueJS Live

October 20-21, 2021 - Online and London, Uk
Remote and In Person Tickets Available
https://vuejslive.com/


Microsoft Ignite

November 2–4, 2021
Opportunity awaits, with dedicated content spotlighting Microsoft Business Applications and Microsoft Security.
https://myignite.microsoft.com/home


Adobe ColdFusion Summit 2021

December 7th and 8th - Virtual
Speakers are finalized and some Speakers and some session descriptions are now on the site
Register for Free - https://cfsummit.vconfex.com/site/adobe-cold-fusion-summit-2021/1290
Blog - https://coldfusion.adobe.com/2021/09/adobe-coldfusion-summit-2021-registrations-open/


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

Blog - Charlie Arehart - Beware of ransomware attacks happening on CF9 and earlier
If you're running CF9 or 8, beware: a recent spate of ransomware attacks have occurred, hitting such old CF servers that were not updated (in ways offered by Adobe in 2010!) This news has been reported in various security industry press, but Charlie wants to share here more that they generally did not.
https://www.carehart.org/blog/client/index.cfm/2021/10/11/beware_ransomware_attacks_cf9_and_earlier/


Video - Scott Hanselman - Windows 11 runs Graphical Linux Apps out of the box with WSLg
Windows 11 runs Graphical Linux Apps out of the box with WSLg! Type "wsl --install" from the Windows Terminal command prompt and go go go! We'll see VS Code, WSLg, The Gimp, and much more.
https://youtu.be/b1YBx1L8op4


Blog - Ben Nadel - CFQueryParam Value Attribute Seamlessly Handles Arrays In Lucee CFML 5.3.7.47
This almost isn't worth blogging since it's clearly stated in the Lucee CFML docs. But, since some people don't make it a habit to read documentation, I wanted to share this fact more widely and with much excitement: the CFQueryParam tag accepts arrays for its value attribute. And, when given an array, the tag will seamless convert the parameter into a list-based parameter. This is just one of the many developer ergonomic niceties that comes with Lucee CFML.
https://www.bennadel.com/blog/4128-cfqueryparam-value-attribute-seamlessly-handles-arrays-in-lucee-cfml-5-3-7-47.htm


Blog - Ortus Solutions - CommandBox 5.4.2 Released!
There is a new update for CommandBox CLI available.  Version 5.4.2 is a patch update that contains a few bug fixes including two important ones.
There is a fix for a regression introduced in 5.4.0 where updating the version of a CF engine doesn't work without forgetting the server first.
There is also an important security improvement to CommandBox servers.  Thanks to Abram Adams for reporting this to Ortus so we could address it. 
https://www.ortussolutions.com/blog/commandbox-542-released


Blog - Ben Nadel - Using WHERE TRUE To Create Dynamic, High-Performance SQL Queries In MySQL 5.7.32 And Lucee CFML 5.3.8.201
When I write ColdFusion applications, I almost always create a "Data Access Layer" (DAL) so that my business logic isn't intermingled with my SQL query syntax. And, to make this DAL more flexible, I tend to create some sort of "By Filter" function that allows me to query a given table using a variety of WHERE conditions. In order to make this query "simple", I'll start it with a WHERE TRUE condition so that every subsequent condition can uniformly start with AND. I recently read something somewhere (source forgotten) that indicated such an approach would cause index issues; however, this does not jive with what I read in High Performance MySQL. As such, I wanted to put together a quick exploration to see how using WHERE TRUE would affect MySQL's query planner outcomes.
https://www.bennadel.com/blog/4127-using-where-true-to-create-dynamic-high-performance-sql-queries-in-mysql-5-7-32-and-lucee-cfml-5-3-8-201.htm


Tweet - Brad Wood - Playwright Website Screenshots Task Runner
@uniquetrio2000 asked me to help figure out the Playwright Java lib which lets you take screenshots of websites.  It works pretty well once it downloads all its assets. Here's a stand-alone proof of concept in a CommandBox Task Runner: https://gist.github.com/bdw429s/12cf16ae1d232688466897d8d073ec54 #CFML #ColdFusion
https://twitter.com/bdw429s/status/1445593787447726083
https://twitter.com/bdw429s


CFML Jobs

Several positions available on https://www.getcfmljobs.com/
Listing over 211 ColdFusion positions from 98 companies across 121 locations in 5 Countries.

9 new jobs listed

Full-Time - Web Developer / ColdFusion Programmer at South Bend, IN - United States
Posted Oct 12
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Web-Developer-ColdFusion-Programmer-at-South-Bend-IN/11359

Full-Time - ColdFusion Developer (Senior) at McLean, VA - United States
Posted Oct 12
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-Senior-at-McLean-VA/11358

Full-Time - ColdFusion Developer at Remote - United States
Posted Oct 12
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-at-Remote/11357

Full-Time - ColdFusion Developer (Remote) at Richmond, VA - United States
Posted Oct 11
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-Remote-at-Richmond-VA/11356

Full-Time - ColdFusion Engineer at Remote - United States
Posted Oct 09
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Engineer-at-Remote/11355

Full-Time - ColdFusion Developer (Senior) at McLean, VA - United States
Posted Oct 07
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-Senior-at-McLean-VA/11354

Full-Time - Coldfusion Developer at Illinois - United States
Posted Oct 06
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-Illinois/11353

Full-Time - Apex/Oracle Forms/ColdFusion Developer at Washington, DC - United States
Posted Oct 06
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ApexOracle-FormsColdFusion-Developer-at-Washington-DC/11352

Full-Time - Coldfusion Developer at Maryland - United States
Posted Oct 05
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-Maryland/11351


ForgeBox Module of the Week

LaunchDarkly SDK

A CFML SDK for LaunchDarkly feature flags - wrapping Ben Nadel’s LaunchDarkly project.
This should run on Lucee and versions of Adobe CF modern enough to support arrow functions (2021 and 2018 Update 5+). The SDK is set up as a ColdBox module, however it will also work with WireBox standalone or just a legacy app.

https://www.forgebox.io/view/LaunchDarklySDK



VS Code Hint Tips and Tricks of the Week

Release Party for VS Code 1.61 - September 2021

With VS Code 1.61 coming out, we had a great Release Party yesterday! If you missed it, you can watch the recording on our YouTube channel.

https://youtu.be/G4jjCN8uQAg



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

Now offering Annual Memberships, pay for the year and save 10% - great for businesses.

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