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 t...