arush’s gists

arush / growth_accounting_and_ltv.sql

Created October 10, 2022 16:03 — forked from hsurreal/growth_accounting_and_ltv.sql

	with
	dau as (
	-- This part of the query can be pretty much anything.
	-- The only requirement is that it have three columns:
	-- dt, user_id, inc_amt
	-- Where dt is a date and user_id is some unique identifier for a user.
	-- Each dt-user_id pair should be unique in this table.
	-- inc_amt represents the amount of value that this user created on dt.
	-- The most common case is
	-- inc_amt = incremental revenue from the user on dt

arush / gist:8e4592ccba4d42522200

Last active March 9, 2016 06:48

Cohort Queries

	-- invoices
	SELECT
	u.id AS user_id,
	uuid_timestamp(i.id)::DATE AS dt,
	sum(i.balance) AS inc_amt
	FROM public.users u
	JOIN public.invoices i ON u.id = i.user_id
	WHERE
	u.fraud_score != 'F'
	AND uuid_timestamp(i.id) > DATE '2015-06-30'

arush / vidtogif.sh

Last active August 29, 2015 14:24 — forked from imkevinxu/vidtogif.sh

	# Convert an animated video to gif
	# Works best for videos with low color palettes like Dribbble shots
	#
	# @param $1 - video file name like `animation.mov`
	# @param @optional $2 - resize parameter as widthxheight like `400x300`
	#
	# Example: vidtogif animation.mov 400x300
	# Requirements: ffmpeg and gifsicle. Can be downloaded via homebrew
	#
	# http://chrismessina.me/b/13913393/mov-to-gif

arush / gist:5777408

Created June 13, 2013 21:11

Example gruntfile using ngmin for pre-minification of angular apps

	module.exports = (grunt)->

	# Run `grunt server` for live-reloading development environment
	#grunt.registerTask('server', [ 'build', 'livereload-start', 'karma:background', 'express', 'regarde' ])
	grunt.registerTask('server', [ 'build', 'express', 'watch' ])

	# Run `grunt test` (used by `npm test`) for continuous integration (e.g. Travis)
	grunt.registerTask('test', [ 'build', 'karma:unit' ])

	# Run `grunt test:browsers` for real-world browser testing

arush / gist:5397620

Created April 16, 2013 17:03 — forked from spacenick/gist:5397435

	// You can do that in your Chrome Console

	// Load the initial object, like an Attempt

	var attempt = new Parse.Object("Attempt");
	attempt.id = "myId";
	attempt.fetch();

	// Get the relation "handler" from the attempt object
	var relation = attempt.relation("products");

arush / gist:4568413

Created January 18, 2013 20:50

	info: Creating snapshot 0.0.1-22
	info Uploading: [=============================] 100%
	info: Updating app shinobi
	error: Error running command deploy
	error: Nodejitsu Error (500): Internal Server Error
	warn: Error returned from Nodejitsu
	error: Error: App domain already exists
	error: at module.exports.show.updateCounts.(anonymous function).updateCounts.(anonymous function) (/root/nodejitsu/lib/nodejitsu/resources/app/controller/update.js:89:28)
	error: at Resource._request (/root/nodejitsu/node_modules/resourceful/lib/resourceful/resource.js:184:13)
	error: at Function.Resource.runAfterHooks (/root/nodejitsu/node_modules/resourceful/lib/resourceful/resource.js:93:12)

arush / recurly-client-node.js

Created January 8, 2013 17:51

	var crypto = require('crypto')
	, uuid = require('node-uuid');

	function recurly () {
	}

	recurly.prototype.sign = function (privateKey, params) {
	var protectedString = makeProtectedString(params);
	var secureHash = makeHash(privateKey, protectedString);
	var signature = secureHash+"\|"+protectedString;

arush / gist:4267237

Created December 12, 2012 11:59

Facebook getLoginStatus for testing

	FB.getLoginStatus(function(response) {
	if (response.status === 'connected') {
	alert("yes am connected");
	} else if (response.status === 'not_authorized') {
	alert("logged into facebook but not authorized your app");
	} else {
	alert("not logged into facebook");
	}
	});

arush / gist:4216462

Created December 5, 2012 15:19

Recurly Push notifications

	// NEW ACCOUNT NOTIFICATION

	<?xml version="1.0" encoding="UTF-8"?>
	<new_account_notification>
	<account>
	<account_code>[email protected]</account_code>
	<username nil="true"></username>
	<email>[email protected]</email>
	<first_name>a</first_name>
	<last_name>a</last_name>

arush / gist:4118976

Created November 20, 2012 16:23

	NB: this is being generated by the server side MVC, so url is brandid.macbook.pro/male


	<!-- deleted lots of header stuff -->
	<body>
	<div id="maleContainer" class="container withShadow">

	<div class="maleApp" ng-app="ngMaleApp">
	<div class="content" ng-view>
	</div>

Arush Sehgal arush