warehack.ing/pg_orrery
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
pg_orrery/src
History
Ryan Malloy 501872d45d v0.15.0: constellation full name lookup, rise/set status diagnostics 
constellation_full_name(text) returns full IAU name from 3-letter
abbreviation (88-entry static table, IMMUTABLE). Returns NULL for
invalid input — composable with constellation() in queries.

Three rise_set_status functions classify body visibility as
'rises_and_sets', 'circumpolar', or 'never_rises' by sampling
elevation at 48 points across 24h. Separate diagnostic path —
called only when rise/set returns NULL, zero cost in normal case.

147 → 151 SQL objects. 25 → 26 regression suites. All pass.
2026-02-25 19:38:52 -07:00
..
sgp4
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
astro_math.h
Add v0.13.0: nutation, make_equatorial constructor, rise/set predictions
2026-02-25 13:53:22 -07:00
constellation_data.c
v0.15.0: constellation full name lookup, rise/set status diagnostics
2026-02-25 19:38:52 -07:00
constellation_data.h
v0.15.0: constellation full name lookup, rise/set status diagnostics
2026-02-25 19:38:52 -07:00
constellation_funcs.c
v0.15.0: constellation full name lookup, rise/set status diagnostics
2026-02-25 19:38:52 -07:00
coord_funcs.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
de_funcs.c
Add v0.12.0: equatorial GiST operator class + DE moon equatorial functions
2026-02-24 13:15:34 -07:00
de_reader.c
Harden DE reader: layout validation, Chebyshev clamping, FD safety
2026-02-17 00:20:31 -07:00
de_reader.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
eci_type.c
Initial implementation of pg_orbit PostgreSQL extension
2026-02-15 17:07:07 -07:00
elliptic_to_rectangular.c
pg_orbit 0.2.0: Full solar system computation at the SQL layer
2026-02-16 01:36:27 -07:00
elliptic_to_rectangular.h
pg_orbit 0.2.0: Full solar system computation at the SQL layer
2026-02-16 01:36:27 -07:00
elp82b.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
elp82b.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
eph_provider.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
eph_provider.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
equatorial_funcs.c
Add v0.13.0: nutation, make_equatorial constructor, rise/set predictions
2026-02-25 13:53:22 -07:00
gist_equatorial.c
Add v0.12.0: equatorial GiST operator class + DE moon equatorial functions
2026-02-24 13:15:34 -07:00
gist_tle.c
Add v0.9.0 apparent position features: equatorial type, refraction, proper motion, light-time
2026-02-21 15:31:46 -07:00
gust86.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
gust86.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
kepler_funcs.c
Add v0.13.0: nutation, make_equatorial constructor, rise/set predictions
2026-02-25 13:53:22 -07:00
kepler.h
Add v0.9.0 apparent position features: equatorial type, refraction, proper motion, light-time
2026-02-21 15:31:46 -07:00
l12.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
l12.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
lambert.c
Phase 4: Lambert transfer orbit solver for interplanetary trajectories
2026-02-16 02:00:09 -07:00
lambert.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
marssat.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
marssat.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
moon_funcs.c
Add v0.11.0: make_orbital_elements constructors + moon equatorial functions
2026-02-23 14:07:39 -07:00
observer_type.c
Add convenience functions for Craft integration
2026-02-15 17:44:41 -07:00
od_funcs.c
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
od_iod.c
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
od_iod.h
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
od_math.c
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
od_math.h
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
od_solver.c
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
od_solver.h
Add range rate fitting, weighted observations, and Gauss angles-only IOD (v0.6.0)
2026-02-17 17:48:13 -07:00
orbital_elements_type.c
Harden v0.11.0 constructors: NaN/Inf guards, expanded error path tests
2026-02-23 14:25:43 -07:00
pass_funcs.c
Add v0.9.0 apparent position features: equatorial type, refraction, proper motion, light-time
2026-02-21 15:31:46 -07:00
pg_orrery.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
planet_funcs.c
Add v0.10.0: aberration, DE apparent, angular separation, stellar parallax
2026-02-21 21:47:42 -07:00
precession.c
pg_orbit 0.2.0: Full solar system computation at the SQL layer
2026-02-16 01:36:27 -07:00
precession.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
radio_funcs.c
Phase 3: Planetary moons and Jupiter radio burst prediction
2026-02-16 01:55:13 -07:00
refraction_funcs.c
Add v0.9.0 apparent position features: equatorial type, refraction, proper motion, light-time
2026-02-21 15:31:46 -07:00
rise_set_funcs.c
v0.15.0: constellation full name lookup, rise/set status diagnostics
2026-02-25 19:38:52 -07:00
sgp4_funcs.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
sidereal_time.c
pg_orbit 0.2.0: Full solar system computation at the SQL layer
2026-02-16 01:36:27 -07:00
sidereal_time.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
spgist_tle.c
Fix L1 inclination pruning for HEO orbits, add 66k benchmark
2026-02-17 23:05:49 -07:00
star_funcs.c
Add v0.13.0: nutation, make_equatorial constructor, rise/set predictions
2026-02-25 13:53:22 -07:00
tass17.c
Phase 3: Planetary moons and Jupiter radio burst prediction
2026-02-16 01:55:13 -07:00
tass17.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
tle_type.c
Add convenience functions for Craft integration
2026-02-15 17:44:41 -07:00
transfer_funcs.c
Phase 4: Lambert transfer orbit solver for interplanetary trajectories
2026-02-16 02:00:09 -07:00
types.h
Add v0.9.0 apparent position features: equatorial type, refraction, proper motion, light-time
2026-02-21 15:31:46 -07:00
vsop87.c
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00
vsop87.h
Rename pg_orbit to pg_orrery
2026-02-17 13:36:22 -07:00