Skip to content

Instantly share code, notes, and snippets.

CREATE DATABASE IF NOT EXISTS `movies`;
USE `movies`;
CREATE TABLE IF NOT EXISTS `movies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`year` int(11) unsigned,
PRIMARY KEY (`id`),
SELECT
'movieId',
'movieTitle',
'movieYear',
'genreName',
'imdbId',
'tmdbId',
'rating',
'ratingTimestamp',
'ratingUserId'
// Running spark from the command line
//
// Built with scala 2.11:
// mvn -Pyarn -Phadoop-2.4 -Dscala-2.11 -DskipTests clean package
// in /Users/mrcsparker/Downloads/spark-1.4.1
//
// scala -classpath ~/Downloads/spark-1.4.1/assembly/target/scala-2.11/spark-assembly-1.4.1-hadoop2.6.0.jar pi.scala 1000
import org.apache.spark._
println(args.mkString(" "))
{
// This was Modified from a function at http://en.wikipedia.org/wiki/Hexavigesimal
// Pass in the base 26 string, get back integer
var fromBase26 = function (number) {
"use strict";
number = number.toUpperCase();
@mrcsparker
mrcsparker / xhr.service.js
Created July 9, 2015 22:46
Raw XHR for Angular
'use strict';
// based on https://github.com/mrjgreen/xhr/blob/master/xhr.js
var xhr = function($q) {
var x = function() {
try {
return new XMLHttpRequest();
} catch (e) {}
try {
@mrcsparker
mrcsparker / nrepl.rb
Created June 30, 2015 04:39
NRepl for Ruby: simple nrepl client for Ruby 2+
require 'socket'
require 'bencode'
require 'securerandom'
module Loader
class NRepl
def self.connect(server, port)
new(server, port)
end
# Brewfile
# `brew bundle`
install openssl
install emacs
install node
install unrar
install leiningen
install readline
install ruby-build
@mrcsparker
mrcsparker / TeradataDump.java
Created November 16, 2013 03:56
Dump a Teradata database to MySQL. Also will work with SQLite with modifications.
import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.HashMap;
class TeradataDump {
@mrcsparker
mrcsparker / sample.js
Created July 16, 2013 04:04
Playing with Javascript sub-classing and data hiding
var Sample = (function (Sample) {
"use strict";
var SampleColumn = (function () {
var SampleColumn = {};
SampleColumn.parseColumns = function () {
var columns = [],