Git can be your best friend or your worst enemy at times. Navigating through the treacherous waters can be sometimes nerve racking for even long time users at times.

Not all git processes are the same. With using git more than 10 years now, I have seen several different processes within companies.  Our of these, main practices I have noted are these:

• Git Branch Methodology
• Git Commit Methodology

I will break down each of these with pros and cons and show you the series of git commands that works best for each. To make it easier to understand, I will use a book analogy, with chapters being the branches and commits being the pages.

Git Branch Methodology

Using branches I have found to be the most common practice. It usually conisists of these commands.

• To start: git clone {repo}
• You're

We will be going through how to setup Postgres locally on mac. We will cover the following:

• Starting Postgres
• Using psql to interact with database in command-line
• Creating your first database.
• Manage Data (Create Table, Inserting Data, Viewing Data)
• Stopping Postgres

Let's start off with making sure we have Postgres installed locally. Open up terminal on mac and run postgres --version. You should see the version information outputted.

If you don't see the postgres version or need to install it still. Check out the Install Postgres on Mac post. Now that we have that out of the way, let's continue.

Step 1

In terminal, run the following command. It will start Postgres locally.
brew services start postgresql

Step 2

Next, let's go into the Postgres server now that it's up and running. Run the following:

PostGres has grown a lot recently in popularity, as a free alternative to enterprise relational databases such as Oracle SQL, and also as a database to get a new application cranking very quickly that comes filled with features and easy to setup.

Now let's get one of the best databases ever up and running on your Mac. As a developer, I think you owe it to yourself to have Postgres installed :)

1. Open Terminal

2.   Now copy and paste brew install postgresql then hit enter.

3.    Last, in Terminal, copy and paste postgres --version and hit enter.

You should see the PostGres version output in your console. This is good news. You're ready to go. You can create your database and start storing data. Checkout PostGres Documentation to learn more about all you can do with the PostGres database.

Node.js and PostGres have grown in popularity for several companies to have in their tech stack. Let's do a quick walkthrough on how to setup and write our first query.

We will be using:

• Node.js/NPM
• PostGres
• Knex

Prerequisites:

• Node and npm already installed
• Postgres database setup (Tutorial Here)

Assuming you have the prerequisites. If you haven't you can follow the instructions here. Let's stat by creating a new project. Open Terminal or your CLI tool of choice. I recommend iTerm. Let's create a new project.

mkdir new-project
cd new-project
npm init

You will then be prompted to name the project, license, etc. You can just click "enter" through these.

Next create our server.js node file and past the following code below.

server.js

require('dotenv');
var knex = require('knex')({
    client: 'pg',
    connection: {
        user: process.env.USER,