One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
| /* ******************************************************************************************* | |
| * THE UPDATED VERSION IS AVAILABLE AT | |
| * https://github.com/LeCoupa/awesome-cheatsheets | |
| * ******************************************************************************************* */ | |
| // 0. Synopsis. | |
| // http://nodejs.org/api/synopsis.html |
| import psycopg2 | |
| from sshtunnel import SSHTunnelForwarder | |
| # For interactive work (on ipython) it's easier to work with explicit objects | |
| # instead of contexts. | |
| # Create an SSH tunnel | |
| tunnel = SSHTunnelForwarder( | |
| ('128.199.169.188', 22), | |
| ssh_username='<username>', |
| # Redis Cheatsheet | |
| # All the commands you need to know | |
| redis-server /path/redis.conf # start redis with the related configuration file | |
| redis-cli # opens a redis prompt | |
| # Strings. |
This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.
http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL
| // _____ __ _ _ | |
| ///__ \_ _ _ __ ___/ _\ ___ _ __(_)_ __ | |_ | |
| // / /\/ | | | '_ \ / _ \ \ / __| '__| | '_ \| __| | |
| // / / | |_| | |_) | __/\ \ (__| | | | |_) | |_ | |
| // \/ \__, | .__/ \___\__/\___|_| |_| .__/ \__| | |
| // |___/|_| |_| | |
| //Typescript Cheat Sheet: every syntax feature exemplified | |
| //variables are the same as javascript, but can be defined with a type: | |
| var myString:string; |
| // check version | |
| node -v || node --version | |
| // list installed versions of node (via nvm) | |
| nvm ls | |
| // install specific version of node | |
| nvm install 6.9.2 | |
| // set default version of node |
| //Resources: | |
| //https://www.postgresql.org/docs/10/static/sql-commands.html < --- PostgreSQL API Documentation | |
| //https://www.techonthenet.com/postgresql/index.php < --- Tutotial | |
| //Some Common Commands | |
| //Start PostgreSQL | |
| brew services start postgresql | |
| //Stop PostgreSQL |
| Using Git | |
| =============== | |
| Branch | |
| ----------- | |
| Show branches: | |
| `git branch` | |
| Create branch: |