thaiph99

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)

thaiph99

Neovim keybinds

• Capital letters do the opposite of small letters in command (Press shift to trigger capital letters)
• _ (underscore) to move the cursor at the beginning of line (doesn't switch to insert mode)
  • 0 (zero) moves the cursor to the zeroth position of the line (doesn't switch to insert mode)
• $ (dollar) to move the cursor at the end of line (doesn't switch to insert mode)
• d$ will delete from wherever your cursor is till the end of the line
• f<character> to move cursor to the first occurrence of <character>
  • f( to move cursor to first occurence of (
• t<character> to move cursor to upto but not on the first occurrence of <character>
• t( to move cursor to first occurence of (

thaiph99

Linux command note

# reset ssh ECDSA key
ssh-keygen -R hostname

# show disk capacity
lsblk -o NAME,FSTYPE,UUID,SIZE,FSAVAIL,FSUSE%,MOUNTPOINT

thaiph99

Directory structure

|__.gitconfig
|__.gitwork/
    |_.gitconfig
    |_.git-credentials
|__.getpers/
    |_.gitconfig
    |_.git-credentials

thaiph99

# Install curl ssh, tmux, vim, htop, git, build-essential, gcc ----------------------------
sudo apt install curl build-essential tmux vim openssh-client htop git net-tools xclip ripgrep vim-gtk3

# mapping cap to esc
gsettings set org.gnome.desktop.input-sources xkb-options "['caps:escape']"

# Install cloudflare-warp ----------------------------
## Add cloudflare gpg key
curl https://pkg.cloudflareclient.com/pubkey.gpg | sudo gpg --yes --dearmor --output /usr/share/keyrings/cloudflare-warp-archive-keyring.gpg
## Add this repo to your apt repositories

thaiph99

# vim:ft=zsh ts=2 sw=2 sts=2
#
# Original agnoster's Theme - https://gist.github.com/3712874
# A Powerline-inspired theme for ZSH
# Pixegami: Modified some elements to suit my Python/Git heavy use.


CURRENT_BG='NONE'

# Special Powerline characters