Postgsail | Internet of Things (IoT) Project

Abstract

Postgsail is an open-source Internet of Things (IoT) project. PostgSail backend. Effortlessly logs sails, automatically capturing trips, moorages, dockings and anchorages with no additional need to stop/start anything. PostgSail is an open-source alternative to traditional vessel data management. It is based on a well known open-source technology stack, Signalk, PostgreSQL, TimescaleDB, PostGIS, PostgREST. It is built using PLpgSQL, PostgreSQL. Key capabilities include: Automatically log your voyages without manually starting or stopping a trip; Automatically capture the details of your voyages (boat speed, heading, wind speed, etc); Timelapse video your trips, with or without time control. The complete source code is publicly available on GitHub under the Apache License 2.0, making it a useful reference for students building an Internet of Things (IoT) mini project or final-year project.

1. Introduction

PostgSail is an open-source alternative to traditional vessel data management. It is based on a well known open-source technology stack, Signalk, PostgreSQL, TimescaleDB, PostGIS, PostgREST. It does perfectly integrate with standard monitoring tool stack like Grafana.

PostgSail is an open-source alternative to traditional vessel data management! View Demo . Report Bug . Request Feature . Website . Docs . Sponsors . Discord . DeepWiki

Effortless cloud based solution for storing and sharing your SignalK data. Allow you to effortlessly log your sails and monitor your boat with historical data.

2. Objective

PostgSail backend. Effortlessly logs sails, automatically capturing trips, moorages, dockings and anchorages with no additional need to stop/start anything.

This project demonstrates how PLpgSQL, PostgreSQL can be applied to a real-world Internet of Things (IoT) problem.

3. Key Features / Modules

Automatically log your voyages without manually starting or stopping a trip.
Automatically capture the details of your voyages (boat speed, heading, wind speed, etc).
Timelapse video your trips, with or without time control.
Add custom notes to your logs.
Export to CSV, GPX, GeoJSON, KML and download your logs.
Export your logs as image (PNG) or video (MP4).
Aggregate your trip statistics: Longest voyage, time spent at anchorages, home ports etc.
See your moorages on a global map, with incoming and outgoing voyages from each trip.
Monitor your boat (position, depth, wind, temperature, battery charge status, etc.) remotely.
History: view trends.

4. Technology Stack

PLpgSQLPostgreSQL

5. System Requirements

General requirements for this technology stack — check the README for exact versions.

See the project README for exact requirements
Git (to clone the repository)

6. Installation & Setup

git clone https://github.com/xbgmsharp/postgsail.git
cd postgsail

Full setup instructions are in the project README.

7. Future Enhancements

Suggested extensions you can add to make this your own project.

Add a mobile dashboard using Blynk or Firebase
Store readings in a cloud database for history charts
Add alerts via SMS / Telegram when thresholds are crossed

8. Viva / Review Questions

Common questions examiners ask for projects in this domain.

Which microcontroller / board and sensors are used and why?
How does the device send data (Wi-Fi, MQTT, HTTP, Bluetooth)?
Where is the sensor data stored and visualised?
How is power consumption managed?
How would you secure the device and its communication?

9. Source Code & License

This project is developed by xbgmsharp and published on GitHub under the Apache License 2.0. Please follow the license terms and credit the original author when you use or modify this code.

View Source on GitHub Download ZIP

Want to build this as your internship project?

Work on an Internet of Things (IoT) project like this with mentor guidance, weekly reviews and an internship certificate from Training Trains, Erode — online or offline.

Apply for Internet of Things (IoT) Internship