2021-03-09 Weekly News - Episode 94

Watch the video version on YouTube at https://youtu.be/lF4X6wKiV-g


Hosts:

Luis Majano - Owner / Guru for Ortus Solutions
Gavin Pickin - Software Consultant for Ortus Solutions


Thanks to our Sponsor - Ortus Solutions

One way to say thanks back to Ortus Solutions, is to like and subscribe to our videos on youtube.
Support CFCasts, which is releasing new content every week.
Buy Ortus’s new Book - 102 ColdBox HMVC Quick Tips and Tricks on GumRoad


Patreon Support

We have 34 patreons providing 73% of the funding for our Modernize or Die Podcasts via our Patreon site: https://www.patreon.com/ortussolutions. If you love our podcasts and all we do for the #coldfusion #cfml community considers chipping in, we are almost there!
https://www.ortussolutions.com/blog/we-need-your-help




News and Events


New FORGEBOX® Pricing for 2021+

A new year means focusing on new priorities and projects. With that in mind, we wanted to give FORGEBOX® the spotlight it deserves. Our goal is to make your job and your life easier, that’s why we have decided to bring down our pricing considerably!
https://www.ortussolutions.com/blog/new-forgebox-pricing-for-2021



ContentBox 5 Beta

New big features, Mutli-site, and finally solid Postgres support.
Official Beta coming very soon.



Ortus Webinar Announced - Vue.js in my ColdBox App

Friday, March 26th at 11:00 AM CT (GMT -6:00)
In this webinar, Esmeralda Acevedo will show us how to integrate Vue in a simple ColdBox app, which will ultimately demonstrate the fundamentals of Vue.js.
with Esme Acevedo
https://www.ortussolutions.com/events/webinars



Online CF Meetup - "ColdFusion 101: Intro for Beginner Devs, Decision Makers, & CEO’s", David Byers
 
Thursday, March 11, 2021
11:00 AM to 12:00 PM CST
Every developer's journey has to start somewhere. This session is designed to give new developers and business owners an overview of ColdFusion, and why it's one of the most amazing development languages available. You will learn, from a very broad perspective, the basics of how ColdFusion works, some simple ColdFusion syntax, an overview of the major ColdFusion frameworks, an overview of the developer community and various ColdFusion resources, and some facts and misconceptions.
This presentation is specifically targeted towards new developers or business owners who have little to no knowledge of ColdFusion.
https://www.meetup.com/coldfusionmeetup/events/276609685/



FR Webinar - What Are The 5 Things You Should ALWAYS Check Before You Release Your Application?

Join Mikey on March 25 at 09:30 PDT
Releasing a new app or website can be stressful. Whilst most dev teams have a QA process, the team often needs to go a little deeper in order to spot performance issues errors buried deep within the code.  The 5 things you should always check before you release your application are
https://www.fusion-reactor.com/blog/what-are-the-5-things-you-should-always-check-before-you-release-your-application/
Register: https://bit.ly/3bD4WWr



New Book from Luis Majano 102 ColdBox HMVC Quick Tips and Tricks

Now Available on Gumroad - $29
http://gum.co/coldbox-tips



Reminder about the new Ortus Community

Ortus has rolled out our new Ortus Community site to help consolidate all of our community support and interaction.  As part of that effort, all our Google Group threads have been imported to the new Ortus Community and effective immediately, our Google Groups are closed for further posting.
If you're a member of our Google groups, don't worry-- your user has already been imported into the community forum and as soon as you sign up, you will be automatically associated with all of your old posts so you can pick up your conversations right where you left off!  We've even added single sign on options for Github, Facebook, Google, and Twitter (coming soon).  If your new account is under a different E-mail address, let us know and we can merge your accounts together.
https://community.ortussolutions.com/



CFCasts Content Updates

Just Released

- CommandBox Zero to Hero
    - Task Runners Part 1
    - Task Runners Part 2

Coming up

- More CommandBox Hero to Zero

Send your suggestions at https://cfcasts.com/support



Conferences and Training



VueConf - Virtual Vue Love

April 14th - Online - Free and there’s swag (first 500 registrations)
Hosted by Evan You
Live Video with Chat Q&A with speakers
Attendee Lightning Talks
Live DJ
Virtual Party
Workshops TBA
http://vueconf.us/



RedisConf 2021

Virtual: Apr 20-21
Stay tuned for Details
https://redislabs.com/redisconf/



DockerCon

May 27th 2021
https://www.docker.com/dockercon/



Ortus Workshops

Quick Workshop

March 11-12
Lead by the creator of Quick himself, Eric Peterson.
Information: https://www.ortussolutions.com/blog/first-workshop-of-the-year-announced-up-and-running-with-quick

Register now https://www.eventbrite.com/e/up-and-running-with-quick-tickets-124157021995

More dates to come
- CommandBox Zero to Hero
- ColdBox Zero to Hero
- ColdBox Hero to SuperHero


Ortus’s Possible Conferences for 2021

Dates subject to change

Due to Online conference overload, we are thinking about not expanding the number of events, but more content in more timezones with a different format.

ITB - Developer Week Style??
With some European Timezone Friendly slots from our European Community Members
September 2021
Call for speakers coming soon

ITB Latam
December 2021

More conferences
Need more conferences, this site has a huge list of conferences for almost any language/community.
https://confs.tech/

CFML Is now on the list - https://confs.tech/conferences/new



Blogs, Tweets and Videos of the Week


Blog - Ben Nadel - Using ColdFusion Custom Tags To Create An HTML Email DSL In Lucee CFML 5.3.7.47, Part XII
Last week was InVision's "Sync Week" - our annual all-company meetup and hackathon. And, for my hackathon topic, I decided to try and apply my ColdFusion custom tag DSL (Domain Specific Language) for HTLM emails to our application's transactional emails. It's still in the proof-of-concept (POC) phase; but, I learned a lot from 3-days of heads-down HTML email hackery; and, I've tried to pull those learnings back into my ColdFusion custom tag concept. One of the first issues that I ran into was that I needed to just normalize all Margins on block-level entities.
https://www.bennadel.com/blog/4000-using-coldfusion-custom-tags-to-create-an-html-email-dsl-in-lucee-cfml-5-3-7-47-part-xii.htm


Blog - Ben Nadel - Using ColdFusion Custom Tags To Create An HTML Email DSL In Lucee CFML 5.3.7.47, Part XIII
As I've been continuing to flesh-out my ColdFusion custom tag DSL (Domain Specific Language) for HTLM emails, I've come to realize that dealing with custom web fonts and font-weights is a pretty big challenge. Specifically because we can't be sure that our custom web font has loaded; and, a number of email clients have support for just two font-weights: 400 and 700. As such, I'm starting to think that it's a good idea to avoid "bold" weights below 600 regardless of the font-weight variations available in your custom web font.
https://www.bennadel.com/blog/4002-using-coldfusion-custom-tags-to-create-an-html-email-dsl-in-lucee-cfml-5-3-7-47-part-xiii.htm


Blog - Ben Nadel - Killing Slow MySQL Queries In An Emergency In Lucee CFML 5.3.7.47
At InVision, we recently upgraded our MySQL database servers to use MySQL 5.7.x. And, while I'm excited for access to new features like the native JSON column type and the sys performance schema, the upgrade did have some bumps. In particular, we had a subset of SQL queries that started running with terrible performance (typically those that have very large IN(id-list) clauses). I had to refactor a number of queries; but, while that code was being changed, I had to put together an emergency utility that would allow me to start killing SQL queries in production. I thought this was a fun little exercise that would be worth sharing in Lucee CFML 5.3.7.47.
ASIDE: Before I started killing queries manually, I did try adding a timeout to my <cfquery> tags. Unfortunately, this did not seem to have any impact. I am not sure why the timeout didn't kill long-running queries in Lucee CFML - I know that this mostly worked when the code was running on Adobe ColdFusion.
https://www.bennadel.com/blog/3999-killing-slow-mysql-queries-in-an-emergency-in-lucee-cfml-5-3-7-47.htm


Blog - Ben Nadel - Case Study: Removing Massive IN (ID-List) Clauses For Performance In MySQL 5.7.32 And Lucee CFML 5.3.7.47
Last week, I shared some emergency ColdFusion code that I had written and deployed that would allow me to view the processlist and kill slow queries in MySQL in one of InVision's read-replicas on Amazon RDS. After we upgraded to MySQL 5.7.32, a few of our oldest SQL queries started to perform really poorly; and, I needed to create a little breathing room for the database CPU while I refactored the problematic SQL statements. After my post last week, Martie Henry asked me what the performance bottleneck ended-up being; so, I thought I would share a quick case study about what was going on and how I "fixed it" (depending on how hard you squint).
https://www.bennadel.com/blog/4001-case-study-removing-massive-in-id-list-clauses-for-performance-in-mysql-5-7-32-and-lucee-cfml-5-3-7-47.htm


Blog - Ortus Solutions - New FORGEBOX® Pricing for 2021+
A new year means focusing on new priorities and projects. With that in mind, we wanted to give FORGEBOX® the spotlight it deserves. Our goal is to make your job and your life easier, that’s why we have decided to bring down our pricing considerably!
https://www.ortussolutions.com/blog/new-forgebox-pricing-for-2021


Podcast - Working Code Podcast - Episode 012: Idiomatic Code
Many programming languages have a sense of idiomatic code: the "blessed way" to solve a particular set of problems with a language's native constructs. These patterns exist to help people work more effectively together; and, to help new developers adapt to the language. But, unfortunately, the expression of idiomatic code in some communities shifts from "carrot" to "stick", getting used to separate the "right" way from the "wrong" way, thereby creating an implicit division between the "good developers" and the "bad developers".
https://www.bennadel.com/blog/3998-working-code-podcast-episode-012-idiomatic-code.htm


Tweet - James Moberg - Case Sensitive Columns in Queries
I just discovered the hard way that getColumnNames() will return the same case when the query is created within #ColdFusion, but SQL-based columns are returned all uppercased. For mixed-case, you have to use getMetaData()․getColumnLabels() w/ACF & ColumnArray() w/Lucee.
https://twitter.com/gamesover/status/1366897942909566977
https://twitter.com/gamesover


CFML Jobs

Several positions available on https://www.getcfmljobs.com/
Listing over 53 ColdFusion positions from 34 companies across 39 locations in 5 Countries since Dec 1st.

1 new job this week

Full-Time - ColdFusion Developer at remote - United States
Posted Mar 04
https://www.getcfmljobs.com/jobs/index.cfm/united-states/CFDev-at-Remote/11198


ForgeBox Module of the Week

Quick V4.2.4

Quick was built out of lessons learned and persistent challenges in developing complex RDBMS applications using built-in Hibernate ORM in CFML.

Quick is an ORM (Object Relational Mapper) written in CFML for CFML. It provides an ActiveRecord implementation for working with your database. With it you can map database tables to components, create relationships between components, query and manipulate data, and persist all your changes to your database.

https://www.forgebox.io/view/quick



VS Code Hint Tips and Tricks of the Week

Better Align

Wwm - wwm.better-align approx 225,000 installs
Align code without selecting them first.

Place your cursor at where you want your code to be aligned, and invoke the Align command via Command Palette or customized shortcut. Then the code will be automatically aligned.

https://marketplace.visualstudio.com/items?itemName=wwm.better-align



Thank you to all of our Patreon Supporters

New Supporter Jonathan Perret

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.

You can support us on Patreon here https://www.patreon.com/ortussolutions

- 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

Don Bellamy
Eric Hoffman
David Paul Belanger
Gary Knight
Giancarlo Gomez
Jonathan Perret
Mario Rodrigues
John Wilson - Synaptrix
Yogesh Mathur
Joseph Lamoree
Ben Nadel
Brett DeLine
Carl Von Stetten
Charlie Arehart
Dan Card
Daniel Garcia
Didier Lesnicki
Edgardo Cabezas
Jan Jannek
Jason Daiger
Jeff McClain
Jeremy Adams
Jonas Eriksson
Jordan Clark
Kai Koenig
Laksma Tirtohadi
Leon Seremelis
Matthew Darby
Matthew Clemente
Mingo Hagen
Patrick Flynn
Ross Phillips
Scott Steinbeck
Steven Klotz


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