Skip to content

Instantly share code, notes, and snippets.

View fr-xiaoli's full-sized avatar

Xiaoli Shen fr-xiaoli

View GitHub Profile
@Kartones
Kartones / postgres-cheatsheet.md
Last active December 16, 2025 14:00
PostgreSQL command line cheatsheet

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)
@shytikov
shytikov / commit-msg
Created July 17, 2012 21:07
commit-msg hook script
#!/bin/sh
#
# Automatically adds branch name and branch description to every commit message.
#
NAME=$(git branch | grep '*' | sed 's/* //')
DESCRIPTION=$(git config branch."$NAME".description)
TEXT=$(cat "$1" | sed '/^#.*/d')
if [ -n "$TEXT" ]
then
@fabrizioc1
fabrizioc1 / akamai_debug_headers.txt
Last active December 6, 2025 12:31
Akamai debug headers
Pragma: akamai-x-cache-on, akamai-x-cache-remote-on, akamai-x-check-cacheable, akamai-x-get-cache-key, akamai-x-get-extracted-values, akamai-x-get-nonces, akamai-x-get-ssl-client-session-id, akamai-x-get-true-cache-key, akamai-x-serial-no