Skip to content

Instantly share code, notes, and snippets.

View PlugIN73's full-sized avatar
💭
🏃‍♂️

Alexander Vagin PlugIN73

💭
🏃‍♂️
64 followers · 6 following
  • Ulyanovsk, Russia
View GitHub Profile
@PlugIN73
PlugIN73 / postgres_queries_and_commands.sql
Last active November 13, 2017 06:55 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- 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%'
ORDER BY query_start desc;
-- kill running query
SELECT pg_cancel_backend(procpid);
-- kill idle query
@PlugIN73
PlugIN73 / vim_fireplace_paredit_cheat_sheet.md
Created July 24, 2014 18:05 — forked from nblumoe/vim_fireplace_paredit_cheat_sheet.md

fireplace

  • cpr => (require ... :reload)
  • cpR => (require ... :reload-all)

Evaluation

  • :Eval (clojure code) => runs (clojure code) in repl
  • cpp => evaluate inn-most expessions under cursor
  • cp<movement> => evaluate text described by <movement>
  • cqp => opens quasi-repl
  • cqc => quasi-repl command line window
@PlugIN73
PlugIN73 / capybara_test.rb
Created December 18, 2012 15:58 — forked from mokevnin/capybara_test.rb
# encoding: UTF-8
# gem install capybara
# gem install rspec
# rspec capybara_test.rb
require 'rubygems'
require 'capybara'
require 'capybara/rspec'
Capybara.configure do |c|
@PlugIN73
PlugIN73 / terminal-open.sh
Created December 7, 2012 18:33 — forked from Andrew8xx8/terminal-open.sh
Opens terminal with specified tabs
#!/bin/bash
USAGE="Usage: -p Project path"
while getopts p: options; do
case $options in
p ) PROJECT="$OPTARG";;
esac
done