Skip to content

Instantly share code, notes, and snippets.

View gabolaev's full-sized avatar

george gabolaev

View GitHub Profile
@eiiches
eiiches / qsort.sh
Created April 18, 2011 02:06
Quicksort in Bash
#!/bin/bash
filter () {
f="$1"; shift
for e in "$@"; do
if $f "$e"; then
echo -n "$e "
fi
done
}
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active April 19, 2025 04:39
Useful PostgreSQL Queries and Commands
-- 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%'
@hakobe
hakobe / client.go
Created September 23, 2016 16:33
golang unix domain socket
package main
import (
"io"
"log"
"net"
"time"
)
func reader(r io.Reader) {