A hand holding a pen, about to write something in a project planner.

Custom Wine API with Flask and PostgreSQL

Project Summary

Built a custom API to serve wine-related data from a PostgreSQL database. The API provides endpoints for wineries, wines, ratings, and harmonizers, returning structured JSON responses. Containerized with Docker for simple and portable deployment.

Highlights:

  • Designed a PostgreSQL database for wines, wineries, ratings, and harmonizers
  • Developed RESTful API endpoints in Flask to access wine-related data
  • Implemented SQL queries to return structured JSON responses
  • Containerized the API with Docker for easy deployment

Outcome:

  • Provided a clean API to access wine-related data
  • Enabled integration with analytics and dashboards
  • Delivered a portable, deployable solution
  • Technologies used

    • Python
    • Flask
    • PostgreSQL
    • Docker
    View the code.
    Projects