Skip to content

Instantly share code, notes, and snippets.

View myhellone's full-sized avatar

myhell myhellone

3 followers · 2 following
View GitHub Profile
@myhellone
myhellone / ansible-summary.md
Created January 18, 2018 08:17 — forked from andreicristianpetcu/ansible-summary.md
This is an ANSIBLE Cheat Sheet from Jon Warbrick

An Ansible summary

Jon Warbrick, July 2014, V3.2 (for Ansible 1.7)

Configuration file

intro_configuration.html

First one found from of

@myhellone
myhellone / postgres_queries_and_commands.sql
Created March 20, 2019 16:42 — forked from rgreenjr/postgres_queries_and_commands.sql
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%'
@myhellone
myhellone / vim_syntaxchecker.md
Created October 27, 2020 09:40 — forked from thikade/vim_syntaxchecker.md
vim syntax checker / syntastic yamllint

Getting vim yaml linter to work:

  1. Install syntastic vim plugin (as of vim 7.4.x no plugin manager is required anymore!) 
    mkdir -p ~/ .vim/pack/thikade/start/
cd ~/.vim/pack/thikade/start/
git clone https://github.com/vim-syntastic/syntastic.git
  2. Install yamllint: pip install yamllint
  3. Configure yamllint: