Skip to content

Instantly share code, notes, and snippets.

View shekcon's full-sized avatar
😍
Software Engineer

Quang Sang shekcon

😍
Software Engineer
View GitHub Profile
@shekcon
shekcon / postgres-cheatsheet.md
Created July 22, 2019 03:31 — 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)
@shekcon
shekcon / webdev_online_resources.md
Last active August 30, 2019 17:28 — forked from bradtraversy/webdev_online_resources.md
Online Resources For Web Developers (No Downloading)
@shekcon
shekcon / node_nginx_ssl.md
Created December 20, 2019 03:53 — forked from bradtraversy/node_nginx_ssl.md
Node app deploy with nginx & SSL

Node.js Deployment

Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

1. Sign up for Digital Ocean

If you use the referal link below, you get $10 free (1 or 2 months) https://m.do.co/c/5424d440c63a

2. Create a droplet and log in via ssh

I will be using the root user, but would suggest creating a new user