PostgreSQL API Backend for Buoy

Hey guys! Let me tell you what I have been up to:

PostgreSQL:

PostgreSQL is an back-end database that will hold the data collected from the buoy. In the future it will also hold data collected from local Weather Underground weather stations using web scraping.

API Backend:

A FastAPI back-end was coded in python (running in my home lab) to use a PostgreSQL server running on a separate Raspberry Pi 5.

My homelab may or may not be at 95% storage used ;-;

Functions

• Ability to use HTTP commands (most) to send, delete, and view data.
• Communication with the PostgreSQL database
• Use of a “api-key” to only allow the buoy to POST data