v0.8.1

Re-Architected from the Ground Up

This version features a robust new core, optimized for performance and scalability. The revamped architecture ensures smoother operations and seamless integration.

Comprehensive Trip Logging

Analyze depth trends, fuel consumption, engine performance, and more to gain a deeper understanding of your vessel’s performance and optimize your adventures.

What's Changed

• Full support for MobilityDB
• Update documentation
• Update tests to support for MobilityDB
• Add new mobilityDB column
• Remove deprecated column from api.logbook
• Remove deprecated column from api.moorages
• Update api.moorage_view, due to stay_duration column removal
• Update stats_moorages_view, due to stay_duration column removal
• Update stats_moorages_away_view, due to stay_duration column removal
• Update public.logbook_update_metrics_short_fn, aggregate more metrics
• Update public.logbook_update_metrics_fn, aggregate more metrics
• Update public.logbook_update_metrics_timebucket_fn, aggregate more metrics
• Update api.merge_logbook_fn, add support for mobility temporal type
• Create api.export_logbook_geojson_point_trip_fn, transform spatiotemporal trip into a geojson with the corresponding properties
• Update api.export_logbook_geojson_point_trip_fn, fix dynamic notes
• Update api.stats_fn, due to reference_count and stay_duration columns removal
• Update api.stats_stays_fn, due to reference_count and stay_duration columns removal
• Update log_view with dynamic GeoJSON, change geojson export fn
• Update delete_trip_entry_fn, support additional temporal sequence columns (depth,etc...)
• Update export_logbook_geojson_trip_fn, update geojson from trip to geojson additional temporal sequence columns (depth,etc...)
• Update api.export_logbook_geojson_point_trip_fn, update geojson from trip to geojson additional temporal sequence columns (depth,etc...)
• Update public.process_lat_lon_fn remove deprecated moorages columns
• Update logbook table, add support for mobility temporal type
• Update public.badges_geom_fn remove track_geom and use mobilitydb trajectory
• Update public.process_stay_queue_fn remove calculation of stay duration and count
• Update public.badges_moorages_fn remove calculation of stay duration and count
• Update api.find_log_from_moorage_fn using the mobilitydb trajectory
• Update api.find_log_to_moorage_fn using the mobilitydb trajectory
• Update api.delete_logbook_fn to delete moorage dependency using mobilitydb
• Update public.qgis_bbox_py_fn to use mobilitydb trajectory
• Update public.qgis_bbox_trip_py_fn to use mobilitydb trajectory
• Update Self‐hosted-installation-guide on AWS.md by @mmdevs in #14

Full Changelog: v0.8.0...v0.8.1

v0.8.0

-- Update PostgreSQL 16.6, TimescaleDB: 2.17.2, PostGIS: 3.5.0
-- Add new documentation @mmdevs
-- Add MobilityDB support
-- Update logbook tbl, add trip from mobilitydb
-- Update logbook table, add support for mobility temporal type
-- Add api.export_logbook_geojson_linestring_trip_fn, transform spatiotemporal trip into a geojson with the corresponding properties
-- Add api.export_logbook_geojson_point_trip_fn, transform spatiotemporal trip into a geojson with the corresponding properties
-- Add logbook_update_geojson_trip_fn, update geojson from trip to geojson
-- Add api.export_logbook_gpx_trip_fn, update gpx from a trip
-- Add api.export_logbook_kml_trip_fn, update kml from a trip
-- Add api.export_logbook_geojson_linestring_trip_fn, replace timelapse_fn, transform spatiotemporal trip into a geojson with the corresponding properties
-- Add export_logbooks_geojson_point_trips_fn, replace timelapse2_fn, Generate the GeoJSON from the time sequence value
-- Add export_logbook_geojson_trip_fn, update geojson from trip to geojson
-- Update api.export_logbooks_gpx_trips_fn
-- Update api.export_logbooks_kml_trips_fn
-- Add update_trip_notes_fn, add temporal sequence into a trip notes
-- Add delete_trip_entry_fn, delete temporal sequence into a trip
-- Update log_view with dynamic GeoJSON from trip
-- Update api.vessels_view
-- Update api.versions_fn(), add mobilitydb
-- Update metrics_trigger_fn, Ignore entry if new time is in the future.
-- Update Monitor offline, check metadata tbl and metrics tbl, reduce flapping
-- Update moorages_view, make arrivals&departure and total_duration computed data
-- Update moorage_view, make arrivals&departure and total_duration computed data, add total visits
-- Update moorages map, use api.moorage_view as source table
-- Update mapgl_fn, refactor function using existing function
-- Update api.export_moorages_gpx_fn, use moorage_view as source to include computed data
-- Add api.export_moorages_kml_fn, export all moorages as kml
-- Update public.process_pre_logbook_fn, update stationary detection, if we have less than 20 metrics or less than 0.5NM or less than avg 0.5knts
-- Update api.export_logbook_kml_fn
-- Allow users to update certain columns on specific TABLES on API schema
-- Refresh user_role permissions

