View php-cheatsheet.md

Debugging

  • Dump backtrace:
var_dump(debug_backtrace());

Testing

  • Filter PHPUnit to only run one test:
View mysql-cheatsheet.md

Query/Table Analysis

  • EXPLAIN <tablename>: Describe query execution plan
  • SHOW INDEXES FROM <tablename>: List indexes of a table
  • SHOW DATABASES: Self-explanatory
  • USE <dbname>: Connect to a specific database
  • SHOW TABLES: Self-explanatory- DESCRIBE <tablename>: List table format (columns, etc.)
  • SHOW full processlist: Lists all currently executing queries

Configuration

View no-css
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}
View imagemagick.md

imagemagick

  • Nornalize all images of a folder converting them to jpgs with 90% quality (warning, removes original files):
rename 's/\.JPG$/\.jpg/' *.JPG
rename 's/\.JPEG$/\.jpg/' *.JPEG
rename 's/\.jpeg$/\.jpg/' *.jpeg
mogrify -format jpg *.png
mogrify -resize 1600x1280\> -quality 90 *.jpg
rm *.png
View linux-debugging-cheatsheet.md
  • Listen to a port:
sudo tcpflow -ciany port 666
  • Find ports in use:
sudo netstat -ntpl
sudo netstat -an | grep 666
View python-cheatsheet.md
View statsd-local-server.md
View CURL-cheatsheet.md
  • XML GET
curl -H "Accept: application/xml" -H "Content-Type: application/xml" -X GET "http://hostname/resource"
  • JSON GET
curl -i -H "Accept: application/json" -H "Content-Type: application/json" -X GET "http://hostname/resource"
  • JSON PUT
View postgres-cheatsheet.md

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

  • -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)
View keybase.md

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: