I come across multiple challenges every week that need solutions. Even though I don't necessarily know how to solve the problem initially, i'm confident in my abilities and the solution can be found and it's just a process I go through. One of my more challenging projects was Canvas Eyewear. I was at the time (3 … Continue reading One of my most Challenging Projects
Website Development
MySQL Query Execution Timeout
There are many reasons why you usually wouldn't allow a user to access or even process a raw query directly within a web app - even administrators. Recently I had a need to do just this. In my particular case, my need for accessing the database directly was for ease of use of creating and saving reports. This allowed those who know a little SQL to write there own reports with some 'magic' tools to automatically replace up to four placeholder values with input variables. No sensitive information is stored in this particular database, or at least, no sensitive information that an administrator of my app should not be able to access... this simplifies permissions for me. I opted to create a single MySQL read only user for this purpose. This at least stops someone from accidentally truncating a table or being tempted to insert and delete records directly (me included).
My Docker Cheat Sheet
I don’t think I am too different to most people where when you don’t use something regularly enough you tend to forget it. One of the big reasons for creating this blog was so that I could note down commands and snippets that I don’t use enough to remember but still need to reference it enough to note it down. Currently I am using Docker Compose for my daily use so all my commands are conveniently in a YAML file. Earlier today I was working on upgrading my MySQL container to the latest version… super basic entry level commands and stuff that I feel i should instantly know but just don’t do it enough to remember the exact command. These are my goto commands that i need … I’ll probably update this post as I need to add more.