elephant cheatsheet

table rows

-- works bad

SELECT schemaname,relname,n_live_tup
  FROM pg_stat_user_tables
  ORDER BY n_live_tup DESC;



Python cheatsheet

www.pythonsheets.com

python anti-patterns

django tweaks

linux cheat sheet

# resources
ps -eo size,rss,pid,user,comm --sort -rss | head -n 30
ps -eo size,rss,pcpu,pid,user,comm --sort -pcpu | head -n 30

# memstat
atop -L160 1 1 | grep MEM

# caches

# chmod directories

# awk epoch to timestamp in logs
awk '{a = strftime("%F %T", $1); $1 = "" ; print a" "$0}'

# safe file delete

# some magic in resolv.conf

# default browser ( set default apps )
xdg-mime default firefox.desktop x-scheme-handler/http
xdg-mime default firefox.desktop x-scheme-handler/https

# keyboard
setxkbmap -layout us,ru -option grp:toggle

# qt crutch
export QT_GRAPHICSSYSTEM=native | raster | opengl

# swap usage by pid

# sqlite

# get url
wget -qO- http://foo/response
wget -qO- http://bar/api/json/response | python -m json.tool
wget -qO- http://bar/api/json/response | jq
wget -qO- http://bar/api/json/response | jq '.[] | select((.k_1 == 1) or (.k_2 == 2)) | "k1:\(.k_1) k2:\(.k_2)"'

# ssh/sshfs
sshfs -o reconnect -o auto_unmount 192.168.5.5:/mnt/data/usorted/ ~/sshfs/unsorted/


to remember

source

CLUSTERFUCK

Military term for an operation in which multiple things have gone wrong. Related to "SNAFU" (Situation Normal, All Fucked Up") and "FUBAR" (Fucked Up Beyond All Repair).

In radio communication or polite conversation (i.e. with a very senior officer with whom you have no prior experience) the term "clusterfuck" will often be replaced by the NATO phonetic acronym "Charlie Foxtrot."

Wonderful!

Bill Gates: “So, how’s heaven, Steve?”
Steve Jobs: “Great! It just doesn’t have any wall or fence.”
Bill Gates: “So…?”
Steve Jobs: “So, we don’t need any Windows and Gates. I’m sorry, Bill, I didn’t mean to offend you.”
Bill Gates: “It’s ok Steve, but I heard a rumor.”
Steve Jobs: “Oh, what rumor?”
Bill Gates: “That nobody is allowed to touch Apple there, and there are no Jobs in heaven.”
Steve Jobs : “Oh no, definitely there are, but only no–pay Jobs. Therefore definitely no Bill in heaven as everything will be provided free….”

How to chmod all directories except files (recursively)

source


find /path/to/base/dir -type d -print0 | xargs -0 chmod 755
find /path/to/base/dir -type f -print0 | xargs -0 chmod 644

PHP vs Python, ru only

Если вы решили перейти с PHP на Python

Web-разработка на Python глазами PHP-программиста