Ben Nadel

Recent Blog Comments By Ben Nadel

• Request Tracing Propagation When Consuming Amazon SQS Queues In Lucee CFML 5.3.8.201

  Posted on Sep 20, 2021 at 5:29 AM

  @Charles, 💪 Noice!... read more »

• I Wish My Relational Database Tables Were Narrower

  Posted on Sep 20, 2021 at 5:18 AM

  @Adam, 1000% on naming stuff becoming harder when you have smaller tables with fewer columns. That, along with not being able to predict the future (I, too, am working on that) means that we have a lot of tables with names that make life a lot harder. And, the idea of renaming tables is a ... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 20, 2021 at 5:13 AM

  @Paul, 100%, I completely get what you are saying. And, in an ideal world , I think you are correct. But, in my particular context, we have a tiny team responsible for a lot of services. So, even something like a simple Lambda function can represent an unpleasant operational burden when s... read more »

• Request Tracing Propagation When Consuming Amazon SQS Queues In Lucee CFML 5.3.8.201

  Posted on Sep 20, 2021 at 5:07 AM

  @Charles, Yeah, "when to lock" is always a little fuzzy in my head, especially when we're dealing with a layer of abstraction above the Java layer. The way I understand it, Structs are synchronized under the hood. Meaning, it's always safe to have multiple requests read/write... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 19, 2021 at 3:05 PM

  @All, Continuing on my exploration of Amazon SQS , I wanted to start thinking about request tracing . That is, how to associate the pre-queue portion of a workflow with the post-queue portion of a workflow for the purposes of logging and debugging: https://www.bennadel.com/blog/4118-... read more »

• Using SMTP Headers To Send Custom MetaData Through Postmark In Lucee CFML 5.3.6.61

  Posted on Sep 19, 2021 at 7:44 AM

  @Jonas, Awesome, so glad you found this helpful :D... read more »

• Spreading SQL And CFQueryParam Tags Across Multiple Function Calls In Lucee CFML 5.2.9.40

  Posted on Sep 18, 2021 at 6:22 AM

  @All, It looks like this technique works generally with tags in Lucee CFML. I just tried the same technique with the http and httpParam tags: https://www.bennadel.com/blog/4117-spreading-http-and-httpparam-tags-across-multiple-function-calls-in-lucee-cfml-5-3-8-201.htm In that p... read more »

• Working Code Podcast - Episode 040: Are Database Transactions Overrated?

  Posted on Sep 17, 2021 at 7:14 AM

  @All, On Twitter, Mat Keep pointed me to a whitepaper he wrote on MongoDB transactions . In it, there is some discussion on how powerful transactions are in a MongoDB-based application: MongoDB already served many of these use cases before the addition of multi-document transactions... read more »

• Working Code Podcast - Episode 040: Are Database Transactions Overrated?

  Posted on Sep 17, 2021 at 6:56 AM

  @Danilo, All excellent suggestions 💪... read more »

• Serializing A MySQL RecordSet As A Set Of INSERT Statements Using Lucee CFML 5.2.9.40

  Posted on Sep 17, 2021 at 6:36 AM

  @All, So, over the past two days, I've been working on some data remediation for a client (who accidentally bulk-removed users from our platform). And, as part of that remediation, I've had to generate INSERT statements from SELECT statements directly within MySQL: https://www.be... read more »

• Using ColdFusion Custom Tags To Create An HTML Email DSL In Lucee CFML 5.3.7.47

  Posted on Sep 16, 2021 at 6:13 AM

  @All, While note related to this DSL - yet - I ran into an issue recently wherein Yahoo! Mail won't render an anchor tag ( <a> ) if the href attribute contains an encoded protocol. I had to start backing-out of the attribute encoding a bit: https://www.bennadel.com/blog/411... read more »

• Working Code Podcast - Episode 040: Are Database Transactions Overrated?

  Posted on Sep 16, 2021 at 5:57 AM

  @Danilo, This really hit a nerve: Of course, the default implementation fails so infrequently, that devs haven't been bitten enough by the pain of their database interactions failing. I feel like this applies to so many aspects of application architecture in general!. Even wit... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 13, 2021 at 6:26 AM

  @Paul, These are all good points - thank you for clarity on what you were intending. Though, I don't want to over-state the CPU / resource overhead of running a loop that is perhaps mostly blocking-and-waiting. After all, any given ColdFusion server is already processing dozens / hundreds ... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 12, 2021 at 12:54 PM

  @All, After looking at the low-level mechanics of writing to / reading from an AWS SQS queue in Lucee CFML, I wanted to step back and think about a more holistic integration that includes the long-polling . In my follow-up post, I am doing this using a scheduled task: https://www... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 12, 2021 at 12:52 PM

  @Paul, I have only slightly more experience with Lambda than I do with SQS, which is to say, very little for either 😖 That said, I am not sure that there is anything inherently wrong with having a long running thread in ColdFusion. I'm actually just writing another post wherein I use ... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 12, 2021 at 12:50 PM

  @Charlie, Sorry about that. It looks like there was a space between the ] and the ( characters, so the markdown parser wasn't seeing it right. I have edited it.... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 9, 2021 at 8:54 AM

  @Charlie, Ah, very cool - I'll look more closely at the end of the docs, thanks!... read more »

• Producing And Consuming Amazon SQS Messages In Lucee CFML 5.3.8.201

  Posted on Sep 9, 2021 at 8:04 AM

  @Charlie, Excellent commentary. I actually looked through the page you documented while I was working on my implementation - looking for ideas and for things that I missed (especially since I have so little hands-on experience with message queues in general). I'm excited that ACF 2021 ha... read more »

• I Wish My Relational Database Tables Were Narrower

  Posted on Sep 7, 2021 at 6:21 AM

  @Advocate, I know other people at work rave about GraphQL. I'll have to try and find time to look into it more deeply. I've tried a few times, but was turned-off by the amount of up-front work I seemed to have to do with all the schema definition. It sounds like perhaps DGraph removes some ... read more »

• I Wish My Relational Database Tables Were Narrower

  Posted on Sep 4, 2021 at 5:36 AM

  @Stevef, I've read about event-sourcing, but I don't have any hands-on experience with it. In theory, I love the concept of materialized views and building denormalized tables that implicitly represent joined data and data that has been pre-manipulated for a given view's use-case. But,... read more »