Hello out there web friend.

My name is Jeff.

Thanks for connecting.

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

Load Testing WordPress Multisite

August 2, 2018 | Posted in WordPress

Over the last few weeks, we’ve been dealing with some heavy fallout from a recent server migration on our large WordPress MU installation. While moving everything from Linode to Digital Ocean should give us a more powerful toolset, save on costs, and give us more infrastructure flexibility, I wish the cut over was uneventful. On […]

Read More

Recursive Recursion with Vue

July 25, 2018 | Posted in JavaScript

We’ve been working on a project with some of the folks from the medical campus since I’ve been at VCU. They are developing a large OER site for Histology, which is the study of cells, but we’re approaching a point where this single site has over 1000 pages in a nested menu structure. Since the […]

Read More