aendra-rininsland

<?php
register_activation_hook(__FILE__, 'activate_my_plugin');

function activate_my_plugin() {
  // Some basic securifying
  if ( ! current_user_can( 'activate_plugins' ) )
    return;
  $plugin = isset( $_REQUEST['plugin'] ) ? $_REQUEST['plugin'] : '';
  check_admin_referer( "activate-plugin_{$plugin}" );

aendra-rininsland

{
  "id": "0d19ea7d-8803-9f84-32f0-096a055e1d3e",
  "name": "Dreamhost API",
  "timestamp": 1410102836319,
  "requests": [{
    "collectionId": "0d19ea7d-8803-9f84-32f0-096a055e1d3e",
    "id": "00c11594-394a-410e-9847-760aaa3f1bc8",
    "name": "MySQL — Add hostname",
    "description": "<a href=\"http://wiki.dreamhost.com/API/Mysql_commands#mysql-add_hostname\">Adds a MySQL hostname</a>.<br/>\n<b>hostname:</b> the full hostname you want to serve as a mysql hostname (unless the domain following the first . is hosted with Dreamhost, you will not be able to access phpMyAdmin from this hostname).",

aendra-rininsland

#!/bin/bash
### dump_mysql_for_rds.sh
## 2014 Ændrew Rininsland (@aendrew)
# usage: ./dump_mysql_for_rds.sh <root_user> <password> <path_to_mysql_socket> <dbs,to,exclude> <filename for dump>

ARG_DBUSER=$1
ARG_DBPASS=$2
ARG_DBSOCKET=$3
ARG_EXCLUDE=$4
ARG_DUMPFILE=$5

aendra-rininsland

/**
 * Convert Google Sankey chart data to D3.js Sankey data (nodeJS)
 * Usage: node convert_google_to_d3.js in-file.json out-file.json
 *
 * Requires: lodash — npm install lodash
 */

'use strict';

var _ = require('lodash');

aendra-rininsland

Deis Cheat Sheet

2015 Ændrew Rininsland

This assumes running Deis on AWS. Note this is a work-in-progress.

To check fleet status

1. Get IP of a Deis instance.
2. Connect: ssh -i ~/.ssh/deis core@$DEIS_IP
3. fleetctl list-units

aendra-rininsland

SELECT DISTINCT ?name (CONCAT(STR(YEAR(?date)), 
                     "-", 
                     STR(MONTH(?date)), 
                     "-", 
                    STR(DAY(?date))) as ?displayDate)
WHERE {
  ?person dcterms:subject <http://dbpedia.org/resource/Category:UK_MPs_2010%E2%80%9315>.
  ?person a foaf:Person.
  ?person dbpedia-owl:birthDate ?date.
  ?person rdfs:label ?name.

aendra-rininsland

<?php
function disable_WP_author_rewrites($rules) {
	$rules['author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$'] = 'index.php?authors=$matches[1]&feed=$matches[2]';
	$rules['author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$'] = 'index.php?authors=$matches[1]&feed=$matches[2]';
	$rules['author/([^/]+)/page/?([0-9]{1,})/?$'] = 'index.php?authors=$matches[1]&paged=$matches[2]';
	$rules['author/([^/]+)/?$'] = 'index.php?authors=$matches[1]';

	return $rules;
}

aendra-rininsland

Somewhat Difficult Things To Do In D3

• Clustered groups of elements (I.e., "group x circles into y groups")
• Hexbin maps (E.g., hexbin election constituency maps)

aendra-rininsland

{
	"id": "21153401-a788-3abe-5fbb-54833ca0e400",
	"name": "UNHCR",
	"description": "Data from the UN Refugee Agency.\n\nDocs at [data.unhcr.org/wiki/index.php/API_Documentation](http://data.unhcr.org/wiki/index.php/API_Documentation).",
	"order": [],
	"folders": [
		{
			"id": "c1514c2c-f817-f8d6-b434-eacd23a9c937",
			"name": "Countries",
			"description": "",

aendra-rininsland

<?php
/*
 * Converts CSV to JSONP by Ændrew Rininsland
 * Gratuitous fork of "Converts CSV to JSON" by Rob Flaherty
 * -- See: http://www.ravelrumba.com/blog/json-google-spreadsheets/
 * Example uses Google Spreadsheet CSV feed
 */

header('Content-type: script/javascript');