Kartones

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Kartones

Moved to https://blog.kartones.net/page/curl-cheatsheet/

Kartones

Moved to https://blog.kartones.net/page/image-and-video-cli-cheatsheet/

Kartones

Moved to https://blog.kartones.net/page/git-cheatsheet/

Kartones

• ⌘ + space: Finder

• ⌃ + ⌘ + Q: Lock screen/computer

• ⇧ + ⌘ + 3: Screenshot (saved in desktop)

• ⇧ + ⌘ + 4: Screenshot draw region

• Fn + Up/Down: Text scroll page up/down

• Fn + Del: Text forward delete

• ⌘ + ^ + Space: Insert emoji

• ⌃ + ⌘ + F: Toggle fullscreen

• ⌘ + F: VSCode find text in open file

Kartones

• pip install pystatsd
• python -c 'import pystatsd; pystatsd.Server(debug=True).serve()'
• Config is localhost:8125

From https://pypi.python.org/pypi/pystatsd/ Kudos to @rochoa

Kartones

Keyboard shorcuts

• CTRL + SHIFT + p: Command panel
• CTRL + p: File search
• CTRL + r: Method search inside current file
• CTRL + g: Go to line #
• CTRL + SHIFT + [: Fold code
• CTRL + SHIFT + ]: Unfold code
• ALT + SHIFT + 2: Double column/file mode
• ALT + SHIFT + 1: Single column/file mode

Kartones

javascript:%20var%20el,%20i,%20size;%20%20for(i=0,%20size=document.styleSheets.length;%20i<size;%20i++)%20{%20void(document.styleSheets.item(i).disabled=true);%20}%20%20el%20=%20document.getElementsByTagName('script');%20%20while%20(el.length%20>%200)%20{%20%20void(el[0].parentNode.removeChild(el[0]));%20%20}%20%20el%20=%20document.getElementsByTagName('link');%20%20while%20(el.length%20>%200)%20{%20%20void(el[0].parentNode.removeChild(el[0]));%20%20}%20%20el%20=%20document.getElementsByTagName('iframe');%20%20while%20(el.length%20>%200)%20{%20%20void(el[0].parentNode.removeChild(el[0]));%20%20}%20%20el%20=%20document.getElementsByTagName('*');%20%20for%20(%20i=0,%20size=el.length;%20i%20<%20size;%20i++)%20{%20%20void(el[i].style.cssText%20=%20'');%20%20}

Kartones

• Update version: sudo pip install --upgrade youtube-dl
• Download only MP3 audio of a video: youtube-dl <VIDEO-URL> --extract-audio --audio-format mp3
• For the above, ensure you have: sudo apt-get install ffmpeg

Kartones

Keybase proof

I hereby claim:

• I am Kartones on github.
• I am kartones (https://keybase.io/kartones) on keybase.
• I have a public key whose fingerprint is 183E 1F5A 1324 8786 6422 4300 3601 C4A0 ED24 F41D

To claim this, I am signing this object: