henrik

tmux cheatsheet

As configured in my dotfiles.

start new:

tmux

start new with session name:

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

scaryguy

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

Avaq

const I  = x => x
const K  = x => y => x
const A  = f => x => f (x)
const T  = x => f => f (x)
const W  = f => x => f (x) (x)
const C  = f => y => x => f (x) (y)
const B  = f => g => x => f (g (x))
const S  = f => g => x => f (x) (g (x))
const S_ = f => g => x => f (g (x)) (x)
const S2 = f => g => h => x => f (g (x)) (h (x))

tpae

// Trie.js - super simple JS implementation
// https://en.wikipedia.org/wiki/Trie

// -----------------------------------------

// we start with the TrieNode
function TrieNode(key) {
  // the "key" value will be the character in sequence
  this.key = key;
  

josephhanson

// mock file
function MockFile() { };

MockFile.prototype.create = function (name, size, mimeType) {
    name = name || "mock.txt";
    size = size || 1024;
    mimeType = mimeType || 'plain/txt';

    function range(count) {
        var output = "";

nitin42

const some_module = require('some_module')

/**
 * require('some_module') calls Module._load
 * 
 * Module._load then tries to load the module with a filename (also save it to the cache) using module.load(filename)
 *
 * module.load(filename), given a filename, passes it to the proper extension handler ('.js', '.json')
 *
 * If there were any errors when loading the file, it deletes the file from the cache (delete Module._cache[filename]) and throws an error

vcarl

I bundled these up into groups and wrote some thoughts about why I ask them!

If these helped you, I'd love to hear about it!! I'm on twitter @vcarl_ or send me an email [email protected]

Onboarding and the workplace

https://blog.vcarl.com/interview-questions-onboarding-workplace/

• How long will it take to deploy my first change? To become productive? To understand the codebase?
• What kind of equipment will I be provided? Will the company pay/reimburse me if I want something specific?

cgsdev0

/* 
   (Dumb) idea to implement the classic FizzBuzz
   problem as a state machine with 16 states.
*/

#include <iostream>
#include <vector>
#include <functional>
#include <stdlib.h>

CMCDragonkai

Understanding Nix Inputs

Every Nix derivation produces a Nix store output that has 3 things:

• Executables
• Libraries
• Data

Executables are always exported using the PATH environment variable. This is pretty much automatic.