Advanced git

https://youtu.be/duqBHik7nRo Just putting this here for later. A git talk that covers everything that I wonder about with git. Also the speaker has a book which going by her previous courses will be excellent.

read more

Use FORCE INDEX

Just putting this here as I have a SELECT in MySQL that was taking 1.946 sec to return 20 records from a table with 159884 records when using a ORDER BY DESC on a DATETIME field Creating an index and changing the FROM to FORCE INDEX () dropped it down to 0.00079 sec /...

read more

Using a git repo as a composer repository

In CakePHP variable visibility is generally defined using this standard: public $defaultConfig; protected $_defaultConfig; private $__defaultConfig; Just had a situation where I had extended a class and one variable from the base class was marked as public. My VSCode...

read more

AWS to Digital Ocean DNS Record Migration

Just completed a migration away from AWS to Digital Ocean Need to install the Digital Ocean dotctl command line utility (this is using brew on a mac) brew install dotctl Transfer domain records away from AWS using the aws-cli #!/bin/bash domains=$(aws route53...

read more

Format validationsErrors

A recursive function that takes a validation error array and return a string with all the different errors concatenated into a formatted string Further to my previous posting https://toggen.com.au/blog/it-tips/cakephp-2-displaying-validation-errors This function will...

read more

PHP Version Gotcha

Just copied some code from a PHP 7.3+ development environment to the server running PHP 7.2 On the server I am getting this On PHP 7.3 it runs fine Because the line number is not listed this is how I find the problem Find which controller is being called when you see...

read more

Remove Sensitive Data from Git Hub

If you follow the faqs on github it will say you can use bfg to remove sensitive data https://help.github.com/en/github/authenticating-to-github/removing-sensitive-data-from-a-repository Here are my learnings bfg has to be run from the root of the git repository i.e....

read more