:eyeglasses: Advanced example of using pg-promise
This is an advanced demo of the best practices of using pg-promise, and managing your database architecture.
It shows how to organize an enterprise-level database application, with consideration for ever-growing complexity of the database and queries.
The demo focuses on the following:
The demo includes two separate implementations, with identical functionality:
Each uses a basic HTTP service to let you quickly test db calls in a browser. Do not however reuse any of the HTTP-service code, it is over-simplified, for the test, not for you to copy. The demo focus is on the database layer only.
You can either clone it or install via
$ npm install pg-promise-demo.
This demo is here mostly for you to browse through its source code, understand its structure and the overall approach. It is also simple enough that running it isn't really necessary.
Once the application is up and running, you can fire away URL commands in a browser, as per the web API that's implemented, while watching what's happening in:
The application implements two tables:
users->productsas one-to-many. Once the app is running, you should create and populate those as the very first commands:
/users/create /users/init /products/create
After that see other supported API commands in the code:
/users/empty /users/drop /users/find/:id /users/remove/:id /users/all /users/total
/products/drop /products/empty /products/add/:userId/:name /products/find/:userId/:name /products/remove/:id /products/all /products/total