Full Changelog: v0.7.8...v0.8.0

v0.7.8

• Update moorages map, export more properties (notes,reference_count) from moorages tbl
• Update mapgl_fn, update moorages map sub query to export more properties (notes,reference_count) from moorages tbl
• Update logbook_update_geojson_fn, fix corrupt linestring properties
• Add trigger to update logbook stats from user edit geojson

Full Changelog: v0.7.7...v0.7.8

v0.7.7

• Add new email template account_inactivity
• Update HTML email for new logbook
• Update stats_logs_fn, update debug
• Fix stays and moorage statistics for user by date
• Update api.stats_moorages_view, fix time_spent_at_home_port
• Add stats_fn, user statistics by date
• Add mapgl_fn, generate a geojson with all logs as linestring and moorages
• Add cron_inactivity_fn, cleanup all data for inactive users and vessels
• Add cron_deactivated_fn, delete all data for inactive users and vessels
• Remove unused and duplicate function, cron_process_no_activity_fn
• Update tests (5551376, 5551376, c792bf8)
• Update openapi documentation
• Update github workflows

Full Changelog: v0.7.6...v0.7.7

v0.7.6

• Update public.process_lat_lon_fn, Ensure name without double quote, Fix issue with when string contains quote
• Update public.qgis_bbox_trip_py_fn, Add error handling for invalid argument
• Update public.qgis_bbox_py_fn, Add error handling for invalid argument
• Update public.get_app_settings_fn, Add new qgis and video URLs settings
• Update public.process_post_logbook_fn, Remove qgis dependency, Add logbook_stats
• Update public.cron_alerts_fn, Update alert message. Add the date and format the numeric value
• Update public.metrics_trigger_fn, CleanUp DEBUG print, ensure only one "new_stay" insert.
• Update public.check_jwt, reset config value Set default settings to avoid sql shared session cache for every new HTTP request
• Update public.send_email_py_fn, Update HTML email for new logbook email
• Update deactivated email template
• Update new logbook email template
• Update role authenticator, set api role SQL connection to 30
• Update table auth.vessels, Remove CONSTRAINT unique email for vessels table, Create new index for vessels table

Full Changelog: v0.7.5...v0.7.6

v0.7.5

• Add video error notification message
• Add CRON for new video notification
• Add export logbooks as png from webserver
• Add missing comment on function cron_process_no_activity_fn
• Update public.cron_alerts_fn, Fix error when stateOfCharge is null. Make stateOfCharge null value assume to be charge 1.
• Update api.export_logbooks_gpx_fn, Fix error: None of these media types are available: text/xml
• Update grafana provisioning, ERROR: KeyError: 'secureJsonFields'
• Update grafana,qgis,api role SQL connection to 30
• Update video cronjob
• Create qgis schema for qgis projects

Full Changelog: v0.7.4...v0.7.5

v0.7.4

Full Changelog: v0.7.2...v0.7.4

v0.7.2

Full Changelog: v0.7.1...v0.7.2

v0.7.1

Full Changelog: v0.7.0...v0.7.1

v0.7.0

Full Changelog: v0.6.1...v0.7.0