/node-api-postgres

RESTful API with Node.js, Express, and Postgres.

Primary LanguageJavaScriptMIT LicenseMIT

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:taniarascia/node-api-postgres
cd node-api-postgres
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

Author

License

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