Build an Inventory Microservice in Go

Problem/Feature Description

Build a product inventory microservice in Go using the standard library net/http router (Go 1.22+). The service will be deployed as a Docker container in a managed container platform with automatic scaling.

Endpoints:

• GET /api/products -- list all products
• POST /api/products -- add a product (fields: name, sku, quantity, price)
• GET /api/products/{id} -- get product by ID
• PUT /api/products/{id} -- update product stock quantity
• DELETE /api/products/{id} -- remove a product

Use SQLite via modernc.org/sqlite for persistence. SKU must be unique.

Output Specification

Produce:

• main.go -- Application entry point, server setup, and routing
• handlers.go -- HTTP handler functions
• db.go -- Database connection and queries
• go.mod -- Module definition with dependencies
• Dockerfile -- Multi-stage build for production