Skip to content

Instantly share code, notes, and snippets.

View maxsz's full-sized avatar

Maximilian Szengel maxsz

View GitHub Profile
{
"_links":{
"self":{
"href":"/users"
}
},
"_forms":{
"create-user":{
"title":"Create a new widget",
"description":"Enter your widget info and submit to create a new widget",
//
// ViewController.m
// DetectAlertView
//
// Created by Dominique d'Argent on 4/14/13.
// Copyright (c) 2013 Dominique d'Argent. All rights reserved.
//
#import "ViewController.h"
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active December 30, 2025 11:27
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%'
@cormacrelf
cormacrelf / Spacedust.tmTheme
Created June 12, 2011 04:43
Spacedust TextMate theme - hand-transferred from Xcode
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>name</key>
<string>Spacedust</string>
<key>settings</key>
<array>
<dict>
<key>settings</key>