Skip to content

Instantly share code, notes, and snippets.

View stevalberts's full-sized avatar
🏠
Working from home

StevalbertS stevalberts

🏠
Working from home
View GitHub Profile
@stevalberts
stevalberts / postgres-cheatsheet.md
Created December 24, 2021 15:40 — 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)

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

@stevalberts
stevalberts / Firebase.md
Created February 25, 2021 15:22 — forked from victorbruce/Firebase.md
My journey with Firebase so far. Cheatsheet to serve as a quick reference when developing firebase applications

Firebase

Set up firebase and Deploy

  • Head over to firebase. Sign in and create a project.

  • Copy your project settings under Firebase SDK snippet into your local project (ie your project's api key, auth domain, databaseURL, etc)

  • Create a file (firebase.js or config.js Any name that suits you is fine)

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database