essamalsaloum

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

essamalsaloum

#! /bin/bash

# ECHO COMMAND
# echo Hello World!

# VARIABLES
# Uppercase by convention
# Letters, numbers, underscores
NAME="Bob"
# echo "My name is $NAME"

essamalsaloum

# For more information on configuration, see:
#   * Official English Documentation: http://nginx.org/en/docs/
#   * Official Russian Documentation: http://nginx.org/ru/docs/

user  nginx;
worker_processes  1;

error_log  /var/log/nginx/error.log;
#error_log  /var/log/nginx/error.log  notice;
#error_log  /var/log/nginx/error.log  info;

essamalsaloum

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

essamalsaloum

LEVEL 0

Updated: October 2017

Play These Games :

• http://lightbot.com/hour-of-code.html
• http://spritebox.com/flash.html
• https://studio.code.org/flappy/1
• https://code.org/minecraft
• https://www.codecademy.com/hour-of-code

essamalsaloum

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)

essamalsaloum

##Setup your server (this would ideally be done with automated provisioning)

• add a deploy user with password-less ssh see this gist
• install forever npm install -g forever

##Install flightplan

• npm install -g flightplan
• in your project folder npm install flightplan --save-dev
• create a flightplan.js file

essamalsaloum

class Observable {

  constructor(subscriber) {
    this.subscriber = subscriber
  }

  subscribe(observer) {
    if (typeof observer == 'function') observer = {next: observer}
    if (!observer.next)     observer.next     = () => {}
    if (!observer.complete) observer.complete = () => {}

essamalsaloum

function Observable(init_value) {
    var _value = init_value;
    var subscriber = [];

    function obs() {
        if (arguments.length) {
            _value = arguments[0];
            obs.trigger();
            return this;
        } else {

essamalsaloum

CREATE VIEW ClassesAndRunningInformation AS
SELECT 
  ClassGroup.Name AS ClassGroupName,
  Running.StartDate,
  Module.Name AS ModuleName,
  Module.Length AS ModuleLength
FROM
  ClassGroup
    INNER JOIN
  Running