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

2019-11-5 Weekly News - Episode 26

Hosts:

Gavin Pickin - Software Consultant for Ortus Solutions
Eric Peterson - Module Creator for Ortus Solutions



News and Events


Into the Box Call for Speakers - now open
https://www.papercall.io/itb2020


CB Guard 4.0 Released
https://www.forgebox.io/view/cbguard


qB 7 Beta ready for testing
The latest version of qb is ready for testing in your application.
`box install qb@be`
Check out the completely revamped docs and migration guide.
https://qb.ortusbooks.com/v/7.0.0/
Please test and let us know if you have any issues.
I think you’ll really love this release.
#cfml
https://www.forgebox.io/view/qb


Online #ColdFusion Meetup - "SQL, I learned enough to break everything" with Dave Ferguson
Thu Nov 7, 6p US ET
I bet you have written SQL for your app. I would also bet that you have written SQL and looked at it a little like a puppy dog that tilts its head at strange things. We all have, even the experts among us. Nobody is immune to writing things that make you scratch your head.
In this session, we will take a look at why your SQL may not run the way you intended. We will look well beyond just the select statement and look deeper into how SQL runs. We will go over what the DBA's keep to themselves as well as other metrics. We will also look at some debugging techniques to help find problems when they happen.
https://www.meetup.com/coldfusionmeetup/events/266110524/

Did you miss? "GET /cfml - A Guide to Writing API Wrappers" with Matthew Clemente
https://www.meetup.com/coldfusionmeetup/events/266032128/


Hacktoberfest - Biggest Year Ever
61,956 - CHALLENGE COMPLETIONS
482,182 - PULL REQUESTS OPENED
154,466 - PARTICIPATING REPOSITORIES
https://hacktoberfest.digitalocean.com/



Conferences

Into the Box LATAM (LatinoAmerica)
Dec 4, 2019 - San Salvador, El Salvador
1 Day - 1 Track - Presented in Spanish
Speakers include: Luis Majano, Edgardo Cabezas, Jorge Reyes, Jon Clausen, Esmeralda Acevedo, Stephanie Monge, Javier Quintero, Luis Vega
Lots of great content, I had to use google translate to know what they were talking about.
https://latam.intothebox.org/

Tickets available now. https://www.eventbrite.com/e/into-the-box-latinoamerica-2019-tickets-76371335721


CF Summit India
Dec 7, 2019 - Bengalaru
The ColdFusion India Summit is a confluence of everything in the realm of web applications. If you develop web applications, this is the place to be. For designers, developers, strategists and thought leaders, the ColdFusion India Summit provides the perfect forum to exchange ideas, inspiration and experiences.
In addition to opportunities to interact with ColdFusion experts, domain leaders and peers, get to learn about the latest technologies, techniques, and strategies to rapidly build and successfully deliver web applications to the market. With the web applications scenario evolving rapidly, explore how ColdFusion is driving change and how you can propel this dynamism.
Registration is complimentary.
https://cfindiasummit.attendease.com/


Into the Box 2020
May 6-8, 2020 | Texas
Hyatt Place The Woodlands
1909 Research Forest Dr., The Woodlands, TX 77380
Call for Speakers is now open. We are always looking for lots of different content from different speakers, don’t be shy, submit something. Does not have to be related to BOX products.
Early bird tickets will be available close to the end of the year.
https://www.papercall.io/itb2020



Blogs, Tweets and Videos of the Week


Pete Freitag has released CFML News Issue 34
Includes lots of great content, including a link to our podcast, but also reports on CF Camp and CF Summit, CFMeetup updates, the Monkeh house and the Ben Zone and lots more.
https://tinyletter.com/cfml/letters/cfml-news-issue-34


Blog - Evagoras Charalambous - A ForgeBox CommandBox module for creating OSGi bundled JARs
In ColdFusion I sometimes run into JAR loading conflict issues where two JARs may have the same class path but are using different versions. Lucee has already worked around this issue by having the ability to create a Java object using a bundle name and version, and Adobe is reportedly working on this for their 2020 release. Having run into this issue many times, I decided to create a CommandBox script to do this for me.
https://www.evagoras.com/2019/11/05/a-forgebox-commandbox-module-for-creating-osgi-bundled-jars/


Blog - Ben Nadel - Replacing ColdFusion Query-Of-Queries (QoQ) With Array Functions In Lucee CFML 5.2.9.31
Last week, on the Modernize Or Die ColdFusion Podcast, Gavin Pickin and Brad Wood reminded us that ColdFusion is not a query engine. And that - despite the simplicity of the ColdFusion Query-of-Queries (QoQ) - there are much more performant ways to achieve the same results. There's no doubt that Query-of-Queries are amazing; and that they are part of what makes ColdFusion so powerful. But, as the CFML language has become more robust, Query-of-Queries can more easily be replaced with faster, native Array manipulation. To demonstrate, I wanted to dig through the InVision codebase, locate a number of old Query-of-Query instances, and showcase how those in-memory queries can be modernized with various Array methods.
https://www.bennadel.com/blog/3714-replacing-coldfusion-query-of-queries-qoq-with-array-functions-in-lucee-cfml-5-2-9-31.htm


Blog - Gregory Alexander - 6 Part Series - How to make the perfect social media sharing image - part 1 Background
Have you wondered how to get a perfect image from your blog when you share your post on social media? I have... and after spending several weeks on this; I think that I have managed to figure it out...
https://gregoryalexander.com/blog/2019/10/28/How-to-make-the-perfect-social-media-sharing-image--part-1-Background


