I was super fortunate to learn Database Design from Jason Lee and Dan Van Staal Duinen at iSTORM in 2005. Learning from them was way better than SQL class. Beyond what I learned from them, I have really only added 2 major things. INNODB (We were using MYISAM @ iSTORM) and the JSON dataype. As […]
Blog Posts
July 3rd, 2020
Utilizing Well-Known Design Patterns
You: What are some well-known design patterns? Me: Well, I am glad you asked. Let me get back to you on that. I want to make sure I understand what you mean by “Design Patterns”. If by “Well-Known Design Patterns” you mean “code that works”, then I am good at “Utilizing Well-Known Design Patterns”.
July 3rd, 2020
Domain Driven Design
Hmm, I am trying to figure out what this would mean without looking it up. Domains I know as sites, but I would think that Tesla.com would be the only domain. Subdomains would be departments within sites, so subdomain driven design might make more sense. How else can Domains be interpreted? Domain Driven Design sounds […]
July 3rd, 2020
OOP&D
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, […]
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.