Skip to content

v0.12.0

Choose a tag to compare

View all tags
@xbgmsharp xbgmsharp released this 14 Jun 17:55
· 14 commits to main since this release
v0.12.0
fbc6823

What's Changed

  • Refactor tests HTTP and SQL
  • Migration vessel scope data to api.metadata table

In details

  • Improve tests HTTP and SQL
  • Migrate preferences.monitoring → metadata.configuration
  • Migrate alarms + alert_last_metric + alerting → metadata.user_data
  • alerting is now vessel-scoped in user_data
  • Add language default
  • Replace generic moddatetime trigger with conditional version
  • Optimise update_metadata_userdata_added_at_trigger_fn
  • Update get_user_settings_from_vesselid_fn
  • Add api.update_metadata_userdata_fn for merging updates into metadata.user_data from cron functions and user vessel-settings edits.
  • Index optimizations for cron_alerts_fn queries on metadata.user_data
  • Update cron_alerts_fn, alerting thresholds: read from metadata.user_data (moved from preferences)
  • Update api.settings_fn, simplified to account-level identity only
  • Add api.vessel_settings_fn, Returns vessel-scoped configuration and operational state for the vessel
  • Add api.update_vessel_settings_fn, Mirrors the key/value pattern of api.update_user_preferences_fn
  • Update api.profile_fn, only expose relevant data to MCP or bot
  • Update api.signup, enforce new preferences defaults
  • Add api.vessel_view, replace multiple vessel function and align design
  • Update api.graph_logs_by_year_week_fn, update output to an array
  • Update api.vessel_activity_fn, align output with pct.
  • Add api.logs_tags_fn, sorted list of distinct tags across all completed log entries for the current vessel
  • Update cron_alerts_fn, fix voltage casting issue
  • Update api.stats_stays_fn, add safe start and end.
  • Update api.stats_logs_fn, add safe start and end.
  • Update api.stats_fn, include name and expose moorage name, plus add top countries for moorages.
  • Update api.badges_fn, rewrite in JSONB
  • Update api.graph_logs_by_week_fn, reduce security definer surface
  • Update api.vessel_extended_fn, add vessel specs
  • Update public.logbook_update_extra_json_fn, add tank level deltas and refactor to reduce redundant code
  • Update public.overpass_py_fn, increase timeout
  • Add api.pois_fn and public.wikipedia_py_fn
  • Update public.reverse_geocode_py_fn, add OSM identifiers
  • Update api.log_view, includes bbox (WGS84 [W,S,E,N] array)
  • Update moorage_view with refactored user_data logic, enforce vessel_id in query vs RLS. avoid join on stays_at (static reference data). Add stay first/last seen and log count. Add has_images boolean. Add stay_count and total_duration. Add stay_first_seen_id and stay_last_seen_id for linking to stays_at.
  • Update public.check_jwt, fix anonymous access

Full Changelog: v0.11.1...v0.12.0

🤝Contribute to the project

If you encounter a bug on any device or have suggestions for improvement, don't hesitate to open a bug report or pull request.

  • Github - Fix bugs, add features, or improve documentation
  • Discord - Chat with other users, share feedback, your ideas and help shape future updates
  • ❤️ Sponsor - Support ongoing development, fund the project, and show your appreciation
Assets 2
Loading