Blog - Ben Nadel - Serializing A MySQL RecordSet As A Set Of INSERT Statements Using Lucee CFML 5.2.9.40
This past week at InVision, some data was accidentally deleted from one of our MySQL databases. In order to get the data back, our Data Services team had to restore one of the backups. And then, I had to write a ColdFusion script that would transfer a slice of the data from the restored-database back into the production database. Of course, for security reasons, I was only given access to the backup. As such, I had to locate the deleted records, serialize them as a series of INSERT statements, and then hand those SQL queries off to the Data Service team for execution. This was actually a really fun task to work on; and so, I thought it might be interesting to share my basic approach.
https://www.bennadel.com/blog/3713-serializing-a-mysql-recordset-as-a-set-of-insert-statements-using-lucee-cfml-5-2-9-40.htm


Blog - Charlie Arehart - Solving error during CF update: Failed Signature Verification
If you try to update to CF2018 update 5 (or later) or CF2016 update 12 (or later) using the CF Admin update process, you may find that you get the following error during the update process:
“Failed Signature Verification”
https://coldfusion.adobe.com/2019/11/solving-error-cf-update-failed-signature-verification/


Blog - Ben Nadel Adding A TTL To All Persistent Keys In Redis Using LaunchDarkly Feature Flags And Lucee CFML 5.2.9.40
The other week, I created a Redis key scanner using Jedis and Lucee CFML 5.2.8.50. I did this because I saw that one of our production Redis databases seemed to have a steady number of keys (about 14M); and, I wanted to see if they were all supposed to be there. By using the key scanner, I discovered a massive number of "persistent" keys - those without a TTL (Time to Live). So, I cleaned up much of the code that was producing these persistent keys. And then, I needed to write a script to safely iterate over the Redis key-space and assign a TTL to all persistent keys. I did this using LaunchDarkly feature flags and Lucee CFML 5.2.9.40.
https://www.bennadel.com/blog/3712-adding-a-ttl-to-all-persistent-keys-in-redis-using-launchdarkly-feature-flags-and-lucee-cfml-5-2-9-40.htm


Blog - Charlie Arehart - On converting from application.cfm to application.cfc
If you’ve been dragging your feet on converting from application.cfm to application.cfc, there are a few resources that can help you, both in doing it and in appreciating why you should.
https://coldfusion.adobe.com/2019/10/on-converting-from-application-cfm-to-cfc/


Blog - James Moberg - My ColdFusion CFDocument Advice was “Marked as Spam”. Lame.
I seriously considered contributing some #cfml articles to @AdobeForums, but after my #ColdFusion response (based on 12 years of generating PDFs) was "marked as spam" and deleted, I'm not sure I trust that the platform fairly represents the community of users.
I responded with advice that I both use & recommend as a ColdFusion Developer and it was immediately “marked as spam and removed.”  Here’s my response on 10/30/2019 06:45 Pacific.
https://gamesover2600.tumblr.com/post/188699360904/my-coldfusion-cfdocument-advice-was-marked-as


Blog - Charlie Arehart - A fix for the error: ColdFusion was unable to create an image from the specified source file
How to solve a problem that may not be obvious: the CFML image tags and functions that accept a URL won’t follow a redirect, but instead fail with this cryptic error.
https://coldfusion.adobe.com/2019/10/image-processing-error-and-solution/



CFML Jobs

Several positions available on https://www.getcfmljobs.com/

ColdFusion Developer for CEdge Software Consultants in St. Louis, MO,  United States
The ColdFuision Developer will perform technical analysis, design, construction code build, and unit testing of application...
https://www.getcfmljobs.com/jobs/index.cfm/united-states/ColdFusion-Developer-at-St-Louis-MO/10964

Senior ColdFusion Developer for American Access Casualty Company in Downers Grove, IL,  United States
The Senior ColdFusion Developer role is to write code, test, and analyze software programs and web-based applications. The position includes researching, designing, documenting, and modifying software specifications throughout the production life cycle. The developer will also analyze and amend software errors in a timely and accurate fashion, provide weekly status reports, and suggest code improvement, where applicable.
https://www.getcfmljobs.com/viewjob.cfm?jobid=10966



ForgeBox Module of the Week

Route Visualizer
The ColdBox Route visualizer will map out all your routing tables for any ColdBox 4+ application. You will visualize the routing and test the routes in the order they fire.

box install route-visualizer

Last Update: Oct 25 2018 03:05 PM | Downloads: 488 | Installs: 5803 | Views: 1425 | Versions: 7

https://www.forgebox.io/view/route-visualizer



VS Code Hint Tips and Tricks of the Week

Project Manager - alefragnani.project-manager

Alessandro Fragnani - 735,147 - 5 stars

It helps you to easily access your projects, no matter where they are located. Don't miss that important projects anymore. You can define your own Favorite projects, or choose for auto-detect VSCode projects, Git, Mercurial and SVN repositories or any folder.

Since version 8 you have a dedicated Side Bar for your projects!

https://marketplace.visualstudio.com/items?itemName=alefragnani.project-manager



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.

If we’re getting your name wrong please let us know.


Andrew  Davis
Brian  White
Carl  Von Stetten
Da Li
Dan  Card
Daniel Garcia
David  Belanger
Didier  Lesnicki
Don  Bellamy
Erick Hoffman
Gary  Knight
Jan  Jannek
Jeremy Adams
John  Farrar
Jordan Clark
Joseph  Lamoree
Laksma  Tirtohadi
Matthew Clemente
Richard  Herbert
Samuel  Knowlton
Scott Steinbeck
VJ
Yogesh  Mathur

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