benjbaron

-- 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%' 

benjbaron

# Redis Cheatsheet
# All the commands you need to know


redis-server /path/redis.conf  # start redis with the related configuration file
redis-cli                      # opens a redis prompt


# Strings.

benjbaron

package types

import (
	"encoding/json"
	"time"
)

// FIXME: This does not currently work with JSON's omitempty.
// See: https://github.com/golang/go/issues/11939

benjbaron

IntelliJ shortcuts

Reference: https://vimeo.com/98922030

1. Do not use tabs, deactivate them in the preference panel.
2. Naviguate through files using CMD+E and CMD-SHIFT-E (last edited files)
3. Highlight usages with SHIFT-CMD-F7
4. Get rid of everything with SHIFT-CMD-F12 (full mode)
5. Select blocks of text with ALT+UP ARROW
6. Move blocks up and down with SHIFT+ALT+UP

benjbaron

func Benchmark_append(b *testing.B) {
    b.StopTimer()

    b.ReportAllocs()
    b.StartTimer()

    for i := 0; i < 1000; i++ {
        var a []int
        for i := 0; i < 100000; i++ {
            a = append(a, i)

benjbaron

[github]
  user = benjbaron
[push]
  default = current
[pull]
  rebase = true
[alias]
  st = status
  stp = status --porcelain
  ci = commit --amend --no-edit

benjbaron

import time
from multiprocessing import Pool
# can also work with ThreadPool, by importing 
# from multiprocessing.dummy import Pool


def f1(a,b):
	print("run f1(%s,%s)" % (a,b))
	time.sleep(2)
	print("end f1")

benjbaron

Studying for a Tech Interview Sucks, so Here's a Cheat Sheet to Help

This list is meant to be a both a quick guide and reference for further research into these topics. It's basically a summary of that comp sci course you never took or forgot about, so there's no way it can cover everything in depth. It also will be available as a gist on Github for everyone to edit and add to.

Data Structure Basics

###Array ####Definition:

• Stores data elements based on an sequential, most commonly 0 based, index.
• Based on tuples from set theory.

benjbaron

void OGRLayer::SetSpatialFilterRect( double dfMinX, double dfMinY,
                                      double dfMaxX, double dfMaxY )

{
     OGRLinearRing  oRing;
     OGRPolygon oPoly;

     oRing.addPoint( dfMinX, dfMinY );
     oRing.addPoint( dfMinX, dfMaxY );
     oRing.addPoint( dfMaxX, dfMaxY );

benjbaron

QString checkFile(QString foldername, QStringList exts, QString filename) {
    foreach(auto ext, exts) {
        QFileInfo check(foldername+"/"+filename+"."+ext);
        if(check.exists() && check.isFile())
            return check.absoluteFilePath();
        return QString();
    }
}