This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Export SQLite to CSV - Example | |
| # Replace "$database" and "$table" | |
| sqlite3 $database <<! | |
| .headers on | |
| .mode csv | |
| .output $database.csv | |
| select * from $table; | |
| ! |
supermasita
/ gist:decd55c44719005c5adc7ab27d844884
Created
May 3, 2016 21:46
NGINX - Determine if user agent is mobile and add set a different proxy_cache_key
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| location ~ / { | |
| # mobile users | |
| if ($http_user_agent ~* '(iPhone|iPod|mobile|Android|2.0\ MMP|240x320|AvantGo|BlackBerry|Blazer|Cellphone|Danger|DoCoMo|Elaine/3.0|EudoraWeb|hiptop|IEMobile)') { | |
| set $ismobile '1'; | |
| } | |
| proxy_cache_key $proxy_host$uri$ismobile; | |
| add_header X-Is-Mobile $ismobile; |
supermasita
/ gist:8935da063725f456de45a7ebe86e59ad
Created
May 3, 2016 21:41
Docker - Adding port to already runnning container (example)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo iptables -t nat -A DOCKER -p tcp --dport 443 -j DNAT --to-destination 172.17.0.1:443 |
NewerOlder