Ben Nadel

Recent Blog Comments By Ben Nadel

• Key Conflicts On INSERT Still Increment AUTO_INCREMENT Value In MySQL

  Posted on Sep 26, 2022 at 2:16 PM

  @Zac, Ahh, thank you! If had taken a moment to stop and think about that, it would have been obvious since I can refresh a page (that has createUniqueId() ) and see the value increments on each request. It looks like a base-32 counter or something. Great catch!... read more »

• Key Conflicts On INSERT Still Increment AUTO_INCREMENT Value In MySQL

  Posted on Sep 25, 2022 at 9:52 AM

  Special thanks to Matej Dunik for point the above out to me 💪... read more »

• Key Conflicts On INSERT Still Increment AUTO_INCREMENT Value In MySQL

  Posted on Sep 25, 2022 at 9:50 AM

  Apparently this AUTO_INCREMENT behavior is actually a setting on the InnoDB database. In the "olden days", all auto-incrementing used to use a full-table lock, which is inherently not great for performance since only one INSERT can run at a time on the table. However, it looks ... read more »

• Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML

  Posted on Sep 23, 2022 at 11:59 AM

  @All, Here's my follow-up post on the AUTO_INCREMENT behavior during a key-conflict scenario: https://www.bennadel.com/blog/4326-key-conflicts-on-insert-still-increment-auto-increment-value-in-mysql.htm... read more »

• Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML

  Posted on Sep 23, 2022 at 10:01 AM

  So, an update on my previous statement - it looks like the AUTO_INCREMENT column is incremented as a byproduct of the ON DUPLICATE KEY UPDATE internal logic, not as a byproduct of the LAST_INSERT_ID() call. Just experimenting with it locally. It looks like this is documented in the... read more »

• Considering Approaches To Handling MySQL Key Conflicts In Lucee CFML

  Posted on Sep 22, 2022 at 10:01 PM

  @All, One thing I just ran into with the approach that uses the ON DUPLICATE SET to get the existing ID - this appears to increment the row ID even if no new row is created. Meaning, imagine that the last row inserted has id:5. Then, I try to run the same query over-and-over 15-times, ... read more »

• Using Type Guards To Narrow Down Error Handling Types In Angular 14

  Posted on Sep 21, 2022 at 12:45 PM

  @Hassam, I suppose great minds think alike 😉... read more »

• Working Code Podcast - Episode 92: The Power Of No

  Posted on Sep 21, 2022 at 10:40 AM

  @Danilo, That's an interesting idea. I'm pretty sure that Adam (on the podcast) uses comma-first for a lot of his code specifically for the reason you outlined: the Pull-Request shows only the line that was changed. I feel like I remember the Golang auto-formatter also doing the same thi... read more »

• Using Type Guards To Narrow Down Error Handling Types In Angular 14

  Posted on Sep 19, 2022 at 8:23 PM

  @Hassam, Yeah, I only learned about unknown while I was looking up some documentation for the Type Guards. I don't think (or don't remember) hearing about it before that. I agree that it likely makes more sense, at least if you are intending to reach down into the error object. As fa... read more »

• Adding An Angular 14 Front-End To My ColdFusion Feature Flag Exploration

  Posted on Sep 19, 2022 at 12:18 PM

  After publishing this Angular 14 UI, I kept feeling like something was amiss in my error handling. As such, I went back and added Type Guards and Type Narrowing into my error handling workflow: https://www.bennadel.com/blog/4324-using-type-guards-to-narrow-down-error-handling-types... read more »

• ArrayPop(), ArrayShift(), And ArraySliceSafe() In Lucee CFML 5.3.6.61

  Posted on Sep 18, 2022 at 9:43 AM

  @Dawesi, Heck yeah! Let's just keep making the language better 💪... read more »

• Strangler: Building A Feature Flag System In ColdFusion

  Posted on Sep 17, 2022 at 1:42 PM

  In the last month, I've dribbled in some effort to rebuild the Admin UI as an Angular 14 application: https://www.bennadel.com/blog/4323-adding-an-angular-14-front-end-to-my-coldfusion-feature-flag-exploration.htm It still leaves much to be desired, and there's plenty of "best ... read more »

• Rendering Text To Canvas With Adjusted X,Y Offsets For Better Cross-Browser Consistency

  Posted on Sep 16, 2022 at 1:09 PM

  @Hassam, Totally agree. And DUDE !!! You're the first person to use the "reply to" functionality to post a comment via email! Outstanding! 🔥🔥🔥... read more »

• Rendering Text To Canvas With Adjusted X,Y Offsets For Better Cross-Browser Consistency

  Posted on Sep 16, 2022 at 11:20 AM

  As a fast-follow, I wanted to look at using a textBaseline of alphabetic , which I was told is consistent across browsers : https://www.bennadel.com/blog/4322-canvas-alphabetic-textbaseline-is-consistent-across-browsers.htm It is consistent; but, it renders from a the bottom of ... read more »

• Rendering Text To Canvas With Adjusted X,Y Offsets For Better Cross-Browser Consistency

  Posted on Sep 14, 2022 at 11:09 AM

  @Hassam, Hmmm, yeah. For me, when I was designing some algorithms around rendering text, it was just easier to think about "top" as an approach. But, perhaps it will be easy to change the way I think about the text layout.... read more »

• Celebrating The Power And Simplicity Of CSV (Comma Separated Value) Data In Lucee CFML 5.3.7.47

  Posted on Sep 14, 2022 at 9:50 AM

  @Mark, 100% well said. And, a big part of that is being kind to ourselves when we make mistakes and learn from our past. Sometimes, it's so much easier to have empathy for others than it have leniency for ourselves.... read more »

• Rendering Text To Canvas With Adjusted X,Y Offsets For Better Cross-Browser Consistency

  Posted on Sep 14, 2022 at 9:46 AM

  @Hassam, I was just talking to Jan Sedivy, who's the lead engineer on the Freehand project, and he was saying they solved this problem by using the alphabetic text baseline. Apparently, this is more consistent across browsers, and more consistent with the way the browser handles it nativ... read more »

• Rendering Text To Canvas With Adjusted X,Y Offsets For Better Cross-Browser Consistency

  Posted on Sep 12, 2022 at 9:45 AM

  @Hassam, Agreed! Way too much work for something that feels like it should just work out-of-the-box. I'd be curious to see how the html2canvas library handles it. That library can reproduce a more-or-less pixel-perfect screenshot of HTML by recreating it on Canvas. They must have to take t... read more »

• Avoiding Self-Closing IFRAME Tags Using htmlParse() In Lucee CFML 5.3.4.80

  Posted on Sep 5, 2022 at 6:16 PM

  @Johannes, I don't know about any bug reports. The core of the problem is that Lucee is parsing HTML into XML, and XML just has different rules about what is and is not valid. Lately, I've been using jSoup to do the HTML parsing. Yes, it's a 3rd-party library that I now have to pull-in... read more »

• Bucketing Dates Using floor() In ColdFusion

  Posted on Sep 3, 2022 at 11:20 AM

  As a fast-follow to this post, I wanted to look at using ColdFusion's native dateTimeFormat() and parseDateTime() functions in order to approach "bucketing" from a different angle: https://www.bennadel.com/blog/4317-tokenizing-date-time-values-in-lucee-cfml-5-3-7-47.htm Th... read more »