Travis H tphdev

General Installation

[] Install MySQL-Server

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04
lets you run mysql instance

sudo apt-get update
sudo apt-get install mysql-server

Deploy Process

1 - Create an account on heroku

2 - Install heroku CLI, authenticate

npm install -g heroku

Open Terminal

In Terminal

# 1) edit terminal
echo 'PS1="\[\033[40m\]\[\033[36m\]\w\\[\033[00m\] :: "' >> ~/.bashrc && source ~/.bashrc

# 2) create `public` folder

Slides

Code

setup

npm init
npm install --save express

`package.json`

Overview

Survey: https://www.surveymonkey.com/r/js_dipl_ce
DB + MySQL Critical Concepts

Architecture Review

The big picture

Relational Model :

A framework for managing data. Data is organized into tables and relations.

Tables

============
TABLES (representation of data)
============

Relational Model A framework for describing data. Data is organized into tables and relations.

SQL stands for Structured Query Language. It’s a standard language for implementing a Relational Model accessing and manipulating Relational databases.

MySQL is a RDMS (Relational Database Management System) that implements SQL .

like SQL Server, Oracle, Postgres, etc.

CREATE DATABASE HOSPITAL

	#!/bin/bash

	# (i) clone the repo
	mkdir -p ~/tmpdir && cd ~/_tmpdir

	git clone https://github.com/github/hub.git && cd hub

	# (iii) build the hub script w/ go
	script/build -o ~/bin/hub

	#!/bin/bash

	mkdir -p ~/__tempdldir/
	cd ~/__tempdldir

	# + (i) download + unzip Go-language @ https://golang.org/doc/install?download=go1.9.linux-amd64.tar.gz
	curl https://dl.google.com/go/go1.10.2.linux-amd64.tar.gz > go1.10.2.linux-amd64.tar.gz
	sudo tar -C /usr/local -xzf go1.10.2.linux-amd64.tar.gz