afeld

This script will automatically switch to a Python virtual environment after you cd into a Python project, then deactivate when you leave. Inspired by a similar script from Justin Abrahms.

Installation

1. Install virtualenvwrapper.

2. Download the auto_virtualenv.sh script, and put it in your home directory (~/).

3. Run the following:

chmod a+x ~/auto_virtualenv.sh

afeld

This list has been superseded by Public APIs. Check there for APIs with Auth: No, HTTPS and CORS Yes.

---

List of data APIs that require no server-side auth or private credentials, and are thus good for small browser-only JS projects.

• 3taps (information)
• Adobe Creative SDK (image editing)
• App.net
• Bing Maps

afeld

import pandas as pd


# maintain the original data format by reading everything as strings
original = pd.read_csv("original.csv", dtype="object")

# set the random_state so it's reproducible. alternatively, can pass a `frac` to use a percentage.
sampled = original.sample(n=5000, random_state=1).sort_index()

# exclude the index so the columns match the orignal

afeld

'use strict';

const Promise = require('bluebird');
const WebClient = require('slack-client').WebClient;

const token = process.env.SLACK_API_TOKEN;
if (!token) {
  throw "Please set SLACK_API_TOKEN";
}

afeld

<?php

use Google\Cloud\ErrorReporting\Bootstrap;
use Google\Cloud\Logging\LoggingClient;
use Google\Cloud\Core\Report\SimpleMetadataProvider;

// application/core/MY_Exceptions.php
class MY_Exceptions extends CI_Exceptions {

    public function __construct()

afeld

<h1><%= record.name %></h1>
<!-- etc -->

afeld

# Reads from EXIF data and applies the appropriate rotation. Requires AWS CLI and ImageMagick.
# To use, replace `BUCKET` and run in your terminal.
mkdir -p BUCKET/upright
cd BUCKET
aws s3 sync s3://BUCKET .
find . -name "*.jpg" -exec convert {} -auto-orient upright/{} \;
aws s3 sync . s3://BUCKET --acl public-read

afeld

// ensures that there's a clean slate for each test, and that no real HTTP requests are made

const nock = require("nock");

beforeAll(() => {
  // ensures no requests hit live APIs
  nock.disableNetConnect();
});

beforeEach(() => {

afeld

I've seen waaaay too many people modifying their Wordpress sites live, which is fragile because when (not "if") you break something, your visitors will see it. Here are steps for setting up a copy of your site locally, so you can muck around without worry. These instructions are for Wordpress sites hosted on GoDaddy specifically, but they should be fairly easy to interpret for other providers.

To back up your database

1. Log into GoDaddy, and go to "My Account".
2. Under "Web Hosting", click Launch next to your site's name.
3. Under "Databases", click "MySQL".
4. Next to your database name, click "Actions"->"Back Up".
5. Log into FTP, and under /_db_backups/ you'll see a new *.sql file.
6. Rename this to be mydb-YYMMDD.sql format (e.g. superwordpress-130220.sql).

afeld

Google Sheets has a QUERY function that can be used for writing SQL queries. It uses the Google Visualization API Query Language, which is unfortunately a pretty limited SQL dialect. A few options for writing more complex SQL queries:

• Export to CSV and load into a database somewhere
  • Pros: Use whatever database you want
  • Cons: Have to re-export every time the data is updated
• Load into BigTable
  • Pros: Automatically updates
  • Cons: Requires some Google Cloud setup
• Load into Google Colaboratory ("Colab")
• Pros: Very flexible, as you can use SQL, Pandas, or any other Python code/packages