Modernize or Die® - CFML News for May 18th, 2021 - Episode 104

<p><strong>2021-05-18 Weekly News - Episode 104<br></strong><br>Watch the video version on YouTube at <a href="https://youtu.be/XADBSOM1CGs">https://youtu.be/XADBSOM1CGs</a> </p><p><br><em>Hosts:</em><strong> </strong><br>Gavin Pickin - Software Consultant for Ortus Solutions<br>Luis Majano - Owner of Ortus Solutions</p><p><br><em>Thanks to our Sponsor - Ortus Solutions</em></p><p>The makers of ColdBox, CommandBox, ForgeBox, TestBox and almost every other Box out there. <br>A few ways  to say thanks back to Ortus Solutions:<br>- Like and subscribe to our videos on youtube. <br>- Sign up for a free or paid account on CFCasts, which is releasing new content every week<br>- Buy Ortus’s new Book - 102 ColdBox HMVC Quick Tips and Tricks on GumRoad (<a href="http://gum.co/coldbox-tips">http://gum.co/coldbox-tips</a>)</p><p><br><em>Patreon Support<br></em><br>We have 37 patreons providing 84% of the funding for our Modernize or Die Podcasts via our Patreon site: <a href="https://www.patreon.com/ortussolutions">https://www.patreon.com/ortussolutions</a>. If you love our podcasts and all we do for the #coldfusion #cfml community considers chipping in, we are almost there!<br><a href="https://www.ortussolutions.com/blog/we-need-your-help">https://www.ortussolutions.com/blog/we-need-your-help</a> </p><p><strong>News and Events<br></strong></p><p><em>CommandBox 5.3.1 Released<br></em><br>The sql command is brand new in 5.3.1 as well thanks to Scott and Brad. <br>cat myfile.json | sql select=id,name where="name like '%sql%'" orderby=name limit=3<br>You can pipe in any JSON representation of data and filter it on the fly with QoQ<br>Which pairs nicely with the table printer and this new import/export module that supports different file formats<br><a href="https://www.ortussolutions.com/blog/commandbox-531-release">https://www.ortussolutions.com/blog/commandbox-531-release</a></p><p><br><em>FusionReactor 8.7.1 Released<br></em><br>FusionReactor 8.7.1 was released on May 12th. Included are improvements to both the suppo