PostgreSQL and NodeJS

Check out the blog post >> http://mherman.org/blog/2015/02/12/postgresql-and-nodejs

This is a basic single page application built with Node, Express, Angular, and PostgreSQL.

Quick Start

1. Clone the repo
2. Install dependencies: npm install
3. Start your Postgres server and create a database called "todo"
4. Create the database tables: node server/models/database.js
5. Start the server: $ npm start

Tests

This comes with a load test using Apache Bench that by default exercises the API endpoint for the /api/v1/todos service:

sh tests/load-test.sh

Using this load test it is possible to verify several things:

• that the database is using as many connections as expected (it polls PostgreSQL for the number of active connections while it runs)
• the performance of the combined system under different loads

See the comments in the script for more information.