Hello out there web friend.

My name is Jeff.

Thanks for connecting.

Parsing HTML/XML with NodeJS and cheerio

May 3, 2019 | Posted in JavaScript

Eventually, this post will be a small part of a long post-mortem describing a ton of unexpected challenges I’ve faced recently trying to wrangle so historical geospatial data. However, this post is going to look at just one piece of that long process where I used the NodeJS library cheerio to help clean-up a GeoJSON […]

Read More

Scaling WordPress Databases | Remote Servers, Sharding, and Replication with Ludicrous DB and AWS

April 10, 2019 | Posted in AWS,WordPress

As I frequently do, I’ve been taking a deep dive over the last few weeks into a very cool intersection between the WordPress and AWS ecosystems all in pursuit of the most scalable and turn key database structure for WordPress multisite. In this post, I’ll share some of the results of my research and walkthrough […]

Read More

Match Multiple Patterns with GREP And

March 7, 2019 | Posted in Linux

We’ve been dealing with some decently complex system-level issues for awhile on Rampages. In an effort to track them down to the source, I’ve been digging through lots of log files. While we still don’t fully understand what is happening yet, I’m learning a lot more about sys admin type tools for tracking bugs across […]

Read More

Retrieve Rows from Google Spreadsheet with Google Apps Script

March 1, 2019 | Posted in Google Apps Script,Google Sheets

After answering 100’s of Google Apps Script questions, I realized how many projects people are working on that start with a Google Spreadsheet as a base. A lot of my existing examples involve using a Google Form to trigger scripts that do things to data being written to a spreadsheet, so I typically have to […]

Read More

Fixing PHP Warning: mysqli_real_connect(): (HY000/2002): with WP CLI and MAMP

February 21, 2019 | Posted in WordPress

This will be a short post, but I felt it necessary to do since I had to deal with this is a non-standard way given my situation. I decided to play around with WP CLI to scaffold out the theme for a project that we are starting, but ran into a few configuration issues. It […]

Read More

Setup AWS CloudFront for WordPress | Scaling this Blog

December 7, 2018 | Posted in AWS,WordPress

Over the past few years, this site has gone through some pretty substantial changes. After getting hacked on BlueHost sometime in 2016, I reworked the entire site architecture using hand-rolled resources on AWS. While this taught me a lot, it has been increasingly expensive and time-consuming. To keep my costs down, I’m really relying on […]

Read More

Translate Text Selection in a Google Doc using Google Apps Script

October 5, 2018 | Posted in Google Apps Script,Google Drive

In this quick tutorial, we’re going to build a simple little menu add-on for Google Docs that lets you translate text into another language. Some of this functionality may be baked into Google Docs at this point, but this should be a good tutorial that wraps together a few different services and methods of augmenting […]

Read More

Auto Fill a Google Doc from a Google Form Submission

September 17, 2018 | Posted in Google Apps Script,Google Drive,Google Sheets

It’s been awhile since I have written anything to do with Google Apps Script, so I decided to start exploring some features of the Apps Script world that are new to me. When I first got started with Apps Script almost 6 years ago, there were lots of things I wanted to do, but just […]

Read More

Creating a Virtual Assistant with Amazon Lex and Lambda

August 29, 2018 | Posted in AWS,JavaScript

In a previous post, I wrote about some of my experiences building chatbots with the Amazon Lex platform, and I guess this post will represent the culmination of that experimental work into a production ready tool. Throughout this process, I’ve learned a lot more about building applications using AWS services, but it has also helped […]

Read More

Using the Right Tools: Indexing in MySQL

August 27, 2018 | Posted in MySQL

As I’m sure this is with most people, my deepest learning moments come from random walks down different avenues. In preparation for a GIS focused project I might get to work on, I spent a few minutes reviewing the geospatial features available in MySQL, which lead me down some side research into database indexes. You […]

Read More