Brad Traversy bradtraversy

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

VSCode Shortcuts

List of helpful shortcuts for faster coding

If you have any other helpful shortcuts, feel free to add in the comments of this gist :)

Official List of all commands

Windows
Mac

Wordpress & Docker

This file will setup Wordpress, MySQL & PHPMyAdmin with a single command. Add the code below to a file called "docker-compose.yaml" and run the command

$ docker-compose up -d

# To Tear Down
$ docker-compose down --volumes

Pipenv Cheat Sheet

Install pipenv

pip3 install pipenv

Activate

pipenv shell

Django Deployment to Ubuntu 18.04

In this guide I will go through all the steps to create a VPS, secure it and deploy a Django application. This is a summarized document from this digital ocean doc

Any commands with "$" at the beginning run on your local machine and any "#" run when logged into the server

Create A Digital Ocean Droplet

Use this link and get $10 free. Just select the $5 plan unless this a production app.

Django 2.x Cheat Sheet

Creating a virtual environment

We need to create a virtual env for our app to run in: More Here Run this command in whatever folder you want to create your venv folder

python -m venv ./venv

Docker Commands, Help & Tips

Show commands & management commands

$ docker

	{
	"Console Log": {
	"prefix": "cl",
	"body": "console.log($1);",
	"description": "Console Log"
	},
	"Named Function": {
	"prefix": "nfn",
	"body": ["function ${1:functionName}($2) {", " $3", "}"],
	"description": "Named Function"

	const request = require('request');
	const cheerio = require('cheerio');
	const fs = require('fs');
	const writeStream = fs.createWriteStream('post.csv');

	// Write Headers
	writeStream.write(`Title,Link,Date \n`);

	request('http://codedemos.com/sampleblog', (error, response, html) => {
	if (!error && response.statusCode == 200) {

	const cacheName = 'v2';

	// Call Install Event
	self.addEventListener('install', e => {
	console.log('Service Worker: Installed');
	});

	// Call Activate Event
	self.addEventListener('activate', e => {
	console.log('Service Worker: Activated');