Movie DB

An example CRUD app to list, search, add, edit and delete movies.

Goals

Allows users to list, search, add, edit and delete movies
- List and Search implemented as HTTP REST endpoints
Store movies to a database
- Inserting new records not yet implemented
process for ingesting that csv into the database
- Workaround implemented as SQL dump
provide a frontend to perform operations on the database more easily
- UI with search and paging supported

docker-compose up

docker-compose down

Individual components can be started as follows:

docker-compose up db to start a local mysql db

docker-compose up db server if you just are developing web

cd /server and npm run dev for starting the api

cd /web and npm start for starting the web service

Here are some steps followed to develop

Initialize a project scaffold, some files generated with starter-files
npm init, create stubbed endpoints, and Docker support
Import test data from CSV via DataGrip
- Ideally, would import from CSV directly, but ran into challenges
- 16 rows failed to import due to missing record separators(?)
- As a workaround to importing the CSV directly, 2_insert_data.sql was created from a sql data dump after uploading CSV in DataGrip
Implement GET /movies to return all movies
Bootstrap a React project with npm init react-app
Create a simple UI that renders sample data using React Bootstrap
Connect UI to server to load movies
Add a loading spinner and basic pagination
- Local API response time is ~2 seconds, but the rendering time for all elements is awful
- Typically, a paged API response is preferable to returning all records
Add search capability