NC News (Backend)
An API for the purpose of accessing application data programmatically. The intention here is to mimic the building of a real world backend service (such as Reddit) which should provide this information to the front end architecture.
Learning outcomes:
- Setting up and querying a PostgreSQL relational database.
- Using a Test Driven Development approach to cover both the happy and error paths.
- Setting a RESTful API with a number of endpoints which cover CRUD operations.
- Setting up parametric endpoints.
- Handling complex queries.
- Manipulating data to respond to client requirements.
- Using Express routing to handle client requests.
- Hosting the server and database via ElephantSQL and Render.
Tech stack
Express.js
PostgreSQL (hosted via Render and ElephantSQL)