POSTMAN DOCS - here
- Get available movies for given - Cinema, Date
- Check available seats for a show
- Book tickets for a slot
It's important to note that adding indexes also comes with some overhead, as they consume additional storage space and require maintenance during data modification operations (such as inserts, updates, and deletes). Hence we should add them only when a bottleneck is observed.
In this example indexing the foreign keys for Shows table would be good as this will speed up our joins. Also if we want to prioritize them then indexing the HallId in Shows table should be prioritized as it is used more frequently than the rest.
- JWT Auth
- Normalization of database
- Locking the DB while bulk operation with transactions
- Elastic Search for querying movies with filters(language, genre and dimension like 3D, 4D etc..) and fuzzy search
- Adding comments for a movie and retrieving with Mongo (for better write performance)
- Caching of movie details endpoints with Redis
