Keyvan Kasaei kkasaei

## gist:3e224d7c25e5b21667f9
//test

## meta-tags.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                kkasaei
                / meta-tags.md
            
            
              Created
              January 28, 2016 23:20
                — forked from kevinSuttle/meta-tags.md
            
              
                List of Usable HTML Meta and Link Tags
              
          
    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.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                kkasaei
                / sqlite3-cheat-sheet.md
            
            
              Created
              February 16, 2016 08:01
                — forked from vincent178/sqlite3-cheat-sheet.md
            
              
                sqlite3 cheat sheet
              
          
    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

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

<body>

<script>

## Git Commands
# 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>"

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

## postgres-cheatsheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                kkasaei
                / postgres-cheatsheet.md
            
            
              Created
              December 16, 2017 12:10
                — forked from Kartones/postgres-cheatsheet.md
            
              
                PostgreSQL command line cheatsheet
              
          
    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)


## README.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                kkasaei
                / README.md
            
            
              Created
              January 3, 2018 23:33
            
              
                Sequelize + Express + Migrations + Seed Starter
              
          
    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

  
## Postgres How-to(s)
SHOW TABLE:
Postgres psql needs escaping for capital letters.
Database=# \d+ "TestTable1"

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

Switch Database
\c tableName

## How to kill the process on port 3000 on mac
https://stackoverflow.com/questions/3855127/find-and-kill-process-locking-port-3000-on-mac
	<!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