Skip to content

Instantly share code, notes, and snippets.

View mheadd's full-sized avatar

Mark Headd mheadd

303 followers · 13 following
View GitHub Profile
@mheadd
mheadd / add-front-matter.js
Created August 3, 2021 16:32
const { batch } = require('frontmatter-file-batcher');
// The name of the file to modify.
const file_name = process.argv[2];
// The name of the new front matter property to add.
let fm_property = process.argv[3];
// The value of the new front matter property
let fm_value = process.argv[4];
@mheadd
mheadd / Dockerfile
Created March 9, 2021 15:02
Dockerfile to run Drupal 7
FROM php:5.5-apache
RUN a2enmod rewrite
# install the PHP extensions we need
RUN apt-get update && apt-get install -y libpng12-dev libjpeg-dev libpq-dev \
&& rm -rf /var/lib/apt/lists/* \
&& docker-php-ext-configure gd --with-png-dir=/usr --with-jpeg-dir=/usr \
&& docker-php-ext-install zip \
&& docker-php-ext-install gd mbstring pdo pdo_mysql pdo_pgsql
@mheadd
mheadd / get-app-guid.sh
Last active May 3, 2020 21:58
Get usage stats for a cloud.gov application
#!/bin/bash
#
# A simple script to get a GUID for an applications. Note - assumes you have jq installed.
#
# The GUID for the app you want to check
APP_NAME=$1
if [[ ! $(which jq) ]]; then
echo "Error: You must have the jq utility installed to run this script. https://stedolan.github.io/jq/" >&2
@mheadd
mheadd / instructions.md
Last active April 9, 2021 12:26
Accessing PostGIS on a cloud.gov-brokered PostgreSQL database
@mheadd
mheadd / cg-ssh-tunneling.md
Last active June 29, 2021 14:42

Using an SSH tunnel to remotely administer a cloud.gov RDS

Cloud.gov let's you interact with your apps and bound services via SSH.

The cf-service-connect plugin lets you connect to your bound services, and is often your beset choice for interacting with services in cloud.gov. But what if cf-service-connect doesn't work for you (e.g., if you are using a newer version of the cf CLI?

SSH tunneling to the rescue!

Usage

@mheadd
mheadd / 1-Dockerfile
Last active February 11, 2020 17:51
A set of files that can be used to set up a MS SQL Server instance and populate a table with test data
# Install base image
FROM microsoft/mssql-server-linux
# Copy over the SQL file to set up the database
COPY setup.sql /
# Copy over the file with sample data.
# This data is from https://people.sc.fsu.edu/~jburkardt/data/csv/csv.html
COPY data.csv /
@mheadd
mheadd / get-issues.sh
Last active November 27, 2019 15:33
Fetch closed issues from a Github repo
##!/bin/bash
## The name of the Github account user or org
OWNER=$1
## The name of the repo
REPO=$2
## Append the file with listd of issues
curl -s "https://api.github.com/repos/$OWNER/$REPO/issues?page=1&per_page=100&state=closed" \
@mheadd
mheadd / keybase.md
Created January 26, 2018 23:33

Keybase proof

I hereby claim:

  • I am mheadd on github.
  • I am mheadd (https://keybase.io/mheadd) on keybase.
  • I have a public key ASDf5v_IBXcBfsgDRP1fwqY16evvJMtC_SLI6H_bMN1VpAo

To claim this, I am signing this object:

@mheadd
mheadd / find-biz-by-license.sh
Last active July 21, 2017 15:18
A simple script to pull down businesses by license type and display in a searchable HTML table.
##!/bin/bash
# License number (e.g., 3381).
LICENSE_TYPE=$1
# The name of the file to populate with records.
FILE_NAME=$2
echo "pri_contact_last_name, pri_contact_first_name, pri_contact_company_name, pri_contact_address1, pri_contact_city, pri_contact_state, pri_contact_zip, license_number, license_type_name, license_type_code" > $FILE_NAME
@mheadd
mheadd / philly311-sqlite.md
Last active August 23, 2016 22:16
Steps to import Philly311 data into an SQLite DB to enable SQL queries

Here are some steps to bring the bulk Philly311 CSV file into a local SQLite database to enable SQL queries.

Tools you'll use

  • sqlite3 (installed by default on OS X - try typing in ~$ which sqlite3 at a command prompt).
  • csvsql (follow installation instructions here if not already installed).
  • SQLite Manager for Firefox.

Steps