Uncategorised Blog Posts

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 […]

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”.

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 […]

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, […]

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 […]

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#.

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 […]

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. […]