Abstract: The hydrodynamic shape, which incorporates superior turning maneuverability and gliding stability, is an important factor for underwater gliders (UGs) to realize remarkable endurance. In ...

-- Create a security definer function to fetch a glider by ID CREATE OR REPLACE FUNCTION public.fetch_glider_by_id(p_glider_id TEXT) ...

-- Create correct partial unique index: only one primary per glider CREATE UNIQUE INDEX IF NOT EXISTS unique_primary_per_glider ...