philgyford

<!--
A form for a place.
When submitted, displays a list of music artists from that place.
And looks up the location with Google Geocoder and displays a map.
And displays Flickr photos from within that location.
REQUIRES:
  * Echo Nest API Key.
  * Google API Key (with access to JavaScript API and Geocoding API)
  * Flickr API key
-->

philgyford

<!--
Enter a location name, submit the form.
Get a map, a weather forecast, and a Giphy image for each day's weather.
  
Requires API Keys for:
	* Giphy: https://github.com/Giphy/GiphyAPI
	* Forecast: https://developer.forecast.io/
	* Google Maps JavaScript API Key
		https://developers.google.com/maps/documentation/javascript/
-->

philgyford

Apple Cinema Display 23-Inch (Aluminum)

One free Apple Cinema Display to anyone who can collect from the Barbican. It's in the original box, with a handle, but is fairly heavy.

I think it's one of these: http://www.everymac.com/monitors/apple/studio_cinema/specs/apple_cinema_display_23.html

Reasons why you might not want this:

• It's more than ten years old.

philgyford

{{#post}}
  {{#get "posts" limit="1" order="published_at desc" filter=“tag:getting-started+published_at:<{{published_at}}"}}
    {{#foreach posts}}
      <a href="{{url}}">{{title}}</a>
    {{/foreach}}
  {{/get}}
{{/post}}

philgyford

license: cc-by-sa-4.0
height: 570
scrolling: no
border: yes

philgyford

#!/usr/bin/env python2.7

import subprocess
import sys
import re
import os,pwd
from pprint import pprint

class TerminalController:
    """

philgyford

license: cc-by-sa-4.0
height: 1200
scrolling: no
border: yes

philgyford

images/*
*.csv

philgyford

Django Find and Replace

This was used to replace all the instances of old Media URLs with new ones, but could be used for any kind of text search/replace across Django objects.

1. Change the model import to whatever your app and model is.
2. Set the to_find and to_replace strings to whatever you need.
3. Change Post to your model name, and the fields to whatever field(s) you want to search and replace across.

philgyford

Migrating a Django postgresql database to sqlite3

I wanted to export data from a few Django apps, held in a postgres database, and import that data into an sqlite3 database to run locally.

This worked for me, but I'm sure there are other wrinkles, depending on your use of postgres-specific features, etc.

1. Export the data from postgres