Hussam Adil HussamAdil

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

Backend Architectures

Twitter

ror, scala, jetty, erlang, thrift, mongrel, comet server, my-sql, memchached, varnish, kestrel(mq), starling, gizzard, cassandra, hadoop, vertica, munin, nagios, awstats

Introduce Gizzard of Twitter - 트위터의 새로운 분산 관리 라이브러리 Gizzard를 소개합니다.
The Architecture Twitter Uses to Deal with 150M Active Users, 300K QPS, a 22 MB/S Firehose, and Send Tweets in Under 5 Seconds
Scaling Twitter: Making Twitter 10000 Percent Faster

Overview

Source: https://medium.com/@Mahmoud_Zalt/eloquent-relationships-cheat-sheet-5155498c209

	One to one (`1-1`)	One to many (`1-n`)	Poly one to many (`1x-n`)	Many to many (`n-n`)	Poly many to many (`nx-n`)
Number of models	2 only	2 only	3 and above	2 only	3 and above
Number of tables	2 (1/model)	2 (1/model)	3+ (1/model)	3 (1/model + pivot)	4+ (1/model + pivot)
Pivot table	-	-	-	required

Studying for a Tech Interview Sucks, so Here's a Cheat Sheet to Help

This list is meant to be a both a quick guide and reference for further research into these topics. It's basically a summary of that comp sci course you never took or forgot about, so there's no way it can cover everything in depth. It also will be available as a gist on Github for everyone to edit and add to.

Data Structure Basics

###Array ####Definition:

Stores data elements based on an sequential, most commonly 0 based, index.
Based on tuples from set theory.

Tabs and Windows

Function	Shortcut
New Tab	`⌘` + `T`
Close Tab or Window	`⌘` + `W` (same as many mac apps)
Go to Tab	`⌘` + `Number Key` (ie: `⌘2` is 2nd tab)
Go to Split Pane by Direction	`⌘` + `Option` + `Arrow Key`
Cycle iTerm Windows	`⌘` + `backtick` (true of all mac apps and works with desktops/mission control)

	## install youtube-dl

	sudo curl -L https://yt-dl.org/downloads/latest/youtube-dl -o /usr/local/bin/youtube-dl

	sudo chmod a+rx /usr/local/bin/youtube-dl

	## To List all available formats before download :

	youtube-dl -F playlisturl

	create new repository
	git init
	git add README.md
	git add .
	git commit -m "first commit"
	git remote add origin your-repository-url.git --force
	git push -u origin master