tyrauber’s gists

tyrauber / Postgres time_ago_in_words(date) function

Created October 27, 2014 22:43

Postgres time_ago_in_words(date) function

	CREATE OR REPLACE FUNCTION time_ago_in_words(timestamp with time zone)
	RETURNS text
	LANGUAGE SQL
	AS $$
	SELECT CASE
	WHEN date_part('year', age(current_timestamp, $1)) = 1 THEN concat(date_part('year', age(current_timestamp, $1)), ' year ago')
	WHEN date_part('year', age(current_timestamp, $1)) > 1 THEN concat(date_part('year', age(current_timestamp, $1)), ' years ago')
	WHEN date_part('month', age(current_timestamp, $1)) = 1 THEN concat(date_part('month', age(current_timestamp, $1)), ' month ago')
	WHEN date_part('month', age(current_timestamp, $1)) > 1 THEN concat(date_part('month', age(current_timestamp, $1)), ' months ago')
	WHEN date_part('day', age(current_timestamp, $1)) = 1 THEN concat(date_part('day', age(current_timestamp, $1)), ' day ago')

tyrauber / initializer_notification_center.rb

Last active August 29, 2015 14:07 — forked from nhocki/initializer_notification_center.rb

	# config/initializer/notification_center.rb
	NotificationCenter.queue
	NotificationCenter.thread

	ActiveSupport::Notifications.subscribe /(.)+\.notification/i do \|*args\|
	NotificationCenter.queue << args
	end

tyrauber / s3_field_field error with active_admin stack trace

Created December 1, 2013 03:55

s3_field_field error with active_admin stack trace.

	activesupport (3.2.12) lib/active_support/core_ext/string/output_safety.rb:24:in `html_escape'
	actionpack (3.2.12) lib/action_view/helpers/tag_helper.rb:151:in `block in tag_options'
	actionpack (3.2.12) lib/action_view/helpers/tag_helper.rb:138:in `each_pair'
	actionpack (3.2.12) lib/action_view/helpers/tag_helper.rb:138:in `tag_options'
	actionpack (3.2.12) lib/action_view/helpers/tag_helper.rb:66:in `tag'
	actionpack (3.2.12) lib/action_view/helpers/active_model_helper.rb:24:in `tag'
	actionpack (3.2.12) lib/action_view/helpers/form_helper.rb:1046:in `to_input_field_tag'
	s3_file_field (1.0.4) lib/s3_file_field/form_helper.rb:24:in `s3_file_field'
	s3_file_field (1.0.4) lib/s3_file_field/form_helper.rb:7:in `s3_file_field'
	app/views/assets/partials/_avatar_form.html.erb:4:in `_app_views_assets_partials__avatar_form_html_erb__818076104424137440_70152587222680'

tyrauber / gist:3723999

Created September 14, 2012 19:03

Riak cluster setup script

	### ruby riak.rb number_of_nodes

	require "rubygems"

	# `killall epmd` ## to kill running riaks

	@riak_url = "http://s3.amazonaws.com/downloads.basho.com/riak/CURRENT/osx/10.4/"
	@riak_filename = "riak-1.2.0-osx-x86_64.tar.gz"
	@port = 8098

tyrauber / html5_js_geolocation_reverse_geolocation

Created August 14, 2012 18:30

HTML5 JS Geolocation Reverse-Geolocation

	var latlng;
	var address;
	geocoder = new google.maps.Geocoder();
	function success(position) {
	var latlng = new google.maps.LatLng(position.coords.latitude, position.coords.longitude);
	geocoder.geocode({'latLng': latlng}, function(results, status) {
	if (status == google.maps.GeocoderStatus.OK) {
	if (results[1]) {
	address = results[1].formatted_address;
	console.log(results[1]);

tyrauber / gist:3350666

Created August 14, 2012 16:35

CrossFilter with lineChart

	<!DOCTYPE html>
	<meta charset="utf-8">
	<title>Crossfilter</title>
	<style>

	/** CrossFilter LineChart example

	The current CrossFilter demo, available here: http://square.github.com/crossfilter/

	... Only renders data as bar charts using d3.js. D3.js is an awesome visualization library that provides the ability to generate many different styles of visualization. This GIST is an attempt to document rendering cross filter data as a line chart instead of a bar chart.

tyrauber / gist:3269339

Created August 6, 2012 02:46

autocomplete snippet

	function submitForm(){
	$.ajax({
	type: 'POST',
	url: "admin",
	data: {
	utf8: "✓",
	authenticity_token: $("meta[name='csrf-token']").attr('content'),
	search: {
	q: $('#search_q').val()
	},

tyrauber / gist:3118234

Created July 15, 2012 19:25

	class Census2010
	require 'csv'

	include Ripple::Document

	property :id, Integer, :presence => true
	property :sumlevel, Integer, :presence => true
	property :state_id, Integer
	property :stusab, String
	property :logrecno, Integer

tyrauber / TweetCongress

Created April 18, 2012 02:55

Calls out to google and then get's legislators twitter addresses through project sunlight

	<head>
	<title>Stop Cyborg Security Week — a campaign from Fight for the Future</title>
	<script type="text/javascript" src="http://code.jquery.com/jquery-1.7.2.min.js"></script>
	<script type="text/javascript" src="http://www.google.com/jsapi"></script>
	</head>
	<body>
	<div id="wrapper">
	<div id="container">
	<div id="header">

tyrauber / cube.h

Created March 15, 2010 17:56

Ty Rauber tyrauber