July 12th, 2020

Hooking Price Filters into Product Search Engine

As a user, I want to be able to search “cheap tape” or “expensive tape” and have the outcome bring to to relevant filtered results. Or even “cheap scotch tape” Bear in mind, the “Adhesive Tape” category isn’t that sexy. This would make better use cases for “cheap laptop” or “high-end computer chair” or other […]

July 12th, 2020

The Making of a Slider

This blog is about this slider. First a little back story. This is a price filter. But in order for a price filter to work, you need to have products and prices which were feats in and of themselves. These prices come from competing distributors such that best prices are always calculated from the cheapest […]

PHP Optimisation

Work period: June 10 through June 30, 2020. Overview: CSV files from 17 different sources/formats are needed for regular inventory and price updates. Each CSV file can have upto 750K products resulting in upto 1.5M database (stock + price) writes. There are ~120 CSV files to be processed. We process these files after hours in […]

May 16th, 2020

Transfer files from Android to PC via SSH

I found many articles on how to transfer files from PC to android with ssh. But the articles on getting files off were challenging. What I really wanted to do is be able to clear out my camera roll to my PC which means transferring and deleting. I used an Android app SimpleSSHD on my […]

Database Indexes

One of the most important concepts in database design is Indexes. But don’t I mean Indicies? No. Indexes. That’s how I roll. Fundamentally, Indexes are like pointers to locations. To make things findable fast, in any situation, it helps to be able to point to the exact location you need to go to get whare […]

Why is MySQL with JSON Support “Fucking Tight”?

Earlier this month, I wrote about MySQL with JSON support being “fucking tight”. This might be the first time I can recall quoting myself, but fair warning… I kind of like it. Allow me to elaborate. When you process form data through HTTP’s POST protocol for example, to get it into a MySQL database previously, […]

MySQL w/ JSON Support

Man… MySQL with JSON Support is fucking tight! Pull out the keys and save the rest as JSON. It’s that simple.

First Principles

First to give you some context, I only became aware of the phrase “First Principles” recently. I don’t quite know everything there is about it, but I have started to look at this from a software development perspective in the work I create and I can tell you how I am applying what I know […]

Bad Defaults

It happens to the best of us. In development, everything has to land somewhere. There has to be default behavior where a user experience can be optimized. One example of default behavior is Google search results. The result is that you get the exact pages you want on the first page of Google’s results. I […]