Skip to content

Instantly share code, notes, and snippets.

View jaboulos's full-sized avatar
:octocat:

Joe Boulos jaboulos

:octocat:
8 followers · 7 following
View GitHub Profile
@jaboulos
jaboulos / postgres-cheatsheet.md
Created November 12, 2019 16:50 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -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)
@jaboulos
jaboulos / docker-help.md
Created May 21, 2019 14:26 — forked from bradtraversy/docker-help.md
Docker Commands, Help & Tips

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

@jaboulos
jaboulos / mysql_cheat_sheet.md
Created May 14, 2019 19:10 — forked from bradtraversy/mysql_cheat_sheet.md
MySQL Cheat Sheet

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

@jaboulos
jaboulos / The Technical Interview Cheat Sheet.md
Created April 23, 2019 01:19 — forked from tsiege/The Technical Interview Cheat Sheet.md
This is my technical interview cheat sheet. Feel free to fork it or do whatever you want with it. PLEASE let me know if there are any errors or if anything crucial is missing. I will add more links soon.

Studying for a Tech Interview Sucks, so Here's a Cheat Sheet to Help

This list is meant to be a both a quick guide and reference for further research into these topics. It's basically a summary of that comp sci course you never took or forgot about, so there's no way it can cover everything in depth. It also will be available as a gist on Github for everyone to edit and add to.

Data Structure Basics

###Array ####Definition:

  • Stores data elements based on an sequential, most commonly 0 based, index.
  • Based on tuples from set theory.
@jaboulos
jaboulos / amz_linux_git.md
Created March 7, 2019 03:40 — forked from rjhintz/amz_linux_git.md
AWS Linux: Git Install From Source

AWS Linux: Installing Git from Source

Method

Method:

  1. sudo yum update
  2. sudo yum install curl-devel expat-devel gettext-devel openssl-devel perl-devel zlib-devel
  3. sudo yum install asciidoc xmlto docbook2X
  4. sudo yum install gcc autoconf
  5. sudo ln -s /usr/bin/db2x_docbook2texi /usr/bin/docbook2x-texi
  6. wget https://github.com/git/git/archive/v2.8.4.zip
@jaboulos
jaboulos / MySQL_macOS_Sierra.md
Created January 29, 2019 02:18 — forked from nrollr/MySQL_macOS_Sierra.md
Install MySQL on Sierra using Homebrew

Install MySQL on macOS Sierra

This procedure explains how to install MySQL using Homebrew on macOS Sierra 10.12

Install Homebrew

  • Installing Homebrew is effortless, open Terminal and enter :
    $ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
  • Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.

Install MySQL

At this time of writing, Homebrew has MySQL version 5.7.15 as default formulae in its main repository :

@jaboulos
jaboulos / README.md
Created November 4, 2018 19:02 — forked from hofmannsven/README.md
My simply MySQL Command Line Cheatsheet