Skip to content

Instantly share code, notes, and snippets.

View paultag's full-sized avatar

Paul Tagliamonte paultag

View GitHub Profile
@paultag
paultag / clojtest.clj
Created December 13, 2012 23:39
Test Clojure dput-ng hook
; Copyright (c) Paul R. Tagliamonte <paultag@debian.org>, 2012, under the
; terms of dput-ng it's self.
(ns clojtest
(:require dput.core
dput.exceptions))
(defn log [x] ; for debug output
(.debug dput.core/logger x))
@paultag
paultag / sunshell
Created December 12, 2012 16:35
sunshell for python-sunlight and bpython
#!/usr/bin/bpython -i
from sunlight import *
import json
import sys
if '--local' in sys.argv:
import sunlight.services.openstates
sunlight.services.openstates.service_url = 'http://localhost:8000/api/v1'
@paultag
paultag / gist:4235162
Created December 7, 2012 18:09
python-sunlight in clojure-py
(ns sunup
(:require sunlight))
(defn frequencies [coll]
(reduce (fn [counts x] (assoc counts x (inc (get counts x 0)))) {} coll))
(print
(frequencies
(for [l (kwapply
(.-legislators sunlight/openstates)
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 3, 2024 16:53
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@mechanicalgirl
mechanicalgirl / redvblue_public
Created August 28, 2012 18:01
Playing around with the Sunlight Labs 'openstate' API
"""
This script pulls from the Sunlight Labs "openstates" API
to get information about legislators at the state level,
do a count of their party affiliations,
and return that information as
1) a JSON object for visualizations
2) a table suitable for embed into an HTML page
Information about the specific API used can be found here:
http://python-sunlight.readthedocs.org/en/latest/services/openstates.html
@paultag
paultag / gist:1313020
Created October 25, 2011 14:55
clear the screen in c++
#include <iostream>
using namespace std;
int main ( int argc, char ** argv ) {
char msg[] = {
0x1B, '[', '2', 'J', 0x1B, '[', 'H', '\0'
};
std::cout << msg;
}