So I had this problem. I need to get 17++ variations of CSV files for price/inventory updates. Perfect place to make a parent class with most of the common functionality and child classes where each child overrides functions: loadCSVFile() //uniquely fetches inventory/price file from FTP, Email Attachment, SFTP, HTTP, etc. updateProducts() //parses files specific fields, […]
Blog Posts
July 3rd, 2020
Experience with PHP
I have made at least 1 of each of the following in PHP: Admin Panel Punch Clock Mass Mailer Affiliate Program Admin Tools Admin Reports Contract PDF Generation Lease Program Search Engine Inventory Management System Price Management System Inbound Payment System Outbound Payment System Cron Scheduler Support Ticket System/CRM Ad Tracking System Web crawler Backup […]
July 3rd, 2020
Implementation using C# or equivalent platform
So it would make sense that C# would be necessary for integration on the app. I am probably not the best person to work on C#.
July 3rd, 2020
RESTful API Design
I have implemented many APIs integrations. The story usually goes: some CURL CRUD under the hood and wrapped in a library that has various degrees of being documented well. In 2017, I outlined what is good/bad about API Implementations on my API Integration skill page. Writing an API for third parties to connect to, should […]
July 3rd, 2020
How I Design and integrate multi-component systems
First, identify all components and define their interactions. Build data. Build admin tools to support manual entry and privileged access to the data. Design any state machines which users walk through. Walk through front end UX refining step by step. Refine back end data as needed. Implement front end, work through edge cases, corner cases. […]
July 3rd, 2020
My Education
In case you were wondering if my education meets BS/MS in Computer Science or equivalent degree. Well, yes it does. I obtained a Computer Science degree from Carleton University in the field of Network Computing. Class of 1999 to 2003. I also obtained enough mathematics credits to obtain a Minor in Mathematics.
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 […]
NKLA
Such a hot topic. Is NKLA the future? Are they a TSLA killer? There are many factors involved. But none which I would consider more important than cost per mile driven. I have a bias. As a TSLA shareholder, I am more invested in TSLA succeeding. But even beyond that, I have been brainwashed (all […]