mirrors/postgsail
1
0
Fork 0
mirror of https://github.com/xbgmsharp/postgsail.git synced 2025-09-16 18:57:48 +00:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • f4d9aacf4d Update tests versions, postgis 3.6.0, timescaledb 2.22.0 main xbgmsharp 2025-09-07 09:37:56 +02:00
  • f56bb6f538 Add stats sql unit tests v0.9.4 xbgmsharp 2025-09-04 22:02:44 +02:00
  • d1578e3786 Update migration 202508 xbgmsharp 2025-09-04 21:58:45 +02:00
  • 3bda948646 Release 0.9.4 xbgmsharp 2025-09-04 21:55:21 +02:00
  • 45b2e3f28f Update docker image for tests xbgmsharp 2025-09-04 21:54:52 +02:00
  • 7ec74d7b82 Update tests versions, PostgREST 13.0.6 xbgmsharp 2025-09-04 21:52:19 +02:00
  • 759a51d426 Update openapi documentation xbgmsharp 2025-09-04 21:23:39 +02:00
  • 0b76cb3d0f Update SQL corn tests unit xbgmsharp 2025-09-04 21:23:04 +02:00
  • b4b0c1d014 Update migration 202508 - Improve Lint support - Update new account email subject - Update first badge message - Add public.stay_delete_trigger_fn trigger function to delete stays_ext and process_queue entries - Create trigger to delete stays_ext and process_queue entries - Remove trigger that duplicate the OTP validation entry on insert for new account, it is handle by api.login - Update api.login function to handle user disable and email verification, update error code with invalid_email_or_password - Update cron_windy_fn to support custom user metrics - Update merge_logbook_fn to handle more metrics and limit moorage deletion - Add api.counts_fn to count logbook, moorages and stays entries - Allow user_role to delete on api.stays_ext xbgmsharp 2025-09-04 18:40:36 +02:00
  • ee44420e30 Merge pull request #22 from lokasoft/main xbgmsharp 2025-08-31 09:20:05 +02:00
  • 5f25a57c3c Added self hosted update guide Lex 2025-08-30 11:51:36 +02:00
  • 883c875e39 CLeanup xbgmsharp 2025-08-28 18:37:45 +02:00
  • 0282823938 Clean up xbgmsharp 2025-08-28 18:37:29 +02:00
  • 4546b75e0d Cleanup tests script xbgmsharp 2025-08-28 18:37:11 +02:00
  • 0c28ed6a0f Update docs README xbgmsharp 2025-08-28 18:36:54 +02:00
  • 57a754cdc0 Update tests versions, PostgREST 13.0.5 xbgmsharp 2025-08-27 22:39:45 +02:00
  • 46f16fb077 Update README, add deepwiki xbgmsharp 2025-08-24 09:43:23 +02:00
  • a9d993cc42 Bump actions/checkout from 4 to 5 dependabot/github_actions/actions/checkout-5 dependabot[bot] 2025-08-18 21:44:26 +00:00
  • 4c80d041cc Update tests versions, PostgreSQL 16.10, timescaledb 2.21.3 xbgmsharp 2025-08-18 19:36:57 +02:00
  • 12e4baf662 Release PostgSail 0.9.3 v0.9.3 xbgmsharp 2025-08-03 10:37:02 +02:00
  • faf62ed9a3 Update tests, PostgSail 0.9.3 xbgmsharp 2025-08-02 16:15:12 +02:00
  • 40bdb9620f Update tests, PostgSail 0.9.3 xbgmsharp 2025-08-02 16:13:29 +02:00
  • 8fe84ea80c Update migration 202507 - Update plugin upgrade message - Update api.login, update the connected_at field to the current time - Update monitoring_history_fn to use custom user settings for metrics - Update cron_alerts_fn to check for alerts, filters out empty strings (""), so they are not included in the result. - Update process_pre_logbook_fn to detect and avoid logbook we more than 1000NM in less 15h xbgmsharp 2025-08-02 16:07:29 +02:00
  • 54eefe582d Update migration 202505 - Update monitoring view to with true wind speed xbgmsharp 2025-08-02 11:31:32 +02:00
  • d60af8c7b0 Update tests, TimescaleDB: 2.21.1 xbgmsharp 2025-08-02 10:40:43 +02:00
  • b505c98723 Update README xbgmsharp 2025-08-02 10:32:14 +02:00
  • 976ea85538 Update logbook tests xbgmsharp 2025-07-14 08:56:48 +02:00
  • 347af573c2 Update tests versions, timescaledb 2.21.0 xbgmsharp 2025-07-14 08:56:17 +02:00
  • 60ba821af7 Update tests, add stays_ext unit tests xbgmsharp 2025-06-22 10:42:33 +02:00
  • 9759045b0a Update tests versions, PostgREST 13.0.4 xbgmsharp 2025-06-22 10:41:33 +02:00
  • a6c351c936 Update web UI front-end to v0.1.0-beta16 xbgmsharp 2025-06-21 13:00:39 +02:00
  • b7efb9636f Release 0.9.2 v0.9.2 xbgmsharp 2025-06-15 22:22:55 +02:00
  • 14d19a5394 Update migration 202505. - Update metadata_ext table add REFERENCES and image_url - Add stays_ext, new table to store vessel extended stays from user - Update metadata_update_configuration_trigger, make sure it runs only when need. - Create update_stays_ext_decode_base64_image_trigger_fn to decode base64 image - Update function public.autodiscovery_config_fn and cron_process_autodiscovery_fn, hanlde no metric available - Create api.stays_image to fetch stays image - Update api.vessel_image to fetch boat image - Update public.stay_active_geojson_fn function to produce a GeoJSON with the last position and stay details and anchor details - Update api.monitoring_live, add anchor support - Create view api.noteshistory_view, List stays and moorages notes order by stays - Udpate public.process_stay_queue_fn, replace '0 day' stay name by 'short stay' name - Create view api.logs_geojson_view, List logs with geojson - Create view api.moorages_geojson_view, List moorages with geojson - Create api.export_vessel_geojson_fn, export vessel as geojson - Update api.export_logbook_geojson_linestring_trip_fn, add more trip properties to geojson - Update api.export_logbook_geojson_trip_fn, add more trip properties to geojson - Update api.export_logbooks_geojson_linestring_trips_fn, add more trip properties to geojson - Update TABLE api.stays_ext with ROW LEVEL SECURITY xbgmsharp 2025-06-15 22:13:53 +02:00
  • 66b61f9d65 Update tests versions, timescaledb 2.20.3 xbgmsharp 2025-06-15 19:35:59 +02:00
  • b50c8f5007 Udpate REST API openAPI documentation xbgmsharp 2025-06-09 10:19:44 +02:00
  • a9e1990184 Update postgsail ERD xbgmsharp 2025-06-09 10:19:03 +02:00
  • 59b52515e3 Update tests versions, timescaledb 2.20.2, PostgREST 13.0.2 Add stays_ext, metadata_ext table xbgmsharp 2025-06-09 10:18:46 +02:00
  • f528456c08 Update migration 202505. - Create trigger to process metadata for autodiscovery_config provisioning - Create function public.autodiscovery_config_fn, to generate autodiscovery monitoring configuration - Create cron_process_autodiscovery_fn to process autodiscovery config provisioning - Refactor metadata_upsert_trigger_fn with the new metadata schema, remove id and check valid mmsi. - Update email_templates table, add new autodiscovery template xbgmsharp 2025-05-25 15:49:05 +02:00
  • a76c25b19f Update cron process output, add autodiscovery xbgmsharp 2025-05-25 15:47:37 +02:00
  • 00d2247549 Update cron job tests. Add support for autodiscovery xbgmsharp 2025-05-25 10:57:38 +02:00
  • b84ac31da1 Update grafana tests xbgmsharp 2025-05-25 10:57:03 +02:00
  • 63cf5d24a5 Update tests versions, postgis 3.5.3 xbgmsharp 2025-05-25 10:55:42 +02:00
  • fe7c1dc1e5 Update metadata table test xbgmsharp 2025-05-20 22:03:10 +02:00
  • 10a26942c7 Update API schema xbgmsharp 2025-05-20 22:02:30 +02:00
  • a5fb08fa42 Update ERD xbgmsharp 2025-05-20 22:02:21 +02:00
  • 25c74fd75a Update migration 202505 - Update metadata table coluonm type MMSI to text - Update metadata upsert trigger, to ignore non-valid mmsi - Update api.monitoring_live, fix invalid path tipo - Update public.logbook_update_metrics_timebucket_fn, fix invalid path tipo and query - Update public.logbook_update_metrics_fn, fix invalid path tipo - Update public.logbook_update_metrics_short_fn, fix invalid path tipo xbgmsharp 2025-05-20 21:58:00 +02:00
  • fa45782553 Update migration query order xbgmsharp 2025-05-19 23:32:02 +02:00
  • e237391e8a Update API doc xbgmsharp 2025-05-19 23:20:01 +02:00
  • dcf4eaca9b Add migration 202505 - Update metadata table, add IP address column, remove id column, update vessel_id default - Add metadata_ext, new table to store vessel extended metadata from user - Cleanup trigger on api schema, Move trigger on public schema - Create trigger to update polar_updated_at and image_updated_at accordingly - Create update_metadata_ext_decode_base64_image_trigger_fn to decode base64 image - Refactor metadata_upsert_trigger_fn with the new metadata schema, remove id. - Update metadata_grafana_trigger_fn with the new metadata schema, remove id. - Create api.vessel_image to fetch vessel image - Create api.vessel_extended_fn() to expose extended vessel details - Update api.vessel_details_fn to use configuration metadata - Update api.vessel_fn to use metadata_ext - Update public.stay_active_geojson_fn function to produce a GeoJSON with the last position and stay details - Update monitoring view to support live moorage in GeoJSON - Update public.overpass_py_fn to check for seamark with name - Update api.export_logbooks_geojson_linestring_trips_fn, add extra, _to_moorage_id, _from_moorage_id metadata - Update api.monitoring_live, add live tracking view, Add support 6h outside barometer - Update public.logbook_update_metrics_short_fn, aggregate more metrics and use user configuration - Update public.logbook_update_metrics_fn, aggregate more metrics and use user configuration - Update public.logbook_update_metrics_timebucket_fn, aggregate more metrics and use user configuration - Update public.process_logbook_queue_fn to use new mobilitydb metrics - Remove unnecessary functions - Add missing comments on function - Update public.cron_process_monitor_online_fn, refactor of metadata - Update public.cron_process_monitor_offline_fn, Refactor metadata - Update public.cron_process_grafana_fn, Refactor metadata - Update permissions and RLS - Update cron_process_skplugin_upgrade_fn, update check for signalk plugin version xbgmsharp 2025-05-19 23:19:04 +02:00
  • ade15f538d Add more property in geojson linstring xbgmsharp 2025-05-17 18:42:01 +02:00
  • f2cf604dab Add more property in geojson linstring xbgmsharp 2025-05-17 17:22:51 +02:00
  • ad2e95bfa8 Update metadata tests, Refactor metadata table, Add metadata_ext tests xbgmsharp 2025-05-17 17:22:24 +02:00
  • 02130a9e4f Update grafana tests, refactor metadata table xbgmsharp 2025-05-17 17:22:05 +02:00
  • 29fa3863eb Update ERD, refactor metadata table xbgmsharp 2025-05-17 17:20:46 +02:00
  • 7cd06fced4 Update tests versions, timescaledb 2.20.0 xbgmsharp 2025-05-17 17:20:03 +02:00
  • 564b85f58c Update postgsail ERD xbgmsharp 2025-05-11 14:41:10 +02:00
  • da317dce87 Update tests, trying to improve overpass-api results xbgmsharp 2025-05-11 14:30:38 +02:00
  • 08ee757fa5 Update tests versions, PostgreSQL 16.9, PostgREST 12.3.0 xbgmsharp 2025-05-11 14:29:18 +02:00
  • 76ade18d6b Update API doc xbgmsharp 2025-05-11 14:27:03 +02:00
  • e6852a43f1 Update README xbgmsharp 2025-05-11 14:26:49 +02:00
  • 13f8240838 Release 0.9.1-202504 v0.9.1 xbgmsharp 2025-05-04 22:41:27 +02:00
  • b7fe6a27b2 Update tests versions, PostgREST 12.2.12 xbgmsharp 2025-05-04 22:41:13 +02:00
  • 29cc40f6de Update SQL comments xbgmsharp 2025-05-04 22:32:42 +02:00
  • 861e61d378 Update sql tests, name change in OSM data xbgmsharp 2025-05-04 22:27:15 +02:00
  • 684f34644f Update tests, improve and add more test xbgmsharp 2025-05-04 22:26:37 +02:00
  • 6ad9980cd2 Update tests, Update api.eventlogs_view skip the new_stay xbgmsharp 2025-05-04 22:25:48 +02:00
  • 7f5974efe2 Update tests, Remove deprecated client_id xbgmsharp 2025-05-04 22:25:08 +02:00
  • f4b65d3156 Update README.md xbgmsharp 2025-05-04 22:23:41 +02:00
  • d8ef8b8958 Add migration 202504 - Install and update TimescaleDB Toolkit - Remove deprecated client_id - Remove index from logbook columns - Remove deprecated column from api.logbook - Add new mobilityDB support with comments - Update api.export_logbook_geojson_linestring_trip_fn, add more metadata properties - Update public.check_jwt, Make new mobilitydb export geojson function anonymous access - Create api.monitoring_upsert_fn, the function that update api.metadata monitoring configuration - Update cron_process_skplugin_upgrade_fn, update check for signalk plugin version - Update api.find_log_from_moorage_fn using the mobilitydb trajectory - Update api.find_log_to_moorage_fn using the mobilitydb trajectory - Update api.eventlogs_view to fetch the events logs backwards and skip the new_stay - Update api.stats_logs_fn, ensure the trip is completed - Update api.stats_fn, ensure the trip is completed - Update moorage_delete_trigger_fn, When morrage is deleted, delete process_queue references as well. - Create public.logbook_delete_trigger_fn, When logbook is deleted, logbook_ext need to deleted as well. - Update metadata table, mark client_id as deprecated - Update public.process_lat_lon_fn, Add new moorage refrence in public.process_queue for event logs review - Add Description on missing trigger - Update public.logbook_active_geojson_fn, fix log_gis_line as there is no end time yet - Create public.stay_active_geojson_fn function to produce a GeoJSON with the last position and stay details - Update monitoring view to support live moorage in GeoJSON - Add api.monitoring_live view, the live tracking view - Refresh permissions xbgmsharp 2025-05-04 22:23:00 +02:00
  • 686ac7498b Update web UI front-end to v0.1.0-beta15 xbgmsharp 2025-05-04 22:17:20 +02:00
  • d4c4347a4c Update web UI front-end to v0.1.0-beta14 xbgmsharp 2025-04-26 10:20:06 +02:00
  • 4aacae3913 Update tests versions, PostgREST 12.2.11 xbgmsharp 2025-04-26 10:06:48 +02:00
  • 06fd834441 Update metadata tests, ensure a reuslt for api.metadata.configuration base on update_at value xbgmsharp 2025-04-21 23:42:12 +02:00
  • 86bd4b5843 Update SQL tests, update event logs view revert b6fef6358a xbgmsharp 2025-04-21 23:40:54 +02:00
  • 111d7d36db Update tests versions, timescaledb_toolkit 1.21.0, timescaledb 2.19.3, PostgREST 12.2.10 xbgmsharp 2025-04-21 22:32:00 +02:00
  • b6fef6358a Update SQL tets, update event logs view xbgmsharp 2025-04-13 08:35:06 +02:00
  • 4aecea7532 Update tests versions, timescaledb 2.19.2 xbgmsharp 2025-04-13 08:34:28 +02:00
  • c8908748f7 Update Update ERD - update logbook metrics xbgmsharp 2025-04-06 22:36:40 +02:00
  • 0e812c0939 Update mobilityDB unit sql tests, new geojson properties xbgmsharp 2025-04-06 09:26:55 +02:00
  • 395b7cfad7 Update sql unit test, Improve anymous test xbgmsharp 2025-04-06 00:00:26 +02:00
  • 14e8c8363c Update OpenAPI xbgmsharp 2025-04-05 23:59:52 +02:00
  • 448124f01b Update Update ERD - Deprecated client_id - Add new logbook metrics xbgmsharp 2025-04-05 23:58:46 +02:00
  • 3b466e3d93 Update tests versions, Add timescaledb_toolkit 1.19.0 xbgmsharp 2025-04-04 14:17:58 +02:00
  • f0ddca7d58 Update tests versions, timescaledb 2.19.1 xbgmsharp 2025-04-04 14:16:30 +02:00
  • 7744ad4af9 Release 0.9.0-202503 v0.9.0 xbgmsharp 2025-03-31 17:38:52 +02:00
  • 5c70a9a453 Update cron_post_jobs output xbgmsharp 2025-03-31 13:37:42 +02:00
  • 6635015dbf Update mobilitydb SQL test xbgmsharp 2025-03-31 13:37:26 +02:00
  • f285fcddb0 Add migration 202503 - Update metadata table, mark client_id as deprecated - Update metadata table update configuration column type to jsonb - Update metadata table add new column available_keys - Update metadata_upsert_trigger_fn to metadata table - Add metadata table tigger for update_metadata_configuration - Update api.export_logbook_geojson_linestring_trip_fn, add metadata - Add public.get_season, return the season based on the input date for logbook tag - Refresh permissions xbgmsharp 2025-03-31 13:34:39 +02:00
  • cabf405648 Update mobilitydb SQL test xbgmsharp 2025-03-31 13:32:56 +02:00
  • b2f3372b26 Update API tests - Deprecated client_id - Update configuration - Add available_keys xbgmsharp 2025-03-31 13:32:19 +02:00
  • 754c9bb6e7 Update tests versions, PostgSail 0.9.0, timescaledb 2.19.0 xbgmsharp 2025-03-31 13:30:12 +02:00
  • f9238c62dd Update OpenAPI xbgmsharp 2025-03-31 13:29:22 +02:00
  • 4a294674e8 Add metadata SQL unit test xbgmsharp 2025-03-31 13:29:03 +02:00
  • 83e92cfd6c Add metadata SQL test xbgmsharp 2025-03-31 13:28:42 +02:00
  • 718ca6d6ea Update grafana SQL tests - Deprecated client_id - Update configuration - Add available_keys xbgmsharp 2025-03-31 13:28:17 +02:00
  • a07f4f181c Update Update ERD - Deprecated client_id - Update configuration - Add available_keys xbgmsharp 2025-03-31 13:27:09 +02:00
  • 72b06f9eb9 Update README xbgmsharp 2025-03-14 16:01:23 +01:00
  • 598a789d36 Update docker compose file, remove deprecated version xbgmsharp 2025-02-27 15:19:11 +01:00
  • 37e948cb20 Update tests versions, PostgreSQL 16.8, timescaledb 2.18.2 PostgREST 12.2.8 xbgmsharp 2025-02-27 15:17:53 +01:00
  • f26ece878b Update tests versions, PostGIS 3.5.2, timescaledb 2.18.0, PostgREST 12.2.6 xbgmsharp 2025-02-02 09:47:07 +01:00