Keyvan Kasaei kkasaei

Copied from http://code.lancepollard.com/complete-list-of-html-meta-tags/

Basic HTML Meta Tags

<meta charset='UTF-8'>
<meta name='keywords' content='your, tags'>
<meta name='description' content='150 words'>
<meta name='subject' content='your website's subject'>
<meta name='copyright' content='company name'>

SQLite3 Cheat Sheet

Info

Download from: http://www.sqlite.org/download.html Getting Started: http://www.sqlite.org/sqlite.html Documentation: http://www.sqlite.org/docs.html

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)

Sequelize + Express Starter Guide

Based off of: http://docs.sequelizejs.com/en/1.7.0/articles/express/

Create your project directory

Create and initialize your a directory for your Express application.

$ mkdir sequelize-demo

	<!doctype html>
	<html>
	<head>
	<title>Index DB DEMO</title>
	<!-- https://code.tutsplus.com/tutorials/working-with-indexeddb--net-34673-->
	</head>

	<body>

	<script>

	# User Config
	git config user.name "<your name>"
	git config user.email "<your email>"

	git config --globaluser.name "<your name>"
	git config --global user.email "<your email>"

	function searchWikipedia (term) {
	return $.ajax({
	url: 'https://en.wikipedia.org/w/api.php',
	dataType: 'jsonp',
	data: {
	action: 'opensearch',
	format: 'json',
	search: term
	}
	}).promise();

	SHOW TABLE:
	Postgres psql needs escaping for capital letters.
	Database=# \d+ "TestTable1"

	Describe Table:
	\d "myTable" describe table
	\d+ "myTable"

	Switch Database
	\c tableName