Keep It Sane

Jun 16, 2019 03:34 · 461 words · 3 minute read workflow xp

This is a list of issues that I’ve dealt with at least once. The list would serve as a shortcut to save me time from trying to google the solution again and again. It’s like index of things that had bitten me in the past.

The list will be updated from time to time as new issue occurs.



  1. Source Tree keep asking for password (image)
    • tldr: git config --global credential.helper osxkeychain
    • ref: stackoverflow
  2. Keychain asking password two times
    • (Not solved yet)
  3. NAS disk prompt keeps popping up
    • (Not solved yet)
  4. Activate “Do Not Disturb” mode (disable all notifications)
  5. macOS won’t boot; grey folder with question mark appears during boot
    • Unfortunately, your SSD might have failed you. Try replacing it.
    • Blog post: WIP



  1. Stuck in boot screen (Ubuntu’s purple screen)
  2. Recover data from unbootable ubuntu



  1. Termux can’t access device storage
    • Open termux and run termux-setup-storage
  2. Termux history is not active
    • (Not solved yet)
  3. Share termux shell as web app
    • Download gotty, run ./gotty -w sh, and visit http://<device-ip>:8080 from browser.
  4. Share android screen to local computer (eg. for demo/presentation)



  1. Debug GraphQL requests in browser
  2. GraphQL error “GROUP BY clause is incompatible with sql_mode=only_full_group_by”

    • Remove ‘ONLY_FULL_GROUP_BY’ from mysql’s sql_mode. Example:

      SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY,',''));
    • See: stackoverflow

  3. Setting git commit author per repo basis

    • run this command in root directory of git repo (based on

      echo "[user]
      name = <author name>
      email = <author oemail>" >> .git/config
  • Need to quickly switch proxy server for command line environment
  • Preview JSON response in Opera:
  • Save time typing localhost by aliasing l to localhost
    • echo ' l' >> /etc/hosts. curl l:3000 is now equivalent to curl localhost:3000
  • Create alias for IP address of hostpot-providing device (Android)
    • echo ' android.local' >> /etc/hosts. See: stackoverflow
  • Generate fake data to fill web form



  1. Debugging NodeJS, Go, Bash, etc. with vscode
    • (Blog post in progress)
  2. need to grab screen shot and use it as quick reference
    • use grabit
  3. need to upload file and share it randomly
    • use
  4. SublimeText 3: show current file in sidebar
  5. Display full path of file in sublime
  6. change command+click handler in iterm (macOS)
    • (Not solved yet)
  7. Convenient scripts:

 View on Github Last updated Jul 16, 2019 (4:55pm) 
  Steal Like an … (Jul 15)
Gotcha! (Jun 25)