shiburajsingh/Book_Review ? reverse-engineered prompt

Build me a simple book review API that lets me add, view, edit, and delete books and reviews. I want it to use FastAPI, save data in PostgreSQL, and include database migrations so the schema can be set up cleanly. Please also add Redis caching for the book list so repeated reads are faster, and make sure the app handles cache or database problems without crashing.

I’d like the API to be ready to run locally with a clear setup, and it should have interactive docs at /docs so I can test the endpoints easily. Please include a solid set of pytest tests for the main book and review flows too. If you need to check current docs for any libraries or best practices, go ahead and look them up online.