RESTful API with Node.js, Express, and Postgres

Create, read, update, delete in a Node.js app with an Express server and Postgres database.

Read the tutorial

Database

brew install postgresql
brew services start postgresql
psql postgres

CREATE ROLE me WITH LOGIN PASSWORD 'password';
ALTER ROLE me CREATEDB;
CREATE DATABASE api;
GRANT ALL PRIVILEGES ON DATABASE api TO me;

psql -d api -U me

CREATE TABLE users (
  ID SERIAL PRIMARY KEY,
  name VARCHAR(30),
  email VARCHAR(30)
);

INSERT INTO users (name, email)
  VALUES ('Jerry', 'jerry@example.com'), ('George', 'george@example.com');

Installation

git clone git@github.com:newcometlab/restapi-postgre
cd restapi-postgre
npm install
node index.js

Commands

• GET: curl http://localhost:3000/users
• POST: curl --data "name=Jerry&email=jerry@example.com" http://localhost:3000/users
• PUT: curl -X PUT -d "name=George" -d "email=george@example.com" http://localhost:3000/users/1
• DELETE: curl -X "DELETE" http://localhost:3000/users/1

License

This project is open source and available under the MIT License.