gem-hunter
Language: JavaScript
RESTful API with Node.js, Express, and Postgres.
Create, read, update, delete in a Node.js app with an Express server and Postgres 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');
git clone git@github.com:taniarascia/node-api-postgres
cd node-api-postgres
npm install
node index.jscurl http://localhost:3000/userscurl --data "name=Jerry&email=jerry@example.com" http://localhost:3000/userscurl -X PUT -d "name=George" -d "email=george@example.com" http://localhost:3000/users/1curl -X "DELETE" http://localhost:3000/users/1This project is open source and available under the MIT License.