Skip to content

Instantly share code, notes, and snippets.

View arush's full-sized avatar

Arush Sehgal arush

53 followers · 41 following
View GitHub Profile
@arush
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
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
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
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
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
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
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
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
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>test@getbrandid.com</account_code>
<username nil="true"></username>
<email>test@getbrandid.com</email>
<first_name>a</first_name>
<last_name>a</last_name>
@arush
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>