Modernize or Die® - CFML News for November 5th, 2019

Watch the video version on YouTube https://youtu.be/rlZu2ApNmto2019-11-5 Weekly News - Episode 26Hosts:Gavin Pickin - Software Consultant for Ortus SolutionsEric Peterson - Module Creator for Ortus SolutionsNews and EventsInto the Box Call for Speakers - now openhttps://www.papercall.io/itb2020CB Guard 4.0 Releasedhttps://www.forgebox.io/view/cbguardqB 7 Beta ready for testingThe 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. #cfmlhttps://www.forgebox.io/view/qbOnline #ColdFusion Meetup - "SQL, I learned enough to break everything" with Dave FergusonThu Nov 7, 6p US ETI 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 Clementehttps://www.meetup.com/coldfusionmeetup/events/266032128/Hacktoberfest - Biggest Year Ever61,956 - CHALLENGE COMPLETIONS482,182 - PULL REQUESTS OPENED154,466 - PARTICIPATING REPOSITORIEShttps://hacktoberfest.digitalocean.com/ConferencesInto the Box LATAM (LatinoAmerica)Dec 4, 2019 - San Salvador, El Salvador1 Day - 1 Track - Presented in SpanishSpeakers include: Luis Majano, Edgardo Cabezas, Jorge Reyes, Jon Clausen, Esmeralda Acevedo, Stephanie Monge, Javier Quintero, Luis VegaLots 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-76371335721CF Summit IndiaDec 7, 2019 - BengalaruThe 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 2020May 6-8, 2020 | TexasHyatt Place The Woodlands1909 Research Forest Dr., The Woodlands, TX 77380Call 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/itb2020Blogs, Tweets and Videos of the WeekPete Freitag has released CFML News Issue 34Includes 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-34Blog - Evagoras Charalambous - A ForgeBox CommandBox module for creating OSGi bundled JARsIn 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.31Last 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.htmBlog - Gregory Alexander - 6 Part Series - How to make the perfect social media sharing image - part 1 BackgroundHave 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-BackgroundBlog - Ben Nadel - Serializing A MySQL RecordSet As A Set Of INSERT Statements Using Lucee CFML 5.2.9.40This 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.htmBlog - Charlie Arehart - Solving error during CF update: Failed Signature VerificationIf 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.40The 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.htmBlog - Charlie Arehart - On converting from application.cfm to application.cfcIf 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 a 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-asBlog - Charlie Arehart - A fix for the error: ColdFusion was unable to create an image from the specified source fileHow 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 JobsSeveral positions available on https://www.getcfmljobs.com/ ColdFusion Developer for CEdge Software Consultants in St. Louis, MO,  United StatesThe 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/10964Senior ColdFusion Developer for American Access Casualty Company in Downers Grove, IL,  United StatesThe 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=10966ForgeBox Module of the WeekRoute VisualizerThe 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-visualizerLast Update: Oct 25 2018 03:05 PM | Downloads: 488 | Installs: 5803 | Views: 1425 | Versions: 7https://www.forgebox.io/view/route-visualizerVS Code Hint Tips and Tricks of the WeekProject Manager - alefragnani.project-managerAlessandro Fragnani - 735,147 - 5 starsIt 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-managerThank 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. If we’re getting your name wrong please let us know.Andrew  DavisBrian  WhiteCarl  Von StettenDa LiDan  CardDaniel GarciaDavid  BelangerDidier  Lesnicki Don  BellamyErick HoffmanGary  KnightJan  JannekJeremy AdamsJohn  FarrarJordan ClarkJoseph  LamoreeLaksma  TirtohadiMatthew ClementeRichard  HerbertSamuel  KnowltonScott SteinbeckVJYogesh  MathurYou can see an up to date list of all sponsors on Ortus Solutions' Websitehttps://ortussolutions.com/about-us/sponsors★ Support this podcast on Patreon ★

2356 232

Suggested Podcasts

Craig Garber

Be Here Now Network

Primo Center

San Francisco Chronicle

Avani Bhargava

Himanshi Marwah

Shishir Rattan

Dheeraj Kumar