Education
2021-10-12 Weekly News - Episode 122Watch the video version on YouTube at https://youtu.be/qESNVAHyTmg Hosts: Brad Wood - Senior Developer for Ortus Solutions Gavin Pickin - Senior Developer for Ortus Solutions Thanks to our Sponsor - Ortus SolutionsThe makers of ColdBox, CommandBox, ForgeBox, TestBox and almost every other Box out there. A few ways to say thanks back to Ortus Solutions: Like and subscribe to our videos on YouTube. Sign up for a free or paid account on CFCasts, which is releasing new content every week Buy Ortus’s new Book - 102 ColdBox HMVC Quick Tips and Tricks on GumRoad (http://gum.co/coldbox-tips) Patreon SupportWe 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 EventsCommandBox 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 updatesGoogle 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 AttackIf 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 availableVideos are now available on CFCasts!https://cfcasts.com/series/into-the-box-2021Free 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/supportICYMI - ContentBox v5 releasedWe 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-releasedMarketing site - https://www.contentboxcms.org/Docs - https://contentbox.ortusbooks.com/v/v5.x/ICYMI - Modernize Or Die Podcast - SoapBox Edition - Relaunching Oct 7thLuis 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 versionIn 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/webinarsHacktoberfest 2021Support 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 SOURCEOpen-source projects keep the internet humming—but they can’t do it without resources. Donate and support their awesome work.TREES NOT TEESRather 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 BruyndonckxWed, November 10, 202109:00 - 17:00 CEST EUROPEANJoin 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 Updateshttps://www.cfcasts.com Just Released Soapbox Relaunch - ColdBox Anniversary Edition with Eric Peterson All of the Into the Box 2021 videos Coming this weekUp and Running with QuickSend your suggestions at https://cfcasts.com/supportConferences and TrainingVueJS LiveOctober 20-21, 2021 - Online and London, UkRemote and In Person Tickets Availablehttps://vuejslive.com/Microsoft IgniteNovember 2–4, 2021 Opportunity awaits, with dedicated content spotlighting Microsoft Business Applications and Microsoft Security.https://myignite.microsoft.com/homeAdobe ColdFusion Summit 2021December 7th and 8th - VirtualSpeakers are finalized and some Speakers and some session descriptions are now on the siteRegister for Free - https://cfsummit.vconfex.com/site/adobe-cold-fusion-summit-2021/1290Blog - https://coldfusion.adobe.com/2021/09/adobe-coldfusion-summit-2021-registrations-open/ More conferencesNeed more conferences, this site has a huge list of conferences for almost any language/community.https://confs.tech/Blogs, Tweets and Videos of the WeekBlog - Charlie Arehart - Beware of ransomware attacks happening on CF9 and earlierIf 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 WSLgWindows 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.47This 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.201When 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 #ColdFusionhttps://twitter.com/bdw429s/status/1445593787447726083 https://twitter.com/bdw429s CFML JobsSeveral positions available on https://www.getcfmljobs.com/Listing over 211 ColdFusion positions from 98 companies across 121 locations in 5 Countries.9 new jobs listedFull-Time - Web Developer / ColdFusion Programmer at South Bend, IN - United States Posted Oct 12https://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 12https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-Senior-at-McLean-VA/11358Full-Time - ColdFusion Developer at Remote - United States Posted Oct 12https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-at-Remote/11357Full-Time - ColdFusion Developer (Remote) at Richmond, VA - United States Posted Oct 11https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-Remote-at-Richmond-VA/11356Full-Time - ColdFusion Engineer at Remote - United States Posted Oct 09https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Engineer-at-Remote/11355Full-Time - ColdFusion Developer (Senior) at McLean, VA - United States Posted Oct 07https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-Senior-at-McLean-VA/11354Full-Time - Coldfusion Developer at Illinois - United States Posted Oct 06https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-Illinois/11353Full-Time - Apex/Oracle Forms/ColdFusion Developer at Washington, DC - United States Posted Oct 06https://www.getcfmljobs.com/jobs/index.cfm/united-states/ApexOracle-FormsColdFusion-Developer-at-Washington-DC/11352Full-Time - Coldfusion Developer at Maryland - United States Posted Oct 05https://www.getcfmljobs.com/jobs/index.cfm/united-states/Coldfusion-Developer-at-Maryland/11351ForgeBox Module of the WeekLaunchDarkly SDKA 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 WeekRelease Party for VS Code 1.61 - September 2021With 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 SupportersThese 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/ortussolutionsNow offering 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 Patreons John Wilson - Synaptrix Eric Hoffman Gary Knight Mario Rodrigues Giancarlo Gomez David Belanger Jonathan Perret Jeffry McGee - Sunstar Media Dean Maunder Joseph Lamoree Don Bellamy Jan Jannek Laksma Tirtohadi Carl Von Stetten Dan Card Jeremy Adams Jordan Clark Matthew Clemente Daniel Garcia Scott Steinbeck - Agri Tracking Systems Ben Nadel Mingo Hagen Brett DeLine Kai Koenig Charlie Arehart Jonas Eriksson Jason Daiger Jeff McClain Shawn Oden Matthew Darby Ross Phillips Edgardo Cabezas Patrick Flynn Stephany Monge Kevin Wright Steven Klotz You can see an up to date list of all sponsors on Ortus Solutions' Websitehttps://ortussolutions.com/about-us/sponsors ★ Support this podcast on Patreon ★