Written by code-diesel
/ Original link
on Jan. 16, 2021
A recent project required me to write a automated SSL certificate checker that would ping me every-time a SSL renewal is due. The project required to parse a handful of client sites and get the SSL information. Reading a SSL certificate directly from a domain is relatively simple in PHP. A working…
Written by code-diesel
/ Original link
on Oct. 30, 2020
Unlike many other fields data-science projects should start with focused questions. A table of data is not of much use in itself unless we analyse and understand it with a specific goal in mind. Without a predefined goal we would not know where to start – what to look for in the data, how to analyz…
Written by code-diesel
/ Original link
on Oct. 30, 2020
For the past several years I’ve regularly consumed Pantoprazole – a proton pump inhibitor (PPI) – to control my acid reflux. However, as it is well know, regular PPI use causes various health problems. I’ll not enumerate those here, but trust me when I say that they are numerous. Last year I decide…
Written by code-diesel
/ Original link
on Oct. 21, 2020
The following short PHP code will enable you to extract urls from a standard WordPress xml sitemap or any other website sitemap adhering to the sitemap schema. # extract-urls.php # # Extract only URLS from a XML sitemap. # Sitemap schema : https://www.sitemaps.org/protocol.html if(count($argv) getN…
Written by code-diesel
/ Original link
on Nov. 28, 2019
Missing data in databases can cause bugs in applications or incorrect calculations. Recently, while working on a RETS application, I needed to ensure that not many missing values were encountered in one of the MySQL tables. Although one could easily write a SQL query to find the percentage of missi…
Written by code-diesel
/ Original link
on Apr. 26, 2019
A recent debugging session on a web application surfaced a recurrent issue in database design – that of assigning a wrong data type to a database field. Storing numeric data in a numeric field, when is it not recommended? Many programmers, when designing a database schema, default to using a numeri…