Andrew Kretzer

Recent Blog Comments By Andrew Kretzer

• What Files Should Live In The WwwRoot Folder?

  Posted on Dec 8, 2022 at 12:53 AM

  That's nearly identical to the way I set it up as well. Here's an older, but relevant, article discussing this that you might find interesting: https://blog.adamcameron.me/2012/10/organise-yer-apps-properly.html... read more »

• A Database Column For "Date Updated" Has No Semantic Meaning, Nor Should It

  Posted on Oct 28, 2022 at 12:34 PM

  @Ben, Right on. Like you, I too have the same 3 default fields on each table, but both createdOn and updatedOn are auto populated by MySQL on INSERT and UPDATE respectively.... read more »

• A Database Column For "Date Updated" Has No Semantic Meaning, Nor Should It

  Posted on Oct 28, 2022 at 12:47 AM

  Out of curiosity, is there a reason that you don't let the database generate that field? E.g. "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" in MySQL.... read more »

• Parsing Nullish Date "0001-01-01T00:00:00Z" In Lucee CFML 5.3.8.201

  Posted on May 20, 2022 at 6:26 PM

  Completely off-topic, but I just want to mention how I LOVE that all of the code examples on your blog auto-expand horizontally on hover. I find the need to horizontally scroll to read code on 99% of blogs and articles infuriating. Thanks for going the extra UX mile here!... read more »

• Moving MySQL To A Per-Application Datasource In ColdFusion 2021

  Posted on Mar 4, 2022 at 6:00 PM

  @Ben, In Lucee you can also see how to set any individual setting by clicking the <?/> next to the setting in the Lucee admin.... read more »