MICRO-SERVICES: Node-JS & Postgresql-String-DB

This application presents a simple microservice interface for multiple tables with different access routes. The dependant tables are both linked to the main table by a foreign key. There are three separate API access points, each catering for the respective table.

Input form named POST

Moreover, the is a form that has to be provided for API end-point test imitating how postman app works. You could use it to test GET and POST. Delete and Update are not yet implemented in the App. CRUD operations are implemented and exploited using three databases with a uniform interface as JSON data connectivity. Data entry MUST include a complete dataset for validations and integration requirements.

Technology Stack exploited

1. NodeJS
2. Database1 (PostgreSQL)
3. Database2 (MySQL)
4. Database3 (MSSQL)
5. Change port and passwords respectively

Execution Commands

Execution of this application use the following command

npm i
npm start
npm stop
node server.js

Localhost links

http://localhost:3030/temployees
http://localhost:3030/tclients
http://localhost:3030/tloans

Localhost links

http://localhost:3030/temployees/1
http://localhost:3030/tclients/1
http://localhost:3030/tloans/1

Interface U-Xperience

Below are screen shots from the application output

Week #27

30/03/2023

END