adam

Recent Blog Comments By adam

• Trying To Get The Most Trustworthy IP Address For A User In ColdFusion

  Posted on Oct 25, 2022 at 12:24 PM

  I suppose the next thing is what do you do if the IP is wrong/faked, sometimes it may not matter. Other times you might want to cfexit and stop because its a clear sign of a malicious actor. Its difficult to use IP to determine anything if you have a whole load of users coming from the same ... read more »

• Mitigating Cross-Site Scripting (XSS) Attacks With A Strict Content Security Policy (CSP) In ColdFusion 2021

  Posted on Jan 6, 2022 at 3:22 PM

  Yes, things are never as neat as you would like them to be. Security is a bit of a wormhole, its interesting though.... read more »

• Mitigating Cross-Site Scripting (XSS) Attacks With A Strict Content Security Policy (CSP) In ColdFusion 2021

  Posted on Jan 6, 2022 at 2:16 PM

  I sympathise with evaluating the logs its a pain, they are pretty cryptic and like you say its hard to separate out plugins, I think sometimes folks have things in their browsers that are not quite what they think they are. I found this securityheaders.com helpful when i was trying to eval... read more »

• I Wish My Relational Database Tables Were Narrower

  Posted on Sep 20, 2021 at 3:08 AM

  Also narrower tables means more tables which can get out of control as well. Naming can get more difficult.... read more »

• I Wish My Relational Database Tables Were Narrower

  Posted on Sep 20, 2021 at 2:53 AM

  It is quite hard though to work out which columns will be used in some circumstances and after sometimes how much they are used. Once they are in that table and you think to remove them your left wondering should I be spending my time doing something else, perhaps more worthwhile. When the ... read more »

• Thought Experiment: Splitting A Single Data Table Up Into High-Writes And High-Reads For Better Performance In MySQL

  Posted on Oct 11, 2019 at 9:20 AM

  @Adam, oops sorry mistyped meant each userId to be the same number so 1, 0, '2019-10-11 15:06:00', 1, 15, '2019-10-11 15:06:07', 1, 30, '2019-10-11 15:06:06', 1, 45, '2019-10-11 15:06:01',... read more »

• Thought Experiment: Splitting A Single Data Table Up Into High-Writes And High-Reads For Better Performance In MySQL

  Posted on Oct 11, 2019 at 9:18 AM

  Hi Ben, Could you do something like multiple rows for each users presence so say for the table userPresence you had UserId, Segment, Timestamp 1, 0, '2019-10-11 15:06:00', 2, 15, '2019-10-11 15:06:07', 3, 30, '2019-10-11 15:06:06', 3, 45, '2019-10-11 15:06:01', Then when you want to... read more »

• Programming Is Hard: Reconciling Server-Side And Client-Side "Clean" Architectures

  Posted on Feb 28, 2017 at 7:06 AM

  @Ben I to would want that info to provide the context when trying to debug the issue even if it is a bit hacky. The information you mention is a bit like the database key for the issue. Globals are legitimate to use, I think, if they didn't exist some would invent them :) and at least in Coldfusion ... read more »

• Programming Is Hard: Reconciling Server-Side And Client-Side "Clean" Architectures

  Posted on Feb 27, 2017 at 1:47 PM

  Hi Ben, If you log the error in the code as close to where it happens then it will (probably) make it easier to debug. Then your returning a response or dieing. If your returning a oops response like a 500 then perhaps it's up to the requester to deal with that or die. If your not going to stop o... read more »

• High Performance MySQL: Optimization, Backups, And Replication By Baron Schwartz, Peter Zaitsev, And Vadim Tkachenko

  Posted on Oct 21, 2016 at 2:58 PM

  There is loads of good stuff in that book I come back to it over time and read odd chapters. Which you have just prompted me to do again thanks Ben.... read more »

• What The Heck Is Business Logic Anyway?

  Posted on Dec 15, 2012 at 4:44 AM

  Hi Ben, I wouldn't worry about it to much 'People' say a lot of stuff. The vast majority of people are just muddling through in the best way they can. If you build it in the way that makes it simpler to maintain and easier for other people on your team to understand then surely your doing the right... read more »