Skip to content

Instantly share code, notes, and snippets.

@jordelver
jordelver / postgres_queries_and_commands.sql
Created February 27, 2020 13:38 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
View postgres_queries_and_commands.sql
-- 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%'
View keybase.md

Keybase proof

I hereby claim:

  • I am jordelver on github.
  • I am jordelver (https://keybase.io/jordelver) on keybase.
  • I have a public key whose fingerprint is FCF1 85F0 6DBF 112D 8F8E DEEC CAE8 72D7 E87D 5AFF

To claim this, I am signing this object:

View ruby-hashes.md

From

{
  :FNAME => attributes.contact_first_name,
  :LNAME => attributes.contact_last_name,
  :LEVEL => attributes.level,
  :COUNTRY => attributes.country,
  :TWITTER => attributes.twitter,
 :JOIN_DATE =&gt; attributes.join_date,
@jordelver
jordelver / fish-completions.md
Created August 13, 2015 16:11
Fish shell tab completions favour Git branches?
View fish-completions.md

In the root of my project I have a directory called features. I also have a Git branch called origin/feature-add-coupon-code-to-report.

When I do git co fe<TAB> the Git branch is matched and completed to git co origin/feature-add-coupon-code-to-report which seems strange to me.

Shouldn't the local directory be matched before the branch give that feature is not present at the start of the branch name?

If I type 3 or more characters then it completes to git co features/.

What is the expected behaviour?

@jordelver
jordelver / gist:bdf6c7e91c3f4f6eedba
Last active April 8, 2018 02:01
Get all movies in your Letterboxd watchlist
View gist:bdf6c7e91c3f4f6eedba
require "mechanize"
USERNAME = ENV.fetch("USERNAME") do
puts "Letterboxd USERNAME environment variable must be supplied"
exit
end
WATCHLIST = "http://letterboxd.com/%s/watchlist/" % USERNAME
agent = Mechanize.new
View gist:d39abe44adbb56ac1004
if !isdirectory(expand("~/.vim/bundle/Vundle.vim/.git"))
silent !git clone https://github.com/gmarik/Vundle.vim.git ~/.vim/bundle/Vundle.vim
silent !vim +PluginInstall +qall
endif
View gist:9521a3bb8f2d1f2dbd2c
Person = Struct.new(:name, :age)

peeps = [
  Person.new("Jordan", 33),
  Person.new("Bob", 19),
  Person.new("Frank", 55)
]
@jordelver
jordelver / gist:6a375a1bf27c63cb0b5a
Created October 8, 2014 16:22
Ruby yield as a default parameter
View gist:6a375a1bf27c63cb0b5a

Learnt this from Avdi Grimm's Ruby Tapas

def content_for(tag, content = yield)
  "<%s>%s</%s>" % [tag, content, tag]
end

content_for("p", "hi")
=> "<p>hi</p>"
View gist:0cc4daf20843cfa3902c

Idea from @sferik's talk at Baruco 2014

Implicit blocks with yield are faster than explicit blocks with #call.

require 'benchmark/ips'

def explicit(&block)
  block.call
end
@jordelver
jordelver / gist:71ef7394383ab36e4b7e
Last active April 8, 2018 02:01
RestfulGit examples
View gist:71ef7394383ab36e4b7e

RestfulGit examples

Things we need to get from the API

(Install jq for these examples http://stedolan.github.io/jq/)

Single commits

curl 'http://0.0.0.0:5000/repos/restfulgit/commits/8990ae2cd9bfa2d94f4fd37ae8026c71bfe7d8ef/' | jq '.'