Posts

Showing posts from 2020

A Look Back on 50 Patents, and Initiating an Innovation Pipeline

Earning 50 patents in just two years is an incredible accomplishment.  My first US patent was granted on June 19, 2018, and my 50th happened June 23, 2020.  This is after beginning to file patents only in mid to late 2017.  How does one go about getting patents so quickly, especially in the highly crowded tech sector, and how can an organization facilitate such excitement among their staff to check for their names at 12:01 AM any given Tuesday?
This Process is Nuanced, and Expensive!
There is a lot of basic information about patents that you can read about or watch talks on from many other websites.  This includes information such as patents don't have to be complicated or some over-engineered gadget (lawyers make them seem like that, though!); what makes a good patent and what doesn't; why it's important to be first to file versus first to invent; how patents thread the eye of a needle to be written with enough specificity to be plausible, and implementable by someone profi…

Extensible Database Tester in Python, with Permutations

Here is some Python code that allows you to generate all combinations of options by choosing one item from an arbitrary number of different lists.  Not only that, but each option is actually a data structure that also includes lots of metadata about the ramifications of the option, in addition to the option value itself.
Let's say you're looking to run performance testing on different types of tables and underlying data arrangements in Amazon Redshift Spectrum.  You can devise a template SQL query that can be configurable in multiple ways.  For instance, you could choose between multiple tables or views from which to query data (say, if comparing Redshift to Redshift Spectrum performance), and you also want to see the performance of count(1) vs. count(*) to see if one uses more data or works quicker on Redshift vs. Spectrum.  Thus, you already have two lists of options, and need to come up with the four permutations of these options.
The Groundwork
Basically, to lay some ground r…