Node Postgres Insert Multiple Rows

You might be wondering how to insert multiple rows into a table using Node Postgres. Most examples show adding only one row at a time. Some solutions recommend using a control flow library like async. But this technique is slow and inefficient because it uses too many connections or sends the queries one by one. Other solutions recommend using a heavyweight ORM, but this might require a significant rewrite of your application.

How to install PostgreSQL for Mac for Node

Installing PostgreSQL for Mac is very simple when you use Postgres.app.

Async Await for Passport.js Authentication in Express.js

The goal of this blog post is for you to know exactly how to implement the LocalStrategy for PassportJS using async/await patterns in your express.js application.

Ten Minutes to 10K

Developing a product and hoping it sticks isn't a strategy. There is a better way ( I think ).

Growth Team Resources

Hi, my name is Will Laurance and I am a growth software engineer at CreativeLive. CreativeLive offers over 1500 class in photography, graphic design, crafting, business, and entrepreneurship. The current growth team started roughly a year ago in February 2017.

Slow Down - How I am avoiding Bitcoin Mania

Today I dropped my girlfriend off for her flight back to San Francisco. I'm here in Virginia two more days with my Parents. It was a blistering cold 20 degrees and a strong chilling breeze at the airport. I kissed my girlfriend goodbye and wished her a safe flight.

Personal MBA Book Review

I decided to pick up this book because I was not comfortable with my current understanding of business definitions, practices, and procedures.

15 Dollar Bootstrapers Marketing Stack

I want to share my journey with marketing as a software developer. I am still a marketing novice but I've been able to collect close to 200 double opt-in subscribers who actually want to hear from me on a regular basis.

How to use Mongoose Push to add to an array

The push operator appends the value to an array.

How to Find an Apartment in San Francisco

Finding apartments for rent in San Francisco is daunting. Especially if you aren't used to the prices and real estate market that we have here. And the cheaper the price the more competitive it will be. Finding a room share in San Francisco is all about being trustworthy, making a great first impression, and proving you can pay rent. Finding a room can be tough if you don't already know someone. In my experience competition goes down as you increase in the number of bedrooms from studio, 1 bedroom, 2 bedrooms, and 3 bedrooms.

How to use transactions with node postgres

Transactions in computer programming are essential for data integrity. Transactions provide primitives for guaranteeing your query logic succeeds or fails gracefully. A transaction contains any number of statements. At any point you can rollback if an error occurs or your logic fail conditions trigger.

How To NGINX reverse proxy to another server

Why would you want to use the proxy_pass directive?

Node Postgres Example

This small tutorial shows how to connect and query Postgres using Node.

NGINX Rewrite Subdomain to Path

In this post I show you how to rewrite subdomain requests to a path.

A New Year A New Go Routine

I want to talk about a programming language I absolutely love. I think you will too.

Selling a Product and not a Commodity

I want to sell products.

A New Start

It is a wonderful feeling to start a new chapter in life. Change is always a bit scary, but in my experience, the benefits always outweigh any interim anxiety created.

2014 - Lessons Learned

2014 was a great year. I grew my freelancing business, built some small products, and had fun. Here are three lessons I am taking with me in 2015.

Thinking Too Big - Ship Smaller Products

So I had an idea, like most people like me do. That itch you want to scratch for whatever reason.

Fun with Nodebots

This past Saturday, I participated in my first International Nodebots Day! I attended @norfolkjs's event located at 757 Makerspace.

Standing Desk Accomplished

In April I blasted out some goals to accomplish this year.

2014 Goals

My Goals for 2014

Using PostgreSQL and Node

I'm using node-postgres, node-sql, and node-db-migrate to build a time tracking API, currently named tempus and it's a wonderful experience.

Life is too short, drink better coffee

tl;dr

node.js -e vs node.js -p

The difference between node -e and node -p is p will run the script through the interpreter and print the results. The -e will only evaluate the script. The time -e will print anything is if something writes to stdout or stderr.

Node.js Simple Progress Indicator Using Charm

Charm is a module used to write colors and cursor positions to a stream.

NGINX redirect for multiple virtual hosts

If you want to redirect traffic to a different subdomain, you can add a rewrite clause into each of your server{} entries in /etc/nginx/sites-avaliable/default or where ever you keep your available sites located.

Node.js documentation app

I am currently working on a node.js documentation app similar to andnodejs. I really like andnodejs but the versions of node are not being updated with the app. But I figured why not just let the user choose which versions of node they would like to have installed. Nodoroid solves this problem by allowing the user to choose which version of the node documentation they have. It also supports having as many versions as you would like. The view of docs will be in a similar manner to andnodejs.