Skip to content

Instantly share code, notes, and snippets.

View somebee's full-sized avatar

Sindre Aarsaether somebee

View GitHub Profile
abandoned
able
absolute
adorable
adventurous
academic
acceptable
acclaimed
accomplished
accurate
@simondobner
simondobner / postgres.md
Last active December 19, 2022 11:10
Postgres notes

Locks, Blocks and Killing sessions

Find blocked and blocking sessions

select pid,
       usename,
       pg_blocking_pids(pid) as blocked_by,
       query                 as blocked_query
from pg_stat_activity
@somebee
somebee / main.imba
Created January 7, 2016 11:10
basic draggable
tag draggable
def render
<self> 'I am draggable'
def ontouchstart t
self
def ontouchmove t
css left: t.x, top: t.y
@somebee
somebee / main.imba
Last active January 7, 2016 12:28
Caching subviews with ref
tag container
def build
schedule
super
def render
<self>
<good>
<bad>
@kixxauth
kixxauth / long-polling.html
Created April 11, 2011 01:21
A Node.js http long polling server for HTTP streaming.
<!DOCTYPE html>
<html>
<style type="text/css">
body {
font-size: 18px;
background: #000;
color: #fff;
}
#container {
width: 600px;