July 7th, 2020

Tesla Insurance

Wishing I could work to further develop Tesla Insurance.

July 3rd, 2020

Query Planning Experience

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

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