emilong

-- index usage stats
SELECT 
  relname, 
  100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used, 
  n_live_tup rows_in_table
FROM 
  pg_stat_user_tables
WHERE 
    seq_scan + idx_scan > 0 
ORDER BY 

matthewrudy

# frozen_string_literal: true
namespace :db do
  namespace :structure do

    STRUCTURE_PATH = 'db/structure.sql'

    def clean_structure_file
      original = File.read(STRUCTURE_PATH)
      cleaned = original.dup

ujh

#!/usr/bin/env ruby
#
# Convert VCR cassettes that use basic auth to work with Webmock 2. Takes the folder where the VCR
#cassettes are stored as an argument.

require 'yaml'
require 'base64'

FOLDER = File.expand_path(ARGV[0])
FILES =  Dir["#{File.join(FOLDER, '**', '*.yml')}"]

harto

'use strict';

describe('mocha before hooks', function () {
	before(() => console.log('*** top-level before()'));
	beforeEach(() => console.log('*** top-level beforeEach()'));
	describe('nesting', function () {
		before(() => console.log('*** nested before()'));
		beforeEach(() => console.log('*** nested beforeEach()'));
		it('is a nested spec', () => true);
	});

mmrko

git config --global alias.checkoutr checkout
$EDITOR /usr/local/share/zsh/site-functions/git-completion.bash

...and then modify the file as follows...

-__gitcomp_nl "$(__git_refs '' $track)"
+if [ "$command" = "checkoutr" ]; then
+    __gitcomp_nl "$(__git_refs '' $track)"
+else

bspkrs

#!/bin/bash

usage()
{
cat << EOF
usage: $0 options

This script sets ownership for all tables, sequences, views, and functions for a given schema.
Run this script as your postgres OS user.

gdamjan

What

A lot of times you are developing a web application on your own laptop or home computer and would like to demo it to the public. Most of those times you are behind a router/firewall and you don't have a public IP address. Instead of configuring routers (often not possible), this solution gives you a public URL that's reverse tunnelled via ssh to your laptop.

Because of the relaxation of the sshd setup, it's best used on a dedicated virtual machine just for this (an Amazon micro instance for example).

Requirements

gkop

|| and && bind with the precedence that you expect from boolean operators in programming languages (&& is very strong, || is slightly less strong).

and and or have lower precedence.

For example, unlike ||, or has lower precedence than =:

> a = false || true
 => true 
> a

=> true

GerHobbelt

# Editor backup files
*.bak
*~

iain

>> global_variables
=> [:$;, :$-F, :$@, :$!, :$SAFE, :$~, :$&, :$`, :$', :$+, :$=, :$KCODE, :$-K, :$,, :$/, :$-0, 
:$\, :$_, :$stdin, :$stdout, :$stderr, :$>, :$<, :$., :$FILENAME, :$-i, :$*, :$?, :$$, :$:, 
:$-I, :$LOAD_PATH, :$", :$LOADED_FEATURES, :$VERBOSE, :$-v, :$-w, :$-W, :$DEBUG, :$-d, :$0, 
:$PROGRAM_NAME, :$-p, :$-l, :$-a, :$binding, :$1, :$2, :$3, :$4, :$5, :$6, :$7, :$8, :$9]

>> require 'english'
=> true

>> global_variables