dwurf

#include <iostream>
#include <cstdlib>
using namespace std;

// Arbitrary precision c++ library
// compile with:
//  gcc thisfile.c -lgmp -lgmpxx -o mybinary
#include <gmpxx.h>

int main(int argc, char **argv){

dwurf

Mutability of python data types

Most data types in python are immutable, including integers

a = 2
b = a # a and b refer to the same memory location, storing the value 2
b = 5 # b now points to a new memory location, storing the value 5

print a, b 

result: 2 5

dwurf

#!/bin/bash

# Script to leech videos from lca2013
# Will not re-download stuff you already have
# 
# Requires curl, sed and grep
#
# Yes, this parses HTML with regex. Deal with it.
#
# Known bugs:

dwurf

These steps were run to set up the local network

Docker install

sudo apt-key adv --keyserver hkp://pgp.mit.edu:80 --recv-keys 58118E89F3A912897C070ADBF76221572C52609D
sudo bash -c "echo deb https://apt.dockerproject.org/repo ubuntu-trusty main > /etc/apt/sources.list.d/docker.list"
sudo apt-get update
sudo apt-get -y install docker-engine
sudo docker run hello-world

sudo docker run -it ubuntu bash

dwurf

create table bbc (
    region varchar(50) not null,
    name varchar(50) not null primary key,
    population integer
);
 
insert into bbc values ('Oceania', 'Australia', 20);
insert into bbc values ('Oceania', 'New Zealand', 4);
insert into bbc values ('Oceania', 'Solomon Islands', NULL);
insert into bbc values ('Asia', 'Japan', 50);

dwurf

-- Search all varchar columns in an entire database for a specific value
-- DANGER: do not use on large databases. 10k rows **should** be fine, larger than that requires caution.

-- Run this script in a temp database. It needs access to the target database and information_schema to run.
-- Results will go into a temporary table called rset. Everything will be cleaned up once you disconnect.

-- BEGIN SCRIPT --

-- Variables. Modify these, the rest of the script will do the work for you.

dwurf

#!/bin/bash

# Script to install kf2 server under wine on ubuntu 14.04 (AWS micro instance)

# This script makes a mess, run it in a subdirectory to keep it contained
# Also run it on a server you don't care about or be sure you don't mind when it
# installs a bunch of random crap

# Install wine
if dpkg -l wine > /dev/null 2>/dev/null; then

dwurf

Backup of SQL Fiddle code for this StackOverflow answer: http://stackoverflow.com/a/10395492/1349518