Scott Steinbeck

Recent Blog Comments By Scott Steinbeck

• Code Kata: Box Breathing Exercise With SpeechSynthesis And Alpine.js

  Posted on Dec 20, 2024 at 6:03 PM

  Funny enough i have just started playing with both the Voice to text and the Speech synthesis features in the last couple weeks. My favorite voice is "Google UK English Male" which i think is only available in Chrome. Here is a nice Demo of all of the languages. https://mdn.git... read more »

• ColdFusion: Comparison Method Violates Its General Contract

  Posted on Sep 6, 2024 at 6:28 PM

  This is really funny because I just ran into this error and I've never seen it before. But thank you for digging into it because I thought it was due to me having a comparison that resulted in numbers bigger than 1,-1 not resulting in 0!... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Feb 13, 2023 at 5:30 PM

  @Ben, Yikes 😱, it is definitely a limit that should either not exist or not fail silently. I have had a similar experience where I was sending out text notifications to a list of users and about 20% weren't receiving anything. It was really hard to track down.... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Feb 9, 2023 at 2:17 AM

  @Mike, I would assume GROUP_CONCAT is faster, but just be aware, there's a hard limit on how many results GROUP_CONCAT can return that is not the case in JSON_ARRAYAGG I don't believe... read more »

• Using LATERAL Derived Tables To Gather Row-Specific Aggregations In MySQL 8.0.14

  Posted on Mar 7, 2022 at 7:35 PM

  Ok so I checked it out and Yes you can do this in MySQL. The premise of a LATERAL JOIN is that you are able to use row-level column data in a JOIN. Typically this would be to join another table but it can just as easily work as a temporary table. Here is a real-world example: SELECT b... read more »

• Using LATERAL Derived Tables To Gather Row-Specific Aggregations In MySQL 8.0.14

  Posted on Mar 7, 2022 at 6:35 PM

  You can also use LATERAL to move calculated column data into a LATERAL statement (at least in Postgres, haven't tried in MySQL). SELECT a.total_bill FROM billing_table bt LATERAL (bt.previous_bill - bt.current_bill as total_bill) a WHERE a.total_bill > 200 instead of SELECT bt.p... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Mar 4, 2022 at 8:42 PM

  @Ben, It depends on the use case, for me I need to use it in javascript so previously I was generating my structs in ColdFusion, now that the entire process is automatically created by the database engine, including typecasting and character escaping (I'm assuming), making the process faste... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Mar 4, 2022 at 8:16 PM

  @Ben, During exploring I got even more excited with using the JSON_OBJECT function that easily lets me generate grouped JSON output: SELECT JSON_OBJECTAGG(id,JSON_OBJECT('name',name,"acres",round(acres,2))) FROM ... output serializeJSON: {"5065": {"name&q... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Mar 4, 2022 at 8:06 PM

  Literally just hit another issue in my code from using group_concat due to length truncation. Glad this post was written so I have an alternative solution. Thanks! 😀... read more »

• Goodbye GROUP_CONCAT(), Hello JSON_ARRAYAGG() And JSON_OBJECTAGG() In MySQL 5.7.32

  Posted on Feb 28, 2022 at 8:09 PM

  This is really exciting, I have been doing a few things with JSON in MySQL 5.7 but assumed most of the JSON functions were only in MySQL 8 so I have been doing everything in ColdFusion/javascript which is super limiting and slow. After looking at the docs, the number of JSON functions availa... read more »