2021-11-02 Weekly News - Episode 124

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

Hosts:

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 38 patreons providing 93% 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


CFML Spreadsheet 3.1 released

Spreadsheet CFML v3.1.0 just released. Supports the latest POI 5.1.0 out today, plus minor fixes/updates.
https://github.com/cfsimplicity/spreadsheet-cfml/commit/f5698850f7691a0bf5578d77f4f3635a47b28b1c


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/


Online CF Meetup - "Migrating apps to ColdFusion 2021 from earlier versions", with Charlie Arehart
Thursday, November 4, 2021
9:00 AM to 10:00 AM PDT
While CF2021 has been out now for a year (released in Nov 2020), many orgs may only now be considering moving to it, whether from CF2018 or perhaps CF2016, CF11, CF10, or even earlier. How have the versions changed, in ways that some older code may not run on CF2021? And if you're skipping some CF version/s, what might have tripped you up in those, though not really "new" in CF2021 itself? And what can you do to mitigate such challenges?
In this session, CF troubleshooter Charlie Arehart will share from his experience helping folks make such migrations the past year (and for years with previous CF versions), whether in his role as an independent consultant or providing assistance to the CF community. He'll cover things you can consider in advance of the migration as well as things that might help during or after the migration. Most importantly, this talk will focus on the differences between CF2021 and various earlier CF versions. (Note that he has previously given a talk on migrating CF admin settings, and he plans a future talk on some other aspects of migration.)
https://www.meetup.com/coldfusionmeetup/events/281800384/


ICYMI - Online CF Meetup - Using LaunchDarkly for feature flag management in CF applications, w/ Brad Wood
Thursday, October 28, 2021 at 9:00 AM to 10:00 AM PDT
Feature flags are a system of enabling certain functionality in your app based on test groups, cross-cutting segments of users, and your internal release processes. Feature flags can be updated on the fly at any time by any user and don't require deploying new code to your servers. LaunchDarkly is a system that helps you manage your feature flags and how they respond to the users of your site. It offers detailed tracking of each user, each flag, and a robust set of rules for determining which users see which features. In this session, we'll see an overview of how to use the new LaunchDarkly SDK which can be used in ColdFusion applications. Demos will include both ColdBox apps and non-ColdBox legacy apps.
https://www.meetup.com/coldfusionmeetup/events/281577538/
Recording: https://www.youtube.com/watch?v=cjboLKvbGDc


Ortus Webinar for November - Javier Quintero on ForgeBox Business
Details coming soon


CBWire is ALIVE!!!
Grant Copley is knocking out some great new features and documentation on CBWire, follow him or the #cbwire hashtag to keep up on everything. This session at ITB was great if you want to learn more about CBWire.
A couple of links from his tweets.
https://cbwire.ortusbooks.com/templates/loading-states#toggling-attributes
https://cbwire.ortusbooks.com/component-features/logging



CFCasts Content Updates

https://www.cfcasts.com

Just Released

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



Conferences and Training


Microsoft Ignite - THIS WEEK

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


Deploy by Digital Ocean

THE VIRTUAL CONFERENCE FOR GLOBAL DEVELOPMENT TEAMS
November 16-17, 2021
https://deploy.digitalocean.com/home


AWS re:Invent

NOV. 29 – DEC. 3, 2021 | LAS VEGAS, NV
CELEBRATING 10 YEARS OF RE:INVENT
Virtual: Free
In Person: $1799
https://reinvent.awsevents.com/


Postgres Build

Online - Free
Nov 30-Dev 1 2021
https://www.postgresbuild.com/


ITB Latam 2021

December 2-3, 2021
Into the Box LATAM is back and better than ever! Our virtual conference will include speakers from El Salvador and all over the world, who'll present on the latest web and mobile technologies in Latin America.
Registration is completely free so don't miss out!
https://latam.intothebox.org/


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/

Tweet from Mark Takata -
OK! I can finally let you all know that for the @Adobe @coldfusion #CFSummit2021 keynote we will be featuring @ashleymcnamara! Her talk will focus on the history & future of DevRel how we got here & where we're going.
cfsummit.vconfex.com to register!
#CFML #DevRel #conference
https://twitter.com/MarkTakata/status/1449063259072438277
https://twitter.com/MarkTakata


jConf.dev

Now a free virtual event
December 9th starting at 8:30 am CDT/2:30 pm UTC.
https://2021.jconf.dev/?mc_cid=b62adc151d&mc_eid=8293d6fdb0


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 - FusionReactor 8.7.4 released, now tracks JDBC time and more on request list pages
FusionReactor version 8.7.4 was released recently (Oct 28. 2021), and while the release notes list several improvement (and a few bug fixes), I want to highlight in particular a couple of new features.
TLDR; The first improvement is one I've been looking forward to for years: the display (on request list pages) of JDBC time spent and time spent calling out to remote services. This will really speed up assessment of the reason of slowness in listed requests. More on that feature (including a screenshot) and still another, below.
https://www.carehart.org/blog/client/index.cfm/2021/11/1/fusionreactor_8_7_4_released


Blog - Julian Halliwell - Lucee Spreadsheet is now Spreadsheet CFML
The Lucee Spreadsheet library was born of my frustration 7 years ago at the difficulty of getting spreadsheet functionality to work in Railo and then Lucee.
Not long after its release, I started getting requests to support Adobe ColdFusion (ACF). This seemed a bit odd at first. ACF already had built-in spreadsheet functionality so why would you need a third-party tool?
The main reason is cross-platform compatibility: allowing for a code base (such as Preside CMS) to run on either CFML engine.
https://blog.simplicityweb.co.uk/124/lucee-spreadsheet-is-now-spreadsheet-cfml


Blog - Ben Nadel - The Value Class java.time.LocalDateTime Cannot Be Converted To A Date In ColdFusion
Yesterday, I went to debug an issue with the latest Adobe ColdFusion 2018 Updater. So, I first updated my CommandBox Docker Image (in an effort to reproduce the issue in my local development environment). This sent me down a 4-hour rabbit hole just trying to getting my ColdFusion site up-and-running before I could even debug the originally issue. One of the problems that I ran up against was an incompatibility with Adobe ColdFusion and the latest MySQL Connector/J, version 8.0.23+.
https://www.bennadel.com/blog/4144-the-value-class-java-time-localdatetime-cannot-be-converted-to-a-date-in-coldfusion.htm


Blog - Ben Nadel - From ColdFusion 10 To ColdFusion 2018 - Preparing For Some Blog Love
This blog is hella old. It started back in 2006 on Macromedia ColdFusion MX 7. At some point, it was updated to ColdFusion 10, where it remained for the better part of a decade. Recently, I updated it to Adobe ColdFusion 2018. But, the underlying code is still hella old and in much need of some love and tenderness. I'd like to put some time into modernizing the internals. But, before I do that, I need to get a sense of what "modernization" even means when moving from ColdFusion 10 to ColdFusion 2018. This post is really a note to self that refreshes my brain as to what functionality is now available to me in the current Adobe ColdFusion 2018 install.
https://www.bennadel.com/blog/4145-from-coldfusion-10-to-coldfusion-2018-preparing-for-some-blog-love.htm


Blog - Ben Nadel - Managing Shared Secret Token Rotation Across Systems In Lucee CFML 5.3.7.47
When two systems interact, a shared secret is often included with inter-system communication in order to make sure that the given calls are both authorized and have not been tampered with. For various reasons, those shared secrets need to be rotated over time. And, since multiple systems - that need to agree on which secrets are valid - cannot be deployed at the exact same moment, we need to have a token rotation strategy that allows for different systems to rotate tokens at different times. Since I've recently had to deal with this type of token rotation in my ColdFusion applications, I thought it would be good to codify my thoughts in a small demo in Lucee CFML 5.3.7.47.
https://www.bennadel.com/blog/4142-managing-shared-secret-token-rotation-across-systems-in-lucee-cfml-5-3-7-47.htm


Blog - Ben Nadel - Securing ColdFusion Scheduled Tasks In A Docker Container Using Lucee CFML 5.3.8.206
As I mentioned in my previous post on managing shared secret token rotation across systems, I've been cleaning up some really old code, moving hard-coded passwords into environment variables. One place in which we had a hard-coded password was in our ColdFusion Scheduled Task ingress. As I was updating this code, it occurred to me that the Docker-based reality in which many of us now live has implications on the way in which we can secure our ColdFusion scheduled tasks. As such, I wanted to put together a small demo exploring the various ways in which we can secure a ColdFusion scheduled task running in a Dockerized container using Lucee CFML 5.3.8.206.
https://www.bennadel.com/blog/4143-securing-coldfusion-scheduled-tasks-in-a-docker-container-using-lucee-cfml-5-3-8-206.htm


Tweet - Steven Erat - Mind Blown this Week!
Mind blown this week. Watching #AdobeMax highlight projects I work on at Adobe Stock while following commentary from (#ColdFusion's) @benforta, dovetailing into #CFML podcast by @gpickin & @bdw429s, finally realizing #Selenium4 has been released this week.
https://twitter.com/stevenerat/status/1453424787150180353
https://twitter.com/stevenerat



CFML Jobs

Several positions available on https://www.getcfmljobs.com/
Listing over 226 ColdFusion positions from 102 companies across 123 locations in 5 Countries.

5 new jobs listed

Full-Time - Quality Assurance Engineer w/ ColdFusion Knowledge - Remote .. - United States
Posted Nov 02
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Quality-Assurance-Engineer-w-ColdFusion-Knowledge-Remote-Position-at-Denver-CO/11374

Full-Time - Web Developer at Denver, CO - United States
Posted Oct 29
https://www.getcfmljobs.com/viewjob.cfm?jobid=11372

Full-Time - HTML / Coldfusion Developer - Salford Quays + WFH at Salford.. - United Kingdom
Posted Oct 29
https://www.getcfmljobs.com/jobs/index.cfm/united-kingdom/HTML-Coldfusion-Developer-Salford-Quays-WFH-at-Salford/11373

Full-Time - Coldfusion Developer at California - United States
Posted Oct 29
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-California/11371

Full-Time -  Coldfusion Developer at Texas - United States
Posted Oct 28
https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-Texas/11370


ForgeBox Module of the Week

ColdBox ReCAPTCHA Google v3.0 Module

By Javier Quintero for Ortus Solutions

This module contains helpers for using Google's ReCAPTCHA API.

reCAPTCHA is a free service that protects your site from spam and abuse. It uses advanced risk analysis techniques to tell humans and bots apart.

reCAPTCHA v3 returns a score for each request without user friction. The score is based on interactions with your site and enables you to take an appropriate action for your site. Register reCAPTCHA v3 keys here: https://g.co/recaptcha/v3

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



VS Code Hint Tips and Tricks of the Week

SQLTools

By Matheus Teixeira

Database management done right. Connection explorer, query runner, intellisense, bookmarks, query history. Feel like a database hero!

https://vscode-sqltools.mteixeira.dev/
https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools



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