Skip to content

Instantly share code, notes, and snippets.

@mattmanning
mattmanning / postgres_queries_and_commands.sql
Created June 18, 2018 19:45 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
# Project Euler 13
data = <<~DATA
37107287533902102798797998220837590246510135740250
46376937677490009712648124896970078050417018260538
74324986199524741059474233309513058123726617309629
91942213363574161572522430563301811072406154908250
23067588207539346171171980310421047513778063246676
89261670696623633820136378418383684178734361726757
28112879812849979408065481931592621691275889832738
@mattmanning
mattmanning / timestamps.md
Created August 17, 2019 14:59
Localized timestamps

jQuery snippet to display a timestamp in local time zone and language

$(function() {
  $.each($('.timestamp'), function(i, v) {
	  ts = $(v)
		ts.text((new Date(ts.text())).toLocaleString());
	})
});
@mattmanning
mattmanning / chili.md
Last active March 2, 2020 04:23
Chili Recipe

Ingredients

  • 2 lbs chuck roast, cut into bite-sized cubes
  • 1 red onion, diced
  • 4 cloves garlic, minced
  • 2 jalepeno peppers
  • 2 poblano peppers
  • 1 can diced tomatoes, drained
  • 8 oz Guinness or other dark beer
#!/bin/sh
# Fetch new remote branches, prune deleted remote branches
git remote update -p
# Delete local branches for which the remote branch has been deleated
git branch --merged | awk '/^ /' | xargs -I $ git branch -d $