kxhitiz

Querying your jsonb column It’s time to use some query operators. PostgreSQL has many others, so read the documentation for a complete list.

Also, always remember to EXPLAIN the queries you’re executing; that way you can adapt your indexes for a better performance.

Users that opt-in newsletter

# preferences->newsletter = true
User.where('preferences @> ?', {newsletter: true}.to_json)

kxhitiz

git commit stats

Commands to get commit statistics for a Git repository from the command line -
using git log, git shortlog and friends.

---

kxhitiz

kxhitiz

#!/usr/bin/env bash
curl https://s3.amazonaws.com/heroku-jvm-buildpack-vi/vim-7.3.tar.gz --output vim.tar.gz
mkdir vim && tar xzvf vim.tar.gz -C vim
export PATH=$PATH:/app/vim/bin

kxhitiz

#!/bin/sh
#
# Prepend the branch name to the commit message
# 
# Add this file as [repo]/.git/hooks/prepare-commit-msg 
#
# A couple notes:
# 1. The file must be executable (chmod +x prepare-commit-msg)
# 2. This works on a per-repo basis (unless you follow this guide https://coderwall.com/p/jp7d5q/create-a-global-git-commit-hook)

kxhitiz

**GIT**
git fetch -p
git branch --merged | grep -v master | xargs -n 1 git branch -d

kxhitiz

> db.tasks.find({"deleted_at" : null, "worker_id": ObjectId("52fb3ee0863a995e8d004bac"), "completed_at":{"$gte":ISODate("2014-04-11 00:00:00.000Z"), "$lte":ISODate("2014-07-13 23:59:59.999Z")}, "status":"completed"}).hint({deleted_at: 1, worker_id: 1, completed_at: 1, status: 1}).explain()

{
  "cursor" : "BtreeCursor deleted_at_1_worker_id_1_completed_at_1_status_1",
  "isMultiKey" : false,
  "n" : 5035,
  "nscannedObjects" : 5035,
  "nscanned" : 6228,
  "nscannedObjectsAllPlans" : 5035,
  "nscannedAllPlans" : 6228,

kxhitiz

var page = require('webpage').create(),
    system = require('system'),
    url = "http://localhost:3000";

page.onConsoleMessage = function(msg) {
  console.log(msg);
};

if (system.args.length < 2) {
  console.log("Usage: headless_crawl.js [url]");

kxhitiz

source "http://rubygems.org"

gem 'fog'

kxhitiz

Create .pgpass in home directory with db config options in format

hostname:port:database:username:password

Dump db:

pg_dump faves_development -U faves -h localhost -F c > mysql.dump

Restore db:

psql faves_development -h localhost -U faves < mysql.dump