Skip to content

Instantly share code, notes, and snippets.

View edpaget's full-sized avatar

Edward Paget edpaget

24 followers · 15 following
  • Chicago, IL
View GitHub Profile
@edpaget
edpaget / gist:3a597cefe780fca99a67
Created March 6, 2015 23:06
WITH RECURSIVE rand(ids, id, done) AS (
SELECT ARRAY[]::int[], sub.id, 0 FROM (SELECT t.id FROM test t WHERE t.name = 'asdf' AND t.id = ceiling(random() * 8)::integer) AS sub
UNION ALL
SELECT (n.ids || n.id), sub.id, done+1 FROM rand n, (SELECT t.id FROM test t WHERE t.name = 'asdf' AND t.id = ceiling(random() * 8)::integer) AS sub WHERE NOT done = 5
)
SELECT n.* FROM rand n;
SELECT t.* FROM test t, rand n WHERE t.id = ANY(n.ids) LIMIT 20;
@edpaget
edpaget / subquery_bug_test.rb
Created January 8, 2015 22:50
Rails 4.2 Subquery Bug
unless File.exist?('Gemfile')
File.write('Gemfile', <<-GEMFILE)
source 'https://rubygems.org'
gem 'rails', github: 'rails/rails'
gem 'arel', github: 'rails/arel'
gem 'sqlite3'
GEMFILE
system 'bundle'
end
@edpaget
edpaget / ClassificationCount.scala
Created May 19, 2014 16:55
import org.apache.spark.SparkContext
import org.apache.spark.SparkContext._
import org.apache.hadoop.conf.Configuration
import org.bson.BSONObject
import org.bson.BasicBSONObject
object ClassificationCount {
def main(args: Array[String]) {
val sc = new SparkContext("local", "ClassificationCount")
@edpaget
edpaget / gist:4152331
Created November 27, 2012 04:14 — forked from arfon/gist:4152089
Rickshaw example
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Spotty plots</title>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script src="http://code.shutterstock.com/rickshaw/vendor/d3.v2.js"></script>
<script src="http://code.shutterstock.com/rickshaw/rickshaw.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://raw.github.com/shutterstock/rickshaw/master/rickshaw.min.css">
</script>