Danilo Celic

Recent Blog Comments By Danilo Celic

• Working Code Podcast - Episode 107: Through The Wormhole

  Posted on Dec 28, 2022 at 4:07 PM

  @Ben, Re: Hotwire: Adobe Spry has a similar feature where you'd specify a URL and way to identify a table, you'd then be able to work with the data from that other page. The following seems to be what I think I'm referring to: https://opensource.adobe.com/Spry/articles/html_dataset/index... read more »

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

  Posted on Sep 20, 2022 at 4:35 PM

  Regarding SQL code hints after a comma: Consider using a comma first format, that is, the comma is at the start of a line, not at the end of a line. The main reason I like it is from a source control perspective, when you add a new column to the SELECT, then the changeset is only the line t... read more »

• Working Code Podcast - Episode 87: Note To Self

  Posted on Aug 23, 2022 at 3:28 PM

  Glad to be a positive impetus... read more »

• Working Code Podcast - Episode 87: Note To Self

  Posted on Aug 10, 2022 at 4:24 PM

  @Ben, Time to update the Podcast page cache, currently showing up to episode 83... read more »

• Working Code Podcast - Episode 76: Ben Needs A Minute

  Posted on May 25, 2022 at 3:29 PM

  @ben "Shake and Bake" is most definitely "Talladega Nights: The Ballad of Ricky Bobby" My affirmation for you: Ben, you're doing a great job improving your customer's work life! FYI: Your Podcast page is missing the last two entries (75 and 76). is the Podcast page ma... read more »

• Performing A Double-Check Lock Around "Run Once" Code In ColdFusion

  Posted on Feb 7, 2022 at 4:09 PM

  @Ben, I use double checked locking anywhere I'm using caching in C#, especially after being burned a couple of times early on calling expensive database calls much more often that I expected shortly after coming from the single-threaded JavaScript environment in a browser. I've suggested do... read more »

• Working Code Podcast - Episode 048: TODO: Microwave ToDo List

  Posted on Nov 22, 2021 at 3:21 PM

  Regarding Copilot: A YouTube C# related channel that I watch sometimes by Nick Chapsas has an unscripted video about test driving Copilot and he is floored by what it can come up with: https://www.youtube.com/watch?v=XceIKXeIrD0... read more »

• Working Code Podcast - Episode 048: TODO: Microwave ToDo List

  Posted on Nov 22, 2021 at 3:21 PM

  Regarding Copilot: A YouTube C# related channel that I watch sometimes by Nick Chapsas has an unscripted video about test driving Copilot and he is floored by what it can come up with: https://www.youtube.com/watch?v=XceIKXeIrD0... read more »

• Working Code Podcast - Episode 043: Relay Race Programming

  Posted on Oct 7, 2021 at 11:22 AM

  @Ben, I totally get leaving code better than when you found it, but based on how you were talking about having a negative reaction when someone else's touches your code, it seems that you're not quite feeling it if it is someone else tries to leave the code better when it's your code. ... read more »

• Using WHERE TRUE To Create Dynamic, High-Performance SQL Queries In MySQL 5.7.32 And Lucee CFML 5.3.8.201

  Posted on Oct 7, 2021 at 11:07 AM

  @Ben, Just tried in SSMS with WHERE TRUE AND id = ? And I get an error: An expression of non-boolean type specified in a context where a condition is expected, near 'AND' A very quick search seems to indicate that SQL Server doesn't support boolean data types (would love to ... read more »

• Using WHERE TRUE To Create Dynamic, High-Performance SQL Queries In MySQL 5.7.32 And Lucee CFML 5.3.8.201

  Posted on Oct 7, 2021 at 10:32 AM

  @Ben, I've always used the following to start off my queries (for SQL Server): WHERE 1=1 Given it equates to TRUE, it would probably would also be excluded from the plan, but the main reason I use it is that when working in my database manager (SSMS : SQL Server Management Studio), i... read more »

• Testing BIGINT AUTO_INCREMENT Usage In MySQL 5.7.32 And Lucee CFML 5.3.8.201

  Posted on Oct 7, 2021 at 10:01 AM

  Typo? Note that we are starting the increment at 5000000000 (4 billion).... read more »

• Working Code Podcast - Episode 043: Relay Race Programming

  Posted on Oct 6, 2021 at 1:38 PM

  @Ben, I too work on a team where we're pretty much always working on separate projects, and the only collaboration are at the intersection points not overlapping. I wish we had enough time to do more knowledge transfer, if only for better coverage during vacations, if not for handling team... read more »

• Generating SQL INSERT Statements From SQL SELECT Statements In MySQL 5.7.32

  Posted on Sep 23, 2021 at 1:32 PM

  @Ben, Looks like I'll need to check out a wider range of editors. My current IDE/Editor Visual Studio 2015 at work doesn't support multiple cursors. I can do multiple line edit with ALT+Mouse, and that's been useful quite a few times. It is limited compared to what I've seen multiple curso... read more »

• Generating SQL INSERT Statements From SQL SELECT Statements In MySQL 5.7.32

  Posted on Sep 21, 2021 at 12:00 PM

  I've been pasting the results of my SQL into Excel and then using the CONCAT formula to generate the SQL I need (be it INSERT, UPDATE, or sproc call). Nice tip, Ben! I'll give it try the next time I need to create bulk SQL statements.... read more »

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

  Posted on Sep 16, 2021 at 12:12 PM

  @Ben, For actions that are unlikely to have multiple submissions fractions of a second apart as part of the user's workflow, I handle the multi-click submission by disabling or replacing the button/link once it has been clicked (showing some sort of processing animation as well should the ... read more »

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

  Posted on Sep 15, 2021 at 12:49 PM

  @ben Regarding the conversation about MongoDB transactions: The way you phrased it, it sounded like the developer creating the transaction support for MongoDB was saying that 90% of users won't use the feature, but when you was reacting to that, you phrased it like you didn't understand w... read more »

• Working Code Podcast - Episode 035: Being A Swamp Guide

  Posted on Aug 13, 2021 at 10:10 AM

  @Ben, We're currently only a team of 3 (was 4 about 2 months ago, and that person was there just over 9 years), and the only dev team in the company. By necessity, we've all taken over certain areas (fiefdoms?) of our applications, which of course, has both been good and bad. The good is t... read more »

• Working Code Podcast - Episode 035: Being A Swamp Guide

  Posted on Aug 12, 2021 at 2:10 PM

  We've replaced "hit by bus" with "wins the lottery" as it feels less gruesome. The current team I'm on doesn't have anyone that's been on the team less than 9 years, so we're all swamp guides at this point 😎 FWIW: I feel the same way about Confluence as you do Ben, in th... read more »