Bookstore REST API

Project roadmap

1. 01

   Set up Gin and the database

   ~1.5h

   Initialize a Gin router and connect to PostgreSQL using sqlx.

2. 02

   Design the schema

   ~1.5h

   Create and migrate the books and orders tables with appropriate relationships.

3. 03

   Build book endpoints

   ~2.5h

   Implement CRUD endpoints for books with request validation and structured JSON responses.

4. 04

   Build order endpoints

   ~2.5h

   Implement order creation that decrements stock inside a database transaction.

5. 05

   Add pagination and filtering

   ~1.5h

   Support page, limit, and filter query parameters on the book listing endpoint.

6. 06

   Add middleware

   ~1.5h

   Add request logging middleware and a centralized error-handling middleware.

Resources

• DocsGo Documentation