Enabling and configuring PHP OPcache
OPcache is said to improve PHP performance by storing scripts in shared memory thus avoiding the need to load scripts on each request. Whilst seemingly basic, its setup and enabling…
The simple PHP PDO MySQL fetch (SELECT) types
The basics for PHP MySQL PDO fetch types, whether it be returning just one row, one column or looping through a full table SELECT call. The common 3 fetch types:…
A PHP function for making HTML tables
A PHP function to help reduce the load of duplicate code when producing HTML tables. This works by looping through an array for the thead (columns <–>) and then the…
Mount Alexander from drone
Mount Alexander Harcourt from drone.
The MySQL soundex function; Selecting names
Soundex is the algorithm for indexing names by sound or as pronounced. The MySQL SOUNDEX() function returns a Soundex string from a string supplied. It can also be used to…
HTML form input auto complete with PHP and MySQL
How to Autofill or auto-complete an HTML input form using JQuery with PHP and MySQL. This method uses LIKE in a MySQL query for the typed in characters and returns…
Barkers Creek Reservoir Harcourt full drone images
A very full Barkers Creek Reservoir in Harcourt drone images. BOM says 94.6% water level despite the fact that there is a light amount of water going down the spillway….
DJI Mavic Air 2 drone video zoom comparison
DJI Mavic Air 2 drone zoom comparison for 4k video. With 4k video you can digitally zoom to x2 this gets matched with a crop (scale) in Premiere Pro for…
FFmpeg h264 & h265 to WebM VP9 encoding comparison part 10; Screenshots
This part 10 has FFmpeg screenshots from the output WebM files from both h264 and h265 for CRF values 15, 22 and 30 with -cpu-used 0 to 5 and -deadline…
FFmpeg h264 & h265 to WebM VP9 encoding comparison part 9; findings
In this part 9 is the findings based on averages between the input codec type, deadline and cpu used parameters for speed, size and bitrate. Part 1 was h264 -deadline…