Name		Name	Last commit message	Last commit date
parent directory ..
README.md		README.md
drop.sql		drop.sql
index.js		index.js
package.json		package.json
sample_data.sql		sample_data.sql
sample_queries.sql		sample_queries.sql
schema.sql		schema.sql

README.md

Chapter 8: Shopping list with the direct PostgreSQL driver

This project is sample code to demonstrate Express and the PostgreSQL driver.

Usage instructions

npm install
If you have not created a PostgreSQL database, initialize one with npm run initdb
Ensure the PostgreSQL server is running on localhost (npm run postgres)
npm start to start the server
Open your browser to http://localhost:3000/items and http://localhost:3000/total

In addition, the following commands will directly update or query the database:

npm run schema will load the database schema into PostgreSQL
npm run sample_data will load sample data into PostgreSQL
npm run sample_queries will execute queries directly on the PostgreSQL database
npm run drop will drop all tables created by npm run schema