Adam

Recent Blog Comments By Adam

• The Beauty Of Modular Code: Adding Different Transports To StatsDGateway

  Posted on Jun 22, 2015 at 3:01 PM

  Hi Ben, Sorry for the pedantry but should 'trasports' be 'transports'? I am rubbish at spelling though, so I'm probably wrong, or misreading. Adam... read more »

• Using GREATEST(), LEAST(), And Date/Time Values With COALESCE() In MySQL

  Posted on Mar 16, 2015 at 9:03 AM

  @Ben, Yes, your only guessing until you try it with the real data. I'll try out using LEAST() and GREATER() next time I do something like that. Its a new approach for me any way guess the more possibilities the better.... read more »

• Using GREATEST(), LEAST(), And Date/Time Values With COALESCE() In MySQL

  Posted on Mar 13, 2015 at 11:36 AM

  Hi Ben, Were LEAST and GREATEST fast enough, was thinking I would approach it naively something like this, SELECT max(d), min(d) FROM( SELECT UTC_TIMESTAMP() as d UNION SELECT CAST( '2015/07/04' AS DATETIME ) as d UNION SELECT NULL as d )b ORDER BY d ASC but LEAST( and GREATEST( do seem more... read more »

• MySQL GROUP_CONCAT() Has Buggy Interaction With UNION Clauses

  Posted on Aug 12, 2014 at 12:10 PM

  Oddly I get 147 throughout guess its into mysql settings their though because my version is only a little off yours 5.6.14 Guess that just makes it worse :)... read more »

• MySQL GROUP_CONCAT() Fails Silently When It Hits Its Size Limit

  Posted on Aug 8, 2014 at 8:28 AM

  Yes, think your right. It looks like you can tweak that length, http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_group_concat_max_len but it seems better throw an exception than fail or truncate silently... read more »

• MySQL GROUP_CONCAT() Fails Silently When It Hits Its Size Limit

  Posted on Aug 8, 2014 at 4:20 AM

  Hi Ben, I like group concat but people do go against it. I think because its not in the 'standard' sql. Its quite neat/convenient in more complicated queries where you want to do a whole load of stuff and get somethings summarised. For example when I know there are only going to be a few records.... read more »

• The User Experience (UX) Of Sketching In Prototyping

  Posted on Apr 25, 2014 at 10:06 AM

  @Ben I can't think of the word either :) 'Mapping' maybe I think is the term they use in 'The Design of Everyday Things'.... read more »

• The User Experience (UX) Of Sketching In Prototyping

  Posted on Apr 23, 2014 at 8:58 AM

  Sketching out with a pen is just so much quicker and less restrictive for me at least. With whatever computer interface I end up getting all tidy lining stuff up and looking at fine appearance. Think with pencil or pen on paper it sometimes helps giving the weight to the most important elements. W... read more »