jbonney’s gists

jbonney / link.txt

Created September 4, 2013 07:23

Screenfly. Responsive screen testing on monitors, tablets, smart phones, and more.

http://quirktools.com/screenfly/

jbonney / links.txt

Created September 1, 2013 16:24

Learning ressources

	# HTML / CSS
	http://learn.shayhowe.com/html-css/

jbonney / links.txt

Created September 1, 2013 16:14

Ressources to learn more about mina (automatic deployment scripts)

	https://github.com/alfuken/mina-rails-unicorn-nginx-god/blob/master/config/deploy.rb
	https://github.com/makevoid/decibel/blob/master/config/deploy.rb

jbonney / tunnels.sh

Created August 31, 2013 10:28

SSH tips and tricks from http://www.itworld.com/it-managementstrategy/261500/16-ultimate-openssh-hacks?page=0,2

	# Tunnel: allow to use localhost:2525 as if it was server.com:25
	ssh -f user@server.com -L 2525:server.com:25 -N
	# SOCKS Proxy: configure web browser to use SOCKS proxy on localhost:8080
	ssh -D 8080 -C user@server.com

jbonney / links.txt

Created August 30, 2013 23:15

Git flow process and ressources

	# Git flow
	http://nvie.com/posts/a-successful-git-branching-model/
	https://github.com/nvie/gitflow/tree/master#readme
	http://jeffkreeftmeijer.com/2010/why-arent-you-using-git-flow/
	# Git best practices
	http://kentnguyen.com/development/visualized-git-practices-for-team/
	http://gitguru.com/2009/02/22/integrating-git-with-a-visual-merge-tool/
	# Push to remote server
	http://www.arlocarreon.com/blog/git/push-git-repo-into-shared-hosting-account-like-hostgator/
	http://motorscript.com/setting-up-a-remote-git-repo-on-shared-server-like-hostgator/

jbonney / handsontable.txt

Created August 30, 2013 22:56

Handsontable 0.9.16: a minimalistic Excel-like data grid editor for HTML, JavaScript & jQuery (http://warpech.github.io/jquery-handsontable/index.html)

http://warpech.github.io/jquery-handsontable/index.html

jbonney / conversion.sh

Created August 30, 2013 22:08

Convert MySQL default character set (encoding) from latin1 to utf8.

	mysqldump --user="username" --password="password" -c -e --default-character-set=utf8 --single-transaction --skip-set-charset --add-drop-database -B "database_name" > dump.sql
	sed 's/DEFAULT CHARACTER SET latin1/DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci/' <dump.sql \| sed 's/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/' >dump-fixed.sql
	mysql --user="username" --password="password" < dump-fixed.sql

jbonney / mysqldump.sh

Created August 30, 2013 22:04

MySQL dump to export data only (no DB schema nor table instructions). Particularly useful when exporting a Rails DB to re-import it afterwards in a DB that has been created through `rake db:drop db:create db:migrate`.

mysqldump --user="username" --password="password" --skip-triggers --compact --no-create-info --ignore-table="database_name.schema_migrations" --ignore-table="database_name.table_populated_through_migration" "database_name" > "dump.sql"

jbonney / encoding.sql

Created August 29, 2013 19:26

From http://makandracards.com/makandra/2529-show-and-change-mysql-default-character-set. View DB charset / collation / encoding.

	SHOW VARIABLES LIKE 'char%';
	SHOW VARIABLES LIKE '%collation%';
	SHOW TABLE STATUS FROM database_name;

jbonney / charset.sh

Created August 29, 2013 07:24

From http://stackoverflow.com/questions/1730878/encoding-of-file-shell-script - Get encoding information about a file.

file --mime myfile.txt

Jimmy Bonney jbonney