lystn

2021-03-09 Weekly News - Episode 94Watch the video version on YouTube at https://youtu.be/lF4X6wKiV-g Hosts:Luis Majano - Owner / Guru for Ortus SolutionsGavin Pickin - Software Consultant for Ortus SolutionsThanks to our Sponsor - Ortus SolutionsOne 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 GumRoadPatreon SupportWe 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 EventsNew 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 BetaNew big features, Mutli-site, and finally solid Postgres support.Official Beta coming very soon.Ortus Webinar Announced - Vue.js in my ColdBox AppFriday, 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 Acevedohttps://www.ortussolutions.com/events/webinars Online CF Meetup - "ColdFusion 101: Intro for Beginner Devs, Decision Makers, a CEO’s", David Byers Thursday, March 11, 202111:00 AM to 12:00 PM CSTEvery 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 TricksNow Available on Gumroad - $29http://gum.co/coldbox-tips Reminder about the new Ortus CommunityOrtus 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 UpdatesJust Released- CommandBox Zero to Hero    - Task Runners Part 1    - Task Runners Part 2Coming up- More CommandBox Hero to ZeroSend your suggestions at https://cfcasts.com/supportConferences and TrainingVueConf - Virtual Vue LoveApril 14th - Online - Free and there’s swag (first 500 registrations)Hosted by Evan YouLive Video with Chat QaA with speakersAttendee Lightning TalksLive DJVirtual PartyWorkshops TBAhttp://vueconf.us/ RedisConf 2021Virtual: Apr 20-21Stay tuned for Detailshttps://redislabs.com/redisconf/ DockerConMay 27th 2021https://www.docker.com/dockercon/ Ortus WorkshopsQuick WorkshopMarch 11-12Lead by the creator of Quick himself, Eric Peterson.Information: https://www.ortussolutions.com/blog/first-workshop-of-the-year-announced-up-and-running-with-quickRegister 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 SuperHeroOrtus’s Possible Conferences for 2021Dates subject to changeDue 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 MembersSeptember 2021Call for speakers coming soonITB LatamDecember 2021More conferencesNeed 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 WeekBlog - Ben Nadel - Using ColdFusion Custom Tags To Create An HTML Email DSL In Lucee CFML 5.3.7.47, Part XIILast 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 XIIIAs 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.47At 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 lcfqueryg 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.47Last 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 CodeMany 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 QueriesI 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 a ColumnArray() w/Lucee.https://twitter.com/gamesover/status/1366897942909566977https://twitter.com/gamesoverCFML JobsSeveral 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 weekFull-Time - ColdFusion Developer at remote - United States Posted Mar 04https://www.getcfmljobs.com/jobs/index.cfm/united-states/CFDev-at-Remote/11198 ForgeBox Module of the WeekQuick V4.2.4Quick 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 WeekBetter AlignWwm - wwm.better-align approx 225,000 installsAlign 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 SupportersNew Supporter Jonathan PerretThese 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 WebsiteDon BellamyEric HoffmanDavid Paul BelangerGary KnightGiancarlo GomezJonathan PerretMario RodriguesJohn Wilson - Synaptrix Yogesh MathurJoseph LamoreeBen NadelBrett DeLineCarl Von StettenCharlie ArehartDan CardDaniel GarciaDidier LesnickiEdgardo CabezasJan JannekJason DaigerJeff McClainJeremy AdamsJonas ErikssonJordan ClarkKai KoenigLaksma TirtohadiLeon SeremelisMatthew DarbyMatthew ClementeMingo HagenPatrick FlynnRoss PhillipsScott SteinbeckSteven KlotzYou can see an up to date list of all sponsors on Ortus Solutions' Websitehttps://ortussolutions.com/about-us/sponsors ★ Support this podcast on Patreon